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

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