Login

Formatting 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. 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 2 2. What are the different ways to take action in Excel?

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

Question 4 4. If you want to quickly insert a column or row, what keyboard short-cut command do you use?

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

Page 2

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

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

Question 8 8. If you set a row height or column with to 0 (zero), what happens to the row and column?

Question 9 9. What is the standard default size of the width for a column?

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

Page 3

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

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

Question 13 13. Which statement best describes a worksheet in MS Excel?

Question 14 14. Where on the Excel screen will you find the worksheet tabs?

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

Formatting Worksheets & Workbooks in Excel Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next question. You can skip questions if you would like and come back to them later with the "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. You will lose your work if you close or refresh this page. Good luck!

Intro to Excel: Essential Training & Tutorials  /  Business Courses
Support