XCEL EXAM WITH CORRECT ANSWERS 2025
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? - CORRECT ANSWER -Mini Toolbar
You would like to add some frequently used buttons to the Quick Access Toolbar. How can you
do this? - CORRECT ANSWER -Right-click the button on the ribbon and select Add.
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"? - CORRECT ANSWER -Hover over the button,
then click Tell me more at the bottom of the information displayed.
When would you use Excel for a task? - CORRECT ANSWER -when creating a list of employees
with their ID numbers
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? -
CORRECT ANSWER -with the same formatting as "2018 Sales" before you made any changes
What is the difference between a workbook and worksheet? - CORRECT ANSWER -A workbook
is the file and a worksheet is the individual tab within the workbook.
As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which
action will Excel take with this? - CORRECT ANSWER -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.
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? - CORRECT ANSWER -You are saving the file for someone
with an older version of Excel
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? - CORRECT ANSWER -Mini Toolbar
You would like to add some frequently used buttons to the Quick Access Toolbar. How can you
do this? - CORRECT ANSWER -Right-click the button on the ribbon and select Add.
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"? - CORRECT ANSWER -Hover over the button,
then click Tell me more at the bottom of the information displayed.
When would you use Excel for a task? - CORRECT ANSWER -when creating a list of employees
with their ID numbers
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? -
CORRECT ANSWER -with the same formatting as "2018 Sales" before you made any changes
What is the difference between a workbook and worksheet? - CORRECT ANSWER -A workbook
is the file and a worksheet is the individual tab within the workbook.
As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which
action will Excel take with this? - CORRECT ANSWER -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.
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? - CORRECT ANSWER -You are saving the file for someone
with an older version of Excel
