Microsoft Excel
Prove It - Microsoft Excel Test
Answer 25 questions in 10 minutes.

Prove It - Microsoft Excel Test |


1. Create A Custom List






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






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






4. Merge And Center Cells






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






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






7. Copy






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






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






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






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






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






13. Print Worksheet






14. Selecting Cells: Select Cells A3 Through F3






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






16. Spell Check






17. Renaming A Worksheet






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






19. Freeze Panes






20. Insert Column: Insert A Column To The Left Of Column F






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






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






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






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






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





 
 
 




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 2021