Microsoft Excel
Prove It - Microsoft Excel Test
Answer 25 questions in 10 minutes.

Prove It - Microsoft Excel Test |

1. Save

2. Create A Custom List

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

4. Sum Function

5. Change The Chart Style To Style 8

6. Conditional Formatting: Format The Selected Column (Column G) To Highlight Cells With "Light Red Fill With Dark Red Text" Option If The Cell Is Equal To "Yes".

7. Print Centered On Page: Perform The Commands To Center The Selected Worksheets Both Horizontally And Vertically On The Printed Page.

8. Selecting Cells: Select Cells A3 Through F3

9. Paste Special: Copy The Selected Cells And Paste With Actual Values

10. Merge And Center Cells

11. Insert Chart

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

13. Select Multiple Worksheets: Select Worksheets Option 1 - Option 2 - And Option 3

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

15. Fill Handle: Use The Fill Handle To Fill The Empty Cells From G3:G11

16. Create Pivottable: Using The Current Worksheet's Data - Create A Report That Displays The Quarterly Sales By Territory

17. Print Scaling

18. Insert A Row

19. Insert Worksheet

20. Hide Column

21. Open A Workbook

22. Turn On Autofilter: Turn On The Autofilter Feature For The Selected Cells

23. Cell References: Divide F2 By F76. Use A Relative Reference For Cell F2 And A Mixed Cell Reference To Refer To The Row For Cell F76

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

25. Renaming A Worksheet


250 Top Work & Personal Skills Made Easy

The World's First & Only Encyclopedia of
Self Help, Self Improvement & Career Advice

250+ Easy-to-Follow Guides
5000+ Proven Tips
13 Types of Essential Skills

502 Pages | $3.99 | PDF / EPub, Kindle Ready


Please report any error in fatskills quizzes and questions to 'simpleversity at gmail.com'.

Without work one finishes nothing. - Ralph Waldo Emerson

© The Simple Project 2020