Web
Analytics

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



Prove It - Microsoft Excel Test |

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






2. Format Cells As Currency: Format The Selected Range Of Cells As U.S. Currency






3. Create A Custom List






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






5. Insert A Row






6. Pivottable Filter: Modify The Pivottable So That Vacation Entries Are Removed






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






8. Copy






9. Borders: Create A Border Around The Selected Cells Using All Borders Or Outline And Inside






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






11. Freeze Panes






12. Use Average Function






13. Sum Function






14. Open A Workbook






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






16. Header/Footer: Add The Footer "Page 1" To The Current Worksheet.






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






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






19. Font Size: Change The Selected Cell To 20pt






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






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






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






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






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






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






250 Top Work & Personal Skills Made Easy

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

250+ Easy-to-Follow Guides
5000+ Proven Tips

13 Types of Essential Skills Covered
Get The Value of 100+ Best Books in 1 Book.

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