(TCO 5) Excel’s multiple worksheet abilities can do all of
the following EXCEPT:
create Pivot Charts.
group worksheets together to enter data.
display worksheets side by side.
create links among the worksheets.
Question 2. Question
:
(TCO 5) In Excel, which of the following would you perform
to group adjacent worksheets?
Click the first tab, hold Shift, and then
click the last tab.
Click the first tab, hold Ctrl, and then click
the last tab.
Right-click a worksheet tab, then select
Select All Sheets.
Right-click a worksheet tab, then select
Group.
Question 3. Question
:
(TCO 5) When two windows of the same workbook are opened,
Excel adds ________ to the title bar of the second window.
the letter B
the number 2
the letter A
the number 1
Question 4. Question
:
(TCO 5) After saving the arrangement of windows, a workbook
can be opened by opening the ________ file.
worksheet
workspace
workview
worklink
Question 5. Question
:
(TCO 5) Which of the following external references is
correct for a workbook and worksheet that have no spaces?
“[New.Jersey.xlsx]Qtr4!”B6
‘[New.Jersey.xlsx]Qtr4!’B6
[New.Jersey.xlsx]Qtr4!,B6
[NewJersey.xlsx]Qtr4!B6
Question 6. Question
:
(TCO 5) Before you can create an external reference you must
first __________.
select the cell or cells to hold the external
reference.
open the destination workbook and all source
workbooks.
switch to the source workbooks and click the
cells.
click on Insert Function on the Formulas tab.
:
Question 7. Question
:
(TCO 5) Which of the following is the proper use of a 3D formula?
=SUM(Yr1:Yr5!C7)
=SUM(Yr1-Yr5!C7)
=SUM(‘Yr1:Yr5’!C7)
=SUM(“Yr1:Yr5”!C7)
Question 8. Question
:
(TCO 6) A one-variable data table must have at least
________ blank row(s) and ________ blank column(s) between the dataset and the
data table.
two, two
two, one
one, two
one, one
Question 9. Question
:
(TCO 6) Which What-If Analysis tool would be best at
comparing the combined effects of various interest rates and down payments?
Scenario Manager
Goal Seek
One-variable data table
Two-variable data table
Question 10. Question
:
(TCO 6) Which What-If Analysis tool would be best at
determining how much you can borrow for a car loan while paying only $350 a
month?
Scenario Manager
Solver
Data Table
Goal Seek
Question 11. Question
:
(TCO 6) The Scenario Manager dialog box enables you to do
all the following EXCEPT:
format scenarios.
add scenarios.
delete scenarios.
edit scenarios.
Question 12. Question
:
(TCO 6) Before creating a scenario with Scenario Manager, it
is important to know which cells contain the variables you want changed and
the:
scenario names.
formatting of the results.
cells containing the formulas that generate
the results.
final result.
Question 13. Question
:
(TCO 6) What happens when you add a new scenario and generate
a new scenario summary report?
The new report will be created on a new
worksheet.
The new scenario will be included into the old
report.
The new report will be added directly below
the original report.
The new report will replace the original
report.
Question 14. Question
:
(TCO 6) Which of the following commands cannot be used on a
constraint in the Solver Parameters dialog box?
Add
Format
Change
Delete
Question 15. Question
:
(TCO 6) The initial results of a Goal Seek are:
:
automatically entered into the worksheet.
inserted into a new worksheet.
presented visually in a chart.
shown in the Goal
Seek Status dialog box.