Microsoft Excel Certification: Practice & Study Guide  /  Business Courses

Test Prep Plan - Take a practice test

Take this practice test to check your existing knowledge of the course material. We'll review your answers and create a Test Prep Plan for you based on your results.
How Test Prep Plans work
1
Answer 50 questions
Test your existing knowledge.
2
View your test results
Based on your results, we'll create a customized Test Prep Plan just for you!
3
Study smarter
Study more effectively: skip concepts you already know and focus on what you still need to learn.

Worksheets & Workbooks in Excel Chapter Exam

Exam Instructions:

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Page 1

Question 1 1. What ribbon menu displays the Page Setup grouping of commands?

Question 2 2. If you apply the rules that restrict the entry to whole numbers, what are the minimum and maximum number options?

Question 3 3. Excel has a auto-fit feature for both row height and column width. One option is to use the ribbon commands, the other is to hover your mouse over a row or column boundary line until you see the 2-sided arrow. What do you do next?

Question 4 4. There are three different types of alert messages: Stop, Caution and Information. What is the purpose of the Stop alert message?

Question 5 5. To use the ribbon commands, what menu and grouping of commands will you find the Insert and Delete command?

Page 2

Question 6 6. What ribbon menu and grouping of commands do you start with to format a cell or column to wrapped text?

Question 7 7. Which statement best describes a workbook in MS Excel?

Question 8 8. Under what ribbon menu will you find the Excel Themes?

Question 9 9. If you prefer the right-click method to ribbon commands, you can right-click on the cell to be formatted. Which option do you select from the drop-down menu?

Question 10 10. If you right-click on a row reference number and click on Insert, where will the row be added?

Page 3

Question 11 11. What information would be good to add to a header or footer, if you wanted to make sure the recipient knows where the Excel file is stored?

Question 12 12. Which statement best describes the 'header row' in a spreadsheet?

Question 13 13. If you already have shaded cells with different color fills and fonts, what happens when you change the theme?

Question 14 14. In what grouping of commands will you find the header and footer short-cut commands to add specific content, such as the page number?

Question 15 15. Which statement below best describes Themes and use of colors?

Page 4

Question 16 16. How do you rename the title of a worksheet tab?

Question 17 17. If you right-click on any cell and choose Insert from the drop-down menu, what will happen?

Question 18 18. What answers best describes the term Vertical?

Question 19 19. Which statement below is true about wrapped text in Excel?

Question 20 20. What are the first three steps to customize margins?

Page 5

Question 21 21. In order to access the header and footer text boxes, you first need to open what view?

Question 22 22. Under what ribbon menu and grouping of commands will you find the short-cut icons for aligning content in a spreadsheet?

Question 23 23. How do you change the fill color of a worksheet tab?

Question 24 24. Which command allows you to specify which row(s) or column(s) should be printed on overflow pages?

Question 25 25. Under what menu in the ribbon will you find the Data Validation command?

Page 6

Question 26 26. Which statement best describes the Wrap Text feature in Excel?

Question 27 27. If you choose to use the ribbon commands to adjust the values for row height and column width, which ribbon menu and grouping of commands do you use?

Question 28 28. Which statement best describes the difference between using WordArt for the watermark, or inserting an image as a header?

Question 29 29. If you want to restrict a cell to a limited amount of characters, what option would you select from the Allow options pick-list?

Question 30 30. Which statement best describes the command highlighted in the graphic below?

Worksheets & Workbooks in Excel Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Support