Microsoft Excel Interview Questions

Microsoft Excel Interview Questions

In the corporate world, MS Excel is one of the important tools which is often used by professionals. While preparing for interviews candidates one should know the technical terminology associated with this. Apart from the basic, there are few advanced level functions, which require a special attention. Given below is the list of thirty- five such questions, which covers up the basic and advance learning in MS Excel.

Candidate should try to know the importance and other uses of the application and should never forget to the emphasis on the fact that with passing years the advancement in the learning has taken place in MS Excel and work can be completed easily and effectively. From storing data to calculating various components, this application covers all the functions required.

Stated below is the list of few Microsoft Excel questions, which will help the candidates to prepare for interviews.

Download Microsoft Excel Interview Questions PDF

Microsoft Excel Interview Questions

 In order to apply the same formatting to every sheet in a workbook Click right ‘Worksheet tab’,> Choose ‘Select All Sheets’. Any kind of formatting done here will be applied to the whole workbook. In order to apply to a particular group of sheets, only that sheet has to be selected that needs formatting.
In order to move to the previous worksheet, the keys Ctrl + PgUp have to be used whereas to move to the next sheet Ctrl + PgDown key is to be used.
Advanced Criteria Filter function is used to analyze the list or if more than two conditions have to be tested.
In order to return to a specific area of the worksheet, name box can be used.  
Excel sheet is known for its simplicity, while in the process of calculation of the numbers in Excel sheet, along with giving the final ‘sum up’ of the number it also calculates the number replaced by another number or digit. In Excel sheet, the complexity of calculation becomes easy to like for example calculation of payroll deduction or the average result of the students in a class etc.
AND function also performs the logical function like IF function. To know whether the stated output is true or false. The AND function also evaluates the expression located in another cell in the spreadsheet.
Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organize, edit, and calculates data with the use of formulas. The whole spreadsheet is divided into rows and columns and accordingly, information’s are entered and values are calculated.
Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells.
 The topmost area on the Microsoft Excel that contains menu and other toolbar items are known as ribbon. CTRL+ F1 key is used as shortcuts key to show/hide it from the screen. It runs on the top of the application and acts as a replacement for toolbars and menu.
  There are eleven data formats available in Microsoft Excel. Few of them are;
  • Number – values are stored as a number
  • Currency – values are stored in the form of currency.
  • Date – Date is stored in date format
  • Percentage stores number in a percent form
  • Text formats stores data as strings of text.
The order of operations in Microsoft Excel is a standard format. It is basically defined by the terms PEMDAS or BEDMAS
  • Parentheses or brackets.
  • Exponent.
  • Multiplication.
  • Division.
  • Addition.
  • Subtraction.
Select the text that has to be a wrap, after selecting click on wrap text option available on home table Selected text will be a wrap.
In MS- Excel, the macro is used for iterating over a group of the task. It can be either in a written or recorded form. It depends upon the users to create macros for their customized and repetitive function.
Charts are used in order to enable graphical representation of the data in Excel file. It depends upon the user to select the chart type. Like column, bar, line, pie, scatter, etc. It can be used as the users select an option from Insert tab’s Chart group.
Yes, it is possible; users can sum up the rows and column number by using SUM function. The total sum of the rows and columns, in an Excel worksheet, can be calculated by this function.