EXCEL LINKED-IN QUIZ
Excel's menu system is known as the - ✔✔ribbon
some of the buttons in the ribbon have a small arrow in the bottom right corner. What are these
arrows? - ✔✔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? - ✔✔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? - ✔✔The status bar will read "Caps Lock" in the lower left corner.
0
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: _____. - ✔✔Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen. Where is it located? -
0
✔✔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? - ✔✔a two-way up-down arrow
1
You have three workbooks open that you are working on. How can you most easily navigate from one
workbook to another? - ✔✔Select Switch Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar? - ✔✔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? - ✔✔Use one of the Microsoft Excel templates that is already built.
What is Excel? - ✔✔all of these answers
How can you access Insights, which takes you outside of Microsoft and into the web? - ✔✔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? - ✔✔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? - ✔✔Enter Jan in cell B1, and then drag the fill handle to cell M1.
When will you use Save rather than Save As? - ✔✔when you make changes to an existing workbook
%
Date entries are numbers and by default they _____. - ✔✔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? -
✔✔You can only undo actions consecutively and cannot select an action, for example, from 10
entries earlier.
0
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? - ✔✔Undo the lines.
You have received a worksheet from a coworker who told you there are a number of comments you
need to review. How do you first know there are comments in the worksheet? - ✔✔There is a little
0
triangle in the upper right-hand corner of the cell.
Karl is trying to figure out what he should name his Excel file before saving it. Which should he avoid
when creating a file name? - ✔✔Avoid using an asterisk.
1
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for
the next four months? - ✔✔Use =C4+B5
You want to get the percentage increase in profits from January to February. If you use the formula
shown below, what value will be returned? - ✔✔Because there are no parentheses, Excel's hierarchy
of operations will divide B4 by B4 (=1), and then subtract it from C4 (30-1=29).
Assume you want all employees to receive a 2.1 percent pay increase. If the value shown in cell H1 is
2.1 percent, what is the correct formula to use in cell F2 and to drag down to the other rows? -
✔✔When you copy this formula, Excel will change H1 to H2, which has a zero value, and so on
down the column.
The most effective way to add up five different cells in a row is to _____ - ✔✔use the SUM function
What is the basis of using formulas in Excel? - ✔✔Formulas are usually based on location.
Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) _____ reference. -
✔✔absolute
Excel's menu system is known as the - ✔✔ribbon
some of the buttons in the ribbon have a small arrow in the bottom right corner. What are these
arrows? - ✔✔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? - ✔✔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? - ✔✔The status bar will read "Caps Lock" in the lower left corner.
0
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: _____. - ✔✔Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen. Where is it located? -
0
✔✔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? - ✔✔a two-way up-down arrow
1
You have three workbooks open that you are working on. How can you most easily navigate from one
workbook to another? - ✔✔Select Switch Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar? - ✔✔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? - ✔✔Use one of the Microsoft Excel templates that is already built.
What is Excel? - ✔✔all of these answers
How can you access Insights, which takes you outside of Microsoft and into the web? - ✔✔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? - ✔✔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? - ✔✔Enter Jan in cell B1, and then drag the fill handle to cell M1.
When will you use Save rather than Save As? - ✔✔when you make changes to an existing workbook
%
Date entries are numbers and by default they _____. - ✔✔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? -
✔✔You can only undo actions consecutively and cannot select an action, for example, from 10
entries earlier.
0
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? - ✔✔Undo the lines.
You have received a worksheet from a coworker who told you there are a number of comments you
need to review. How do you first know there are comments in the worksheet? - ✔✔There is a little
0
triangle in the upper right-hand corner of the cell.
Karl is trying to figure out what he should name his Excel file before saving it. Which should he avoid
when creating a file name? - ✔✔Avoid using an asterisk.
1
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for
the next four months? - ✔✔Use =C4+B5
You want to get the percentage increase in profits from January to February. If you use the formula
shown below, what value will be returned? - ✔✔Because there are no parentheses, Excel's hierarchy
of operations will divide B4 by B4 (=1), and then subtract it from C4 (30-1=29).
Assume you want all employees to receive a 2.1 percent pay increase. If the value shown in cell H1 is
2.1 percent, what is the correct formula to use in cell F2 and to drag down to the other rows? -
✔✔When you copy this formula, Excel will change H1 to H2, which has a zero value, and so on
down the column.
The most effective way to add up five different cells in a row is to _____ - ✔✔use the SUM function
What is the basis of using formulas in Excel? - ✔✔Formulas are usually based on location.
Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) _____ reference. -
✔✔absolute
