Page | 1
Click here for more: Scholarsnexus - Stuvia US
EXCEL LINKED-IN QUIZ Questions with
Detailed Verified Answers (100% Correct
Answers) /Already Graded A+
Excel's menu system is known as the
Ans: ribbon
some of the buttons in the ribbon have a small arrow in the bottom right
corner. What are these arrows?
Ans: dialog box launchers
You would like to add commands to the Quick Access Toolbar that you use
frequently. Where on a drop-down menu can you access the full list of
available commands?
Ans: in All Commands
Ramesh is entering text into a worksheet, but everything he types is in capital
letters. Which indicator in Excel lets him know this?
Ans: The status bar will read "Caps Lock" in the lower left corner.
Suppose you highlight a column of data in an Excel worksheet. In the status
bar below, you'll see all of the following by default, except: _____.
Ans: Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen.
Where is it located?
,Page | 2
Click here for more: Scholarsnexus - Stuvia US
Ans: status bar at bottom of screen
You are using your mouse (or cursor) within your Excel sheet. If you slide
leftward and put it on a boundary between rows, what does your cursor look
like?
Ans: a two-way up-down arrow
You have three workbooks open that you are working on. How can you
most easily navigate from one workbook to another?
Ans: Select Switch Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar?
Ans: It is a limited-feature bar that contains many of the features contained
on the Home tab of the toolbar.
Darren needs his team to use a standard template for reporting expenses.
What advice would you give him?
Ans: Use one of the Microsoft Excel templates that is already built.
What is Excel?
Ans: all of these answers
How can you access Insights, which takes you outside of Microsoft and into
the web?
, Page | 3
Click here for more: Scholarsnexus - Stuvia US
Ans: the Smart Lookup feature in a drop-down menu on the ribbon
You intended to enter 110 in a series of 10 values, but you inadvertently
typed 11O. How will Excel tell you that you made a data entry error?
Ans: 11O will be left-aligned, while the other values will be right-aligned.
How can you use AutoFill to provide all 12 months in a year across the
columns in row 1 of a data set, starting at column B?
Ans: Enter Jan in cell B1, and then drag the fill handle to cell M1.
When will you use Save rather than Save As?
Ans: when you make changes to an existing workbook
Date entries are numbers and by default they _____.
Ans: line up on the right side of the cell
While Undo is a valuable feature to avoid losing important data, what
limitation does it have?
Ans: You can only undo actions consecutively and cannot select an action, for
example, from 10 entries earlier.
You are working on a spreadsheet and have entered several lines of data and
text. You need to adjust the two lines you just entered. Which action is the
best to take?
Click here for more: Scholarsnexus - Stuvia US
EXCEL LINKED-IN QUIZ Questions with
Detailed Verified Answers (100% Correct
Answers) /Already Graded A+
Excel's menu system is known as the
Ans: ribbon
some of the buttons in the ribbon have a small arrow in the bottom right
corner. What are these arrows?
Ans: dialog box launchers
You would like to add commands to the Quick Access Toolbar that you use
frequently. Where on a drop-down menu can you access the full list of
available commands?
Ans: in All Commands
Ramesh is entering text into a worksheet, but everything he types is in capital
letters. Which indicator in Excel lets him know this?
Ans: The status bar will read "Caps Lock" in the lower left corner.
Suppose you highlight a column of data in an Excel worksheet. In the status
bar below, you'll see all of the following by default, except: _____.
Ans: Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen.
Where is it located?
,Page | 2
Click here for more: Scholarsnexus - Stuvia US
Ans: status bar at bottom of screen
You are using your mouse (or cursor) within your Excel sheet. If you slide
leftward and put it on a boundary between rows, what does your cursor look
like?
Ans: a two-way up-down arrow
You have three workbooks open that you are working on. How can you
most easily navigate from one workbook to another?
Ans: Select Switch Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar?
Ans: It is a limited-feature bar that contains many of the features contained
on the Home tab of the toolbar.
Darren needs his team to use a standard template for reporting expenses.
What advice would you give him?
Ans: Use one of the Microsoft Excel templates that is already built.
What is Excel?
Ans: all of these answers
How can you access Insights, which takes you outside of Microsoft and into
the web?
, Page | 3
Click here for more: Scholarsnexus - Stuvia US
Ans: the Smart Lookup feature in a drop-down menu on the ribbon
You intended to enter 110 in a series of 10 values, but you inadvertently
typed 11O. How will Excel tell you that you made a data entry error?
Ans: 11O will be left-aligned, while the other values will be right-aligned.
How can you use AutoFill to provide all 12 months in a year across the
columns in row 1 of a data set, starting at column B?
Ans: Enter Jan in cell B1, and then drag the fill handle to cell M1.
When will you use Save rather than Save As?
Ans: when you make changes to an existing workbook
Date entries are numbers and by default they _____.
Ans: line up on the right side of the cell
While Undo is a valuable feature to avoid losing important data, what
limitation does it have?
Ans: You can only undo actions consecutively and cannot select an action, for
example, from 10 entries earlier.
You are working on a spreadsheet and have entered several lines of data and
text. You need to adjust the two lines you just entered. Which action is the
best to take?
