Home > Microsoft Excel > Quizzes > Microsoft Excel (MS Excel) Practice Test: All Topics
Microsoft Excel (MS Excel) Practice Test: All Topics
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 2% Most missed: “In Excel to access the Go To Special feature, you can press”
Microsoft Excel is a popular spreadsheet application. It's used for data entry and management, charts and graphs, and project management. It is available for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel is typically included as part of the Microsoft Office 365 software suite. Some basic Excel skills every profesional should have include: The SUM Formula The AVERAGE Formula Charts and Graphs Sorting Data Find and... Show more
Microsoft Excel (MS Excel) Practice Test: All Topics
Time left 00:00
25 Questions

1. In Excel to open an existing workbook, you can click the Open button on the …… toolbar.
2. In Excel to save a workbook, you
3. Which of the following is not a worksheet design criterion?
4. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
5. In Excel when you use the fill effects in the format data series dialog box, you cannot
6. In Excel Charts tips can
7. Which menu option can be sued to split windows into two
8. In Excel comments can be added to cells using
9. Getting data from a cell located in a different sheet is called
10. When you print preview a worksheet
11. You can zoom a worksheet
12. In Excel when integrating Ms-Word and Excel, Word is usually the
13. In Excel you can create only a horizontal page break by first selecting
14. In Excel which of the following options is not located in the Page Setup dialog box?
15. In Excel the cell labeled F5 refers to
16. Which of the following formulas is not entered correctly?
17. In Excel Text formulas
18. Files created with Lotus 1-2-3 have an extension
19. In Excel which do you press to enter the current date in a cell?
20. What term refers to a specific set of values saved with the workbook?
21. In Excel how do you insert a row?
22. In Excel which elements of worksheet can be protected from accidental modification ?
23. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
24. In Excel to center worksheet titles across a range of cell, you must
25. The default header for a worksheet is