Web
Analytics

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





GET PROVEN ADVICE FROM
100+ BEST BOOKS IN 1 BOOK

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