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 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.
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.
  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.
For disabling the automatic sorting of data in pivot tables:

Click on more Sort Options > Right Click on  ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically’.
And the automatic sorting will be disabled.

Advanced Criteria Filter function is used to analyze the list or if more than two conditions have to be tested.
Yes, it is possible.  And it is done especially when data in the worksheets are not to be disclosed. To protect the sheet from copying, users need to follow these simple steps

Go to Menu bar > click on Review > select Protect Sheet > set a Password.  Hence, by setting a password, sheets can be secured from getting copied.

It is a table or kind of tool and it allows a quick summarization of data in large quantity. It performs functions like sorting, counting, total or average of the data that are saved in the spreadsheet and it displays the result in another spreadsheet. It saves a lot of time. It is one of the most helpful too and also allows to link external data sources to Excel sheet.
For locking any row or column, freeze panes function is used. The locked row or column will be visible on the screen even after the screen is a scroll.
Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells.
Just changing the pivot table options can stop format loss in a pivot table. In the “Pivot Table Options” select the “Enable Preserve Formatting” and just disable the function named “Auto Format” option.
There are three main report formats available, which are:
  • Compact
  • Report
  • Tabular
 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.
Following are the useful functions in MS Excel.
  • Date And Time Functions – Now(), Datevalue(), Weekday(Now())
  • Math And Financial Functions Like; Sqrt, Degree, Rand(), Gcd
  • Index Match – Vlookup And Index Match
  • Logical Functions  Like; If, And, False, True
  • Pivot Tables
In order to return to a specific area of the worksheet, name box can be used.  
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.