Home > Microsoft Excel > Quizzes > Microsoft Excel Exam
Microsoft Excel Exam
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 19% Most missed: “In order to perform a calculation in a spreadsheet, you need to use a:”
Microsoft Excel Exam
Time left 00:00
25 Questions

1. The Delete key of keyboard is assigned to which command in Excel?
2. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
3. You can auto fit the width of column by
4. The Trace Dependence in auditing shows
5. In order to perform a calculation in a spreadsheet, you need to use a:
6. Where can you set the shedding color for a range of cells in Excel?
7. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
8. You can move a sheet from one workbook into new book by
9. The Trace Precedence on Auditing shows
10. Which of the following component displays the contents of active cell?
11. Which of the following is not an option in the spelling dialog box?
12. When a range is selected, how can you activate the previous cell?
13. You can automatically adjust the size of text in a cell if they do not fit in width by
14. Where can you change automatic or manual calculation mode in Excel?
15. You can use the formula pallette to"
16. You can filter using Advanced Criteria Filter if more than two conditions should be tested. A quick way to return to a specific area of a worksheet is to type in the _____"
17. You can check the conditions against __________ when applying conditional formatting
18. MS Excel provides the default value for step in Fill Series dialog box
19. NOT, AND, OR and XOR are
20. How many recent files you can display on File menu at maximum?
21. Which of the following is not the correct method of editing the cell content?
22. What happens when you press Ctrl + X after selecting some cells in Excel?
23. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
24. Which of the following is not What IF analysis tool in Excel?
25. If you want all of the white cats grouped together in the database, you need to sort by ________.