Home > Microsoft Excel > Quizzes > Spreadsheet Applications Test
Spreadsheet Applications Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 38% • Most missed: “To execute a macro you create, you can select the ____command in the Macro dialo…”
Spreadsheet Applications Test
Time left 00:00
25 Questions

1. In VBA, macros are called____ procedures.
2. In a formula, what does the colon stand for?
3. If a value of 2 is stored in cell C5, and 5 is stored in cell D5, what will be displayed if =C5*D5 is keyed in cell E5?
4. Which one of the following is not an option for the shape of the bars in a column chart?
5. Which one of the following functions does not use an argument?
6. Which of the following is a valid macro name?
7. The rectangular area that labels the markers or symbols used in a chart.
8. Which one of the following best describes a type of cells in which you can change values at any time?
9. The operation of making a cell turn red or bold automatically if it exceeds a certain value is called:
10. A(n) ____ takes a value or values, performs an operation, and returns a result to the cell.
11. This feature causes adjacent rows to have different formatting so that each record in the table is distinguished from surrounding rows.
12. The____ operator checks if the value in a given cell is less than the value in another cell.
13. Data values are plotted along the vertical axis, known as the:
14. Typically, new templates should be saved:
15. If Bruce specifies Jan? as the search criteria, it will locate all of the following records except:
16. You can easily add formatting to a spreadsheet table by using:
17. Which one of these is not one of the three parts of an IF function?
18. Which one of the following is the easiest method to print only rows that meet specific criteria?
19. The expression____ returns the maximum value in the range A1 :A100 and then divides the value by 100.
20. The procedure to update a PivotTable with changes in the numerical figures is to:
21. Which one of the following is not an example of spreadsheet software?
22. What does the error message #DIV/0! mean?
23. Which one of the following is the easiest method to print only rows that meet specific criteria?
24. Which one of the following cannot be done after a pivot table has been created?
25. To put a stored macro into action:

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice Test Prove It - Microsoft Excel Test Microsoft Excel (MS Excel) Practice Test: All Topics Counting and Rounding Formulas Useful Excel Vocabulary Management Science MGSC 290 Final Excel Fundamentals Test (Upwork) Prove It - Microsoft Excel 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.