Interview Questions and Answers

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

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.

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

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

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

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.

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.

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

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 

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.