Microsoft Excel Interview Questions and Answers

Ques 1. What is Microsoft Excel?

Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.

Ques 2. What is ribbon?

The ribbon runs on the top of the application and is the replacement for the toolbars and menus.  The ribbons have various tabs on the top, and each tab has its own group of commands.

Ques 3. How can I hide or show the ribbon?

By pressing the CTRL key and pressing the F1 key to toggle you can see and hide the ribbon.

Ques 4. How you can sum up the Rows and Column number quickly in the excel sheet?

By using SUM function you can get the total sum of the rows and columns, in an excel worksheet.

Ques 5. How you can add a new excel worksheet?

To add a new Excel worksheet you have to insert worksheet tab at the bottom of the screen.

Ques 6. How you can resize the column in MS Excel?

To resize the column you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want.  The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.

Ques 7. What is the sequence of operating mathematical operation in Excel?

The order of sequence of operating is BEDMAS

• Brackets
• Exponents
• Division
• Multiplication
• Addition
• Subtraction

Ques 8. What is the benefit of using formula in excel sheet?

Calculating the numbers in excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculate automatically the number replaced by another number or digit.  Through excel sheet, the complex calculations becomes easy like payroll deduction or averaging the student’s result.

Ques 9. How do I Format data in MS Excel?

1. Must Always highlight the data before formatting 
2. Click Format 
3. Then go to Cells 

Ques 10. How do I resize Columns and Rows to better fit the data in MS Excel?

1. Move the mouse in between any two labels (Rows/numbers or Columns/letters) 
2. The pointer will turn into a vertical (letters) or horizontal (numbers) line with arrows on both ends 
3. Simply drag the column or row to the desired size 

Ques 11. Using Excel is there a way to close all open Excel files at once instead of closing them one at a time?

Yes, you can close down all your Excel files at once by using the following instructions: 
1. Hold down the Shift key. 
2. Choose File + Close All from the menu. Holding down the Shift key changes Excel's File + Close command to a File + Close All command.