Prepare Interview

Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Microsoft Excel Interview Questions and Answers

Test your skills through the online practice test: Microsoft Excel Quiz Online Practice Test

Freshers / Beginner level questions & answers

Ques 1. What is Microsoft Excel?

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

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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 

Is it helpful? Add Comment View Comments
 

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 

Is it helpful? Add Comment View Comments
 

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. 

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

Related interview subjects

Operating System interview questions and answers - Total 22 questions
Computer Networking interview questions and answers - Total 65 questions
Microsoft Excel interview questions and answers - Total 37 questions
Computer Basics interview questions and answers - Total 62 questions
Tips and Tricks interview questions and answers - Total 30 questions
©2023 WithoutBook