Excel Exam
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 21% • Most missed: “Change the worksheet margins to the Narrow margin style.”
Excel Exam
Time left 00:00
25 Questions

1. Insert a 3-D Pie chart into the worksheet, based on range A4:B7.

2. format column (ex: d) using auto fit so that all cell content is visible

3. enter the text '2020 Sales' in the bar chart title placeholder

4. change the height of row 2 to approximately 27 points (36 pixels)

5. Enter a formula using arithmetic operators and parentheses in cell B14 that adds the monthly expenses in cells B9, B10, and B11, and then multiplies that result by 12.

6. Change the width of column C to exactly 15 characters.

7. Apply the Berlin theme to the current workbook.

8. Change the worksheet margins to the Narrow margin style.

9. merge and center the contents of cell range (ex: A2:D2)

10. apply chart style 5 to the chart

11. In cell B7, enter a formula using relative cell references that subtracts cell B6 from cell B5.

12. clear the contents of cell b7

13. Move the Stacked Column chart in the Sales Forecast worksheet to cell F1 on the Category Sales worksheet.

14. print range A3:F8

15. Change the page orientation of the current worksheet to Landscape.

16. apply thick outside borders to the range A8:D8

17. enter the number 2100 in cell B12

18. split worksheet

19. For range B4:B15, create a New conditional formatting rule that formats the top five values in the range with a Green, Accent 6 cell background color (last color option in the top row of colors).

20. freeze column

21. Add the data labels chart element to the Bar chart at the Outside End position.

22. in a cell, enter a formula using the SUM function to total the values in a cell range (B4:B15)

23. change the font of a cell to cambria

24. format column d using auto fit so that all cell content is visible

25. Rotate the contents of the cells in range B3:M3 to exactly 45 degrees.

⚡ 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.