©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Excel Microsoft 365 Exam Questions
and Answers 100% Solved
When would you use Excel for a task? - ✔✔when creating a list of
employees with their ID numbers (Excel is commonly used for creating and
maintaining lists).
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? - ✔✔with the same
formatting as "2018 Sales" before you made any changes
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? - ✔✔Mini
Toolbar
You would like to add some frequently used buttons to the Quick Access
Toolbar. How can you do this? - ✔✔Right-click the button on the ribbon
and select Add.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
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"? -
✔✔Hover over the button, then click Tell me more at the bottom of the
information displayed.
You want to add an average in the worksheet shown below. 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? - ✔✔Click
Help from the menu bar.
What is the difference between a workbook and worksheet? - ✔✔A
workbook is the file and a worksheet is the individual tab within the
workbook.
You are adding dates in the spreadsheet shown below. What will happen
when you press Enter after entering the date as shown in cell C9? -
✔✔The date will appear as 8/1/2020 and will be right-aligned.
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? -
✔✔You are saving the file for someone with an older version of Excel.
In the image below, what is most likely the reason the work order and
status columns are left-aligned while the cost column is right-aligned? -
Excel Microsoft 365 Exam Questions
and Answers 100% Solved
When would you use Excel for a task? - ✔✔when creating a list of
employees with their ID numbers (Excel is commonly used for creating and
maintaining lists).
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? - ✔✔with the same
formatting as "2018 Sales" before you made any changes
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? - ✔✔Mini
Toolbar
You would like to add some frequently used buttons to the Quick Access
Toolbar. How can you do this? - ✔✔Right-click the button on the ribbon
and select Add.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
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"? -
✔✔Hover over the button, then click Tell me more at the bottom of the
information displayed.
You want to add an average in the worksheet shown below. 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? - ✔✔Click
Help from the menu bar.
What is the difference between a workbook and worksheet? - ✔✔A
workbook is the file and a worksheet is the individual tab within the
workbook.
You are adding dates in the spreadsheet shown below. What will happen
when you press Enter after entering the date as shown in cell C9? -
✔✔The date will appear as 8/1/2020 and will be right-aligned.
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? -
✔✔You are saving the file for someone with an older version of Excel.
In the image below, what is most likely the reason the work order and
status columns are left-aligned while the cost column is right-aligned? -
