Home > Microsoft Excel > Quizzes > Prove It - Microsoft Excel 2
Prove It - Microsoft Excel 2
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 18% • Most missed: “Paste a Function”
Prove It - Microsoft Excel 2
Time left 00:00
25 Questions

1. Edit PivotTable: Using the current worksheet's PivotTable, add the TaskName as a Column Label

2. Table Style: Change the Table Style to Table Style Light 2 (2nd column, 1st row)

3. Turn on AutoFilter: Turn on the AutoFilter feature for the selected cells

4. Column Width: Change the width of Column F so that the contents automatically fit within the column

5. Create a Macro: Using the Macro Recorder, record a macro that will type '800-555-5555' in the current cell. The Macro Name is 'Phone' and the shortcut-key to assign to the macro is 'CTRL+e'

6. Paste a Function

7. Create a Custom List

8. Insert a Row

9. Run a Macro: Run the Macro named, 'Phone'

10. Selecting Cells: Select Cells A3 through F3

11. Text Warp: Modify the format of the selected cell, so that the text automatically wraps around it.

12. Print Worksheet

13. Convert Text to Columns: The selected column contains a list of airport codes and the location on the airport. Split the selected column, using the common delimiter, a colon (:), so that the airport codes are in column K and the airport locations are in column L

14. Select Non-Contiguous Cells: Select cells G2 and C2 without selecting cells D2, E2, and F2

15. Change the Chart Style to Style 8

16. VLOOKUP: In cell F2, create a VLOOKUP formula that will look up the airport code in E2 and display the appropriate city name (using columns K and L). Look for an exact match

17. Custom Sort: Sort the selected cells by Time to Reorder? (in Z to A order) and then Quantity in Reorder (Smallest to Largest)

18. Insert Page Break: Without changing the view, insert a page break for the selected sheets above row 21

19. Sort: Sort the selected cells by Last Name, in ascending order

20. Format Cells as Currency: Format the selected range of cells as U.S. Currency

21. COUNTIF: In cell G2, create a formula that will place the number of occasions B2 is represented in column B

22. Insert Chart

23. Renaming a Worksheet

24. IF Statement: In cell G2, create a formula that will place the word 'Yes' if cell F2 (Quantity in Stock) is less than 25% of H2 (Quantity in Reorder) or 'No' if this condition is not met

25. PivotTable Filter: Modify the PivotTable so that Vacation entries are removed

⚡ 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) MS Excel 2007 Test
 
❤ 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.