Microsoft Excel
Prove It - Microsoft Excel Test
Can you answer 25 questions in 10 minutes?

Prove It - Microsoft Excel Test |

1. Renaming A Worksheet

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

3. Margins: Change The Page Margins To Wide Or Where The Top - Left - Bottom - And Right Margin Is At 1"

4. Custom Sort: Sort The Selected Cells By Time To Reorder? (In Z To A Order) And Then Quantity In Reorder (Smallest To Largest)

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

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

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

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

9. Select Non-contiguous Cells: Select Cells G2 And C2 Without Selecting Cells D2 - E2 - And F2

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

11. Paste A Function

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

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

14. Print Worksheet

15. Use Average Function

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

17. Print Scaling

18. Hide Column

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

20. Insert Chart

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

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

23. Sum Function

24. Merge And Center Cells

25. Change The Chart Style To Style 8


Bighow News | Truho | The Success Manual

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 2019