Microsoft Excel Quiz

1. Which of the following is an absolute cell reference?

2. How can you view two workbooks simultaneously to compare sales figures?

3. How can you efficiently display all your chart values in a tabular format on the chart page?

4. You can create hyperlink from an excel workbook to

5. Which of the not correct method of editing the cell content

6. Shortcut key for line break is

7. Which of the following function is MS-Excel returns TRUE result if all of its arguments are true and otherwise false ?

8. Which function display current data and time in excel?

9. The  default Row height MS excel worksheet is ............. point

10. How can you arrange to get a quick alert if a cell contains a value below a specific amount?