Page | 1
Click here for more: Scholarsnexus - Stuvia US
Excel Microsoft 365 Questions with Detailed
Verified Answers (100% Correct Answers)
/Already Graded A+
When would you use Excel for a task?
Ans: 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?
Ans: 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?
Ans: Mini Toolbar
You would like to add some frequently used buttons to the Quick Access
Toolbar. How can you do this?
Ans: 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"?
Ans: Hover over the button, then click Tell me more at the bottom of the
information displayed.
, Page | 2
Click here for more: Scholarsnexus - Stuvia US
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?
Ans: Click Help from the menu bar.
What is the difference between a workbook and worksheet?
Ans: 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?
Ans: 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?
Ans: 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?
Ans: By default, cells with alpha characters are left-aligned and while numeric
characters are right-aligned.
You click the Save icon at the top of an Excel workbook. The image below
shows what appears on your screen. Why do you see this screen?
Ans: This is a new file that has not previously been saved.
Click here for more: Scholarsnexus - Stuvia US
Excel Microsoft 365 Questions with Detailed
Verified Answers (100% Correct Answers)
/Already Graded A+
When would you use Excel for a task?
Ans: 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?
Ans: 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?
Ans: Mini Toolbar
You would like to add some frequently used buttons to the Quick Access
Toolbar. How can you do this?
Ans: 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"?
Ans: Hover over the button, then click Tell me more at the bottom of the
information displayed.
, Page | 2
Click here for more: Scholarsnexus - Stuvia US
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?
Ans: Click Help from the menu bar.
What is the difference between a workbook and worksheet?
Ans: 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?
Ans: 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?
Ans: 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?
Ans: By default, cells with alpha characters are left-aligned and while numeric
characters are right-aligned.
You click the Save icon at the top of an Excel workbook. The image below
shows what appears on your screen. Why do you see this screen?
Ans: This is a new file that has not previously been saved.
