MS EXCEL MCQ Quiz - Multiple Choice Questions & Answers Page 2

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

1. Enclose the number is brackets
2. Place the character T before the number
3. Place the character TX before the number
4. Apply the Text format in the cell and type the numbers

12. Which of the following shortcuts can be used to insert a new line in the same cell?

1. Enter
2. Alt + Enter
3. Ctrl + Enter
4. Shift + Enter

13. An Excel file is generally called a / an :

1. E-Spreadsheet
2. Woorksheet
3. Workbook
4. Sheet

14. Which of the following is the oldest spreadsheet package ?

1. Excel
2. StarCalc
3. VisiCalc
4. None of the above

15. Which key do you press to check spelling?

1. F3
2. F5
3. F7
4. F9

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

1. F9
2. F10
3. F11
4. F12

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

1. Financial
2. Statistical
3. Logical
4. None of the above

18. MS-EXCEL can be used to automate

1. Financial statements, Business forecasting
2. Transaction registers, inventory control
3. Accounts receivable, accounts payable
4. Any of the above

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

1. Font format
2. Number format
3. Border format
4. All of the above

20. Which menu option can be used to split windows into two?

1. Format -> Window
2. View -> Window-> Split
3. Window -> Split
4. View –> Split