Excel Interview Questions Part 5

 01. On an excel sheet the active cell in indicated by ?
Ans. A dark wide border.

02. What term describes explanatory text attached to a cell ?
Ans. Comment.

03. How we can view a cell comment ?", ["position the mouse pointer over the cell",
Ans. position the mouse pointer over the cell.

04. Which of these will not select all the cells in a document ?
Ans. Clicking three times with the right mouse button in the spreadsheet.

05. Statistical calculations and preparation of tables and graphs can be done using?
Ans. Excel.

06. You can activate a cell by?
Ans. You can activate a cell by, Clicking the cell,Pressing an arrow key.

07. What type of chart is useful for comparing values over categories?
Ans. COLUMN.

08. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?
Ans. Save.

09. Which of the following is not an option of the spelling dialog box?
Ans. Edit.

10. A worksheet range is a?
Ans. A group of cells.

11. What is the keyboard shortcut for creating a chart from the selected cell range ?
Ans. F11.

12. What is the shortcut key to insert current date in a cell ?
Ans. CTRL + ;.

13. The active cell ?
Ans. Only A and B.

14. _________ function key is used to enter the edit mode?
Ans. F2.

15. Which of the following is not a valid MS-Excel function?
Ans. Calculation.

16. Which of the following is not a type of cell referencing in MS-Excel??
Ans. Trigonometric.

17. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu ?
Ans. Tools.

18. You can use the _____ button for quick calculations in MS-Excel?
Ans. Mod.

19. Macro recorder is a tool that translate your action in?
Ans. VBA.

20. MS-Excel displays the default paper?
Ans. Portrait.