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. Insert Worksheet

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

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

5. Run A Macro: Run The Macro Named - "Phone"

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

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

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

9. Freeze Panes

10. Paste A Function

11. Open A Workbook

12. Sum Function

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

14. Custom Sort: Sort The Selected Cells By Time To Reorder? (In Z To A Order) And Then Quantity In Reorder (Smallest To Largest)

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

16. Hide Column

17. Copy

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

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

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

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

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

23. Merge And Center Cells

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

25. Create A Custom List


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