MS EXCEL Multiple Choice Questions and Answers for Practice

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

21. How do you wrap the text in a cell?

1. Format, cells, font
2. Format, cells, protection
3. format, cells, number
4. Format, cells, alignment

22. Which of the following you can paste selectively using Paste Special command ?

1. Formats
2. Validation
3. Formulas
4. All of the above

23. You can check the conditions against …………………………….when applying conditional formatting

1. Formula
2. Cell value
3. Both (A) and (B)
4. None of the above

24. A features that displays only the data in column (s) according to specified criteria

1. Formula
2. Sorting
3. Filtering
4. Pivot

25. What do you mean by a Workspace?

1. Group of Columns
2. Group of Worksheets
3. Group of Rows
4. Group of Workbooks

26. Which of the following function will use to find the highest number in a series of number ?

1. HIGH (B1:B3)
2. MAXIMUM (B1:B3)
3. MAX(B1:B3)
4. None of the above

27. How to restrict to run a macro automatically when starting Microsoft Excel?

1. Hold down the SHIFT key during startup
2. Hold down the CTRL key during startup
3. Hold down the ESC key during startup
4. Hold down the ALT key during startup

28. Which of the following is not an option of the spelling dialog box?

1. Ignore
2. Ignore all
3. Edit
4. Change

29. The spelling dialog box can be involved by choosing spelling from ……………………...menu.

1. insert
2. file
3. tools
4. view

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

1. Insert
2. Copy
3. Undo
4. Replace