Web
Analytics

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