Web
Analytics

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



Prove It - Microsoft Excel Test |

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






2. Concatenate: In Cell 2 - Create A Formula To Combine The Item In A2 (Ch-ad) And Inventory Id In B2 (2986) With No Space Between Them - So That C2 Lists "Ch-ad2986"






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






4. Font Style: Change The Font Style Of The Selected Cell To Bold






5. Selecting Cells: Select Cells A3 Through F3






6. Insert Chart






7. Print Area: Set The Print Area To Contain The Selected Cells A1:C7






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






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






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






11. Create A Custom List






12. Use Average Function






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






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






15. Print Scaling






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






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






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






19. Spell Check






20. Text Warp: Modify The Format Of The Selected Cell - So That The Text Automatically Wraps Around It.






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






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






23. If Statement: In Cell G2 - Create A Formula That Will Place The Word "Yes" If Cell F2 (Quantity In Stock) Is Less Than 25% Of H2 (Quantity In Reorder) Or "No" If This Condition Is Not Met






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






25. Save






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


 
 
 


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 2020