Excel Essential Training (Office
365/Microsoft 365) Chapter Quiz
Questions and Answers
when creating a list of employees with their ID numbers - Answer-When would you use Excel for a task?
with the same formatting as "2018 Sales" before you made any changes - Answer-You are working in
your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a
worksheet "2018 Profit," how will the new worksheet appear?
Mini Toolbar - Answer-A user wants to quickly format a cell and right-clicks the cell to use the features
seen in the image. Which Excel tool is being used?
Right-click the button on the ribbon and select Add. - Answer-You would like to add some frequently
used buttons to the Quick Access Toolbar. How can you do this?
Hover over the button, then click Tell me more at the bottom of the information displayed. - Answer-
You are using a button on the ribbon, and you are interested in learning more about its functionality.
How can you access "Tell me more"?
, Click Help from the menu bar - Answer-You want to add an average in the worksheet. You want to learn
more about the average function in Excel and think that a video will assist you. How can you access
training from the workbook?
A workbook is the file and a worksheet is the individual tab within the workbook. - Answer-What is the
difference between a workbook and worksheet?
You are saving the file for someone with an older version of Excel. - Answer-You are working in the most
recent version of Excel provided by your company. Why would you use the Save as type pull-down
menu?
By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned. -
Answer-What is most likely the reason the work order and status columns are left-aligned while the cost
column is right-aligned?
deleting a tab in the workbook - Answer-Which action CANNOT be reversed using the Undo command?
Type in "January," point to the lower right-hand corner of the cell, hold down the left mouse button, and
drag across the next 11 rows. - Answer-You are entering Sales data for each month in 2018. How can
you quickly enter all 12 months in columns?
Excel will display it as 6/31/2019, but it will be left-justified and just a set of numbers and dashes, not an
actual date. - Answer-As you are entering sales data into a new worksheet, you inadvertently type
6/31/2019. Which action will Excel take with this?
Up and then left - Answer-The Autosum function always looks
colon (:) - Answer-The autosum formula will use the ______ versus the plus (+) symbol in the formula.
365/Microsoft 365) Chapter Quiz
Questions and Answers
when creating a list of employees with their ID numbers - Answer-When would you use Excel for a task?
with the same formatting as "2018 Sales" before you made any changes - Answer-You are working in
your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a
worksheet "2018 Profit," how will the new worksheet appear?
Mini Toolbar - Answer-A user wants to quickly format a cell and right-clicks the cell to use the features
seen in the image. Which Excel tool is being used?
Right-click the button on the ribbon and select Add. - Answer-You would like to add some frequently
used buttons to the Quick Access Toolbar. How can you do this?
Hover over the button, then click Tell me more at the bottom of the information displayed. - Answer-
You are using a button on the ribbon, and you are interested in learning more about its functionality.
How can you access "Tell me more"?
, Click Help from the menu bar - Answer-You want to add an average in the worksheet. You want to learn
more about the average function in Excel and think that a video will assist you. How can you access
training from the workbook?
A workbook is the file and a worksheet is the individual tab within the workbook. - Answer-What is the
difference between a workbook and worksheet?
You are saving the file for someone with an older version of Excel. - Answer-You are working in the most
recent version of Excel provided by your company. Why would you use the Save as type pull-down
menu?
By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned. -
Answer-What is most likely the reason the work order and status columns are left-aligned while the cost
column is right-aligned?
deleting a tab in the workbook - Answer-Which action CANNOT be reversed using the Undo command?
Type in "January," point to the lower right-hand corner of the cell, hold down the left mouse button, and
drag across the next 11 rows. - Answer-You are entering Sales data for each month in 2018. How can
you quickly enter all 12 months in columns?
Excel will display it as 6/31/2019, but it will be left-justified and just a set of numbers and dashes, not an
actual date. - Answer-As you are entering sales data into a new worksheet, you inadvertently type
6/31/2019. Which action will Excel take with this?
Up and then left - Answer-The Autosum function always looks
colon (:) - Answer-The autosum formula will use the ______ versus the plus (+) symbol in the formula.
