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

1. Print Scaling

2. Page Orientation: Change The Orientation Of This Worksheet To Landscape

3. Selecting Cells: Select Cells A3 Through F3

4. Insert Chart

5. Sort: Sort The Selected Cells By Last Name - In Ascending Order

6. Text Alignment: Change The Alignment For The Selected Cells To The Right

7. Insert Page Break: Without Changing The View - Insert A Page Break For The Selected Sheets Above Row 21

8. Text Warp: Modify The Format Of The Selected Cell - So That The Text Automatically Wraps Around It.

9. Insert A Row

10. Print Worksheet

11. Copy

12. Insert Worksheet

13. Create A Custom List

14. Concatenate: In Cell 2 - Create A Formula To Combine The Item In A2 (Ch-ad) And Inventory Id In B2 (2986) With No Space Between Them - So That C2 Lists "Ch-ad2986"

15. Apply Filter: Apply A Filter To Task Name (Column D) So That Only Design Tasks Are Shown

16. Renaming A Worksheet

17. Run A Macro: Run The Macro Named - "Phone"

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

19. Column Width: Change The Width Of Column F So That The Contents Automatically Fit Within The Column

20. Countif: In Cell G2 - Create A Formula That Will Place The Number Of Occasions B2 Is Represented In Column B

21. Create Pivotchart: Using The Current Worksheet's Selected Data - Create A Pivotchart That Displays The Project Name And Time In Hours

22. 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"

23. Merge And Center Cells

24. Table Style: Change The Table Style To Table Style Light 2 (2nd Column - 1st Row)

25. Edit Pivottable: Using The Current Worksheet's Pivottable - Add The Taskname As A Column Label

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice 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 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.