Jun

# Microsoft Excel Interview Questions

- Sanjay Mehra
- 14th Jun, 2022
- 851 Followers

#### Microsoft Excel Interview Questions

## Microsoft Excel questions

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

Candidates should try to know the importance and other uses of the application and should never forget to emphasize on the fact that with passing years the advancement in 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.

## Quick Questions About Microsoft Excel

What is Excel |
A spreadsheet developed by Microsoft. |

Developed By |
Microsoft |

Written In |
C#, C++, Microsoft Foundation Class Library, .NET Framework |

Operating system supported |
Windows, macOS, Android, and iOS. |

License |
Trialware, Proprietary commercial software |

First release |
1987 |

No. of Questions |
35 |

## Ms Excel Interview Questions

### 1) What is Microsoft Excel?

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.

### 2) Explain the spreadsheet.

Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells.

### 3) What do you mean by ribbon?

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.

### 4) How many types of data formats are available in Microsoft Excel for storing the data/ values? Name a few of them.

- 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.

### 5) 5 Specify the order of operations used for evaluating formulas in excel.

**PEMDAS**or

**BEDMAS**

- Parentheses or brackets.
- Exponent.
- Multiplication.
- Division.
- Addition.
- Subtraction.

### 6) How is text wrap done within a cell?

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.

### 7) What is meant by a macro in MS- Excel?

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.

### 8) What do you mean by charts in MS-Excel?

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.

### 9) Is it possible to sum up the Rows and Column number in the Excel sheet? If yes, then how is it possible?

### 10) Is it possible that users can prevent copying of the cell from any self-made worksheet?

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.

### 11) What are the useful functions in Microsoft Excel?

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

### 12) At the time of using MS Excel, a red triangle at the top right of a cell is visible. What does it indicate?

### 13) How is the new Excel worksheet added?

In order to add a new Excel worksheet, users can click on insert worksheet tab, which is visible at the bottom of the screen.

### 14) State the purpose of “Name Box” in MS-Excel?

In MS-Excel, "Name Box" is used for returning to an area of the worksheet, by means of typing the range name or cell address in the name box particular area can be found easily within a fraction of seconds.

### 15) Can a Pivot table use multiple sources of data?

Yes, the Pivot table can use multiple sources of data but only when the multiple sources are different worksheets, from the same workbook.

### 16) How can users check that the Pivot Table is modified?

### 17) How can you disable the automatic sorting of information in a pivot table?

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.

### 18) How can the user change the size of the column?

Firstly, there is a need to change the width of one column and drag it towards the boundary on the right side of the column heading till the required width.

Secondly, it can also be done by selecting the Format from the home tab, and in Format, one has to select **AUTOFIT COLUMN WIDTH** that is under cell section. Directly by clicking on this, the cell size will be formatted as required.

### 19) What are pivot tables and also mention its use?

### 20) In how many formats is a report available in Excel?

- Compact
- Report
- Tabular

### 21) How is Dynamic range provided in Data Source of Pivot Tables?

**Data Source**of Pivot tables, the users need to create a named range using the offset function available and then base the pivot table using a named range that was built in the first step.

### 22) What is the role of cell reference in the calculation in excel?

### 23) What do you mean by Freeze Panes in MS-Excel?

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.

### 24) What could be done in order to stop the pivot table from losing the column width while refreshing?

### 25) Explain types of workbook protection in Excel.

- Password protection for opening a workbook
- Protection for adding, deleting, hiding and unhiding of sheets
- Protection from changing size or position of windows.

### 26) What is the difference between SUBSTITUTE and REPLACE function in MS-Excel?

Syntax: SUBSTITUTE (text, old Text, new Text, [instance Number])

Whereas the REPLACE function swaps the part of the text string with another set of text. The Syntax for this is:

Syntax: REPLACE (old Text, start Number, Number Characters, new Text)

### 27) Differentiate between COUNT, COUNTA, COUNTIF, and COUNTBLANK in MS-Excel.

**COUNT** is used to count the cells that contain numbers, dates, etc. (any value stored as a number.)

**COUNTA** or **Count All** is such a function that is used to count any cell value containing numbers, text, logical values, etc.

**COUNTBLANK** is cell or cells with an empty string.

**COUNTIF** and **COUNTIFS** count cells matching any particular criteria.

### 28) What is IF function in Excel?

In order to perform various kind of logic tests, IF function is performed in excel. It verifies whether certain given conditions are true or false. If the condition is true, then it will give result accordingly if the condition is false then the result or output will be somewhat different.

### 29) What is the use of LOOKUP function in Excel?

### 30) In order to apply the same formatting to every sheet in a workbook in MS-Excel what needs to be done?

### 31) State the shortcut to move the previous worksheet and next sheet

### 32) What filter is used, if more than two conditions are used or if analysis of list has to be done where there are more than two conditions?

### 33) How can the users return to any particular area of a worksheet?

### 34) What is the benefit of using the formula in Excel sheet?

**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 an 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.

### 35) What is the role of AND function in Excel?

### 36) What is vlookup function in excel?

In simple words, the VLOOKUP function in Microsoft Excel **states: =VLOOKUP**(what item needs to be looked up, where you want to search for, column number in the range containing the value to return, return an approximate). VLOOKUP can be employed when you need to find things in a table or a range by row. To exemplify, look up the price of an automotive part by part number, or find an employee name based on their ID.

#### Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.