BITM 215 (3) MULTIPLE CHOICE QUESTIONS &
ANSWERS
You have a workbook that contains sales data where each sales rep's data is stored on
a separate worksheet. Which task is the least likely to be done while the worksheets are
grouped? - Answer -Enter specific values for the first sales rep
Cell C5 in the Summary worksheet contains the label January Sales. In this cell, you
created a hyperlink to a cell in the January worksheet, but you did not customize the
ScreenTip. What ScreenTip displays when you point to cell C5 in the Summary
worksheet? - Answer -Workbook name, worksheet name, cell reference, and clicking
instructions
You want to display a worksheet within a workbook on a virtual conference call. The
workbook contains several worksheets containing confidential data. To prevent yourself
from accidentally displaying the confidential data, what should you do with those
worksheets? - Answer -Hide the worksheets
A worksheet contains over 400 rows. The first 10 rows contain input data, and functions
containing summary statistics are in the last 10 rows. What is the most efficient method
to see the input area and summary statistics at the same time without having to scroll
back and forth between sections? - Answer -Use the Split command and adjust one
pane to see the input section and another pane to see the summary statistics.
Which function correctly adds data in cell D25 across multiple worksheets? - Answer -
=SUM(Monday:Friday!D25)
A workbook contains quarterly worksheets that store columns of data for the respective
months. You created a summary worksheet where you want to display summary data
for all 12 months, one month per column. What is the most efficient method to create
this summary? - Answer -Use the Consolidate tool, selecting both top row and left
column options.
You use Trace Precedents for a cell containing a formula. What indicates an error in the
precedents used? - Answer -A red tracer arrow displays between the dependent and
precedent cells.
You can use the IFERROR function to avoid displaying an error for which type of error?
- Answer -An IFS function that does not contain an exhaustive set of logical tests or a
default logical test TRUE, resulting in a #N/A error.
Which data validation alert style should you use to enable a user to enter invalid data
but indicate the data does not meet the allowed conditions? - Answer -Warning
ANSWERS
You have a workbook that contains sales data where each sales rep's data is stored on
a separate worksheet. Which task is the least likely to be done while the worksheets are
grouped? - Answer -Enter specific values for the first sales rep
Cell C5 in the Summary worksheet contains the label January Sales. In this cell, you
created a hyperlink to a cell in the January worksheet, but you did not customize the
ScreenTip. What ScreenTip displays when you point to cell C5 in the Summary
worksheet? - Answer -Workbook name, worksheet name, cell reference, and clicking
instructions
You want to display a worksheet within a workbook on a virtual conference call. The
workbook contains several worksheets containing confidential data. To prevent yourself
from accidentally displaying the confidential data, what should you do with those
worksheets? - Answer -Hide the worksheets
A worksheet contains over 400 rows. The first 10 rows contain input data, and functions
containing summary statistics are in the last 10 rows. What is the most efficient method
to see the input area and summary statistics at the same time without having to scroll
back and forth between sections? - Answer -Use the Split command and adjust one
pane to see the input section and another pane to see the summary statistics.
Which function correctly adds data in cell D25 across multiple worksheets? - Answer -
=SUM(Monday:Friday!D25)
A workbook contains quarterly worksheets that store columns of data for the respective
months. You created a summary worksheet where you want to display summary data
for all 12 months, one month per column. What is the most efficient method to create
this summary? - Answer -Use the Consolidate tool, selecting both top row and left
column options.
You use Trace Precedents for a cell containing a formula. What indicates an error in the
precedents used? - Answer -A red tracer arrow displays between the dependent and
precedent cells.
You can use the IFERROR function to avoid displaying an error for which type of error?
- Answer -An IFS function that does not contain an exhaustive set of logical tests or a
default logical test TRUE, resulting in a #N/A error.
Which data validation alert style should you use to enable a user to enter invalid data
but indicate the data does not meet the allowed conditions? - Answer -Warning
