“Question
1. Question :
(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.
IN
create links among the worksheets.
Comments:

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.
Comments:

Question
3. Question :
(TCO
5) If the active cell is in column A, but not in row 1, when you click the
Split command, the worksheet will appear in two ________ panes.
horizontal
IN
vertical
diagonal
square
Comments:

Question
4. Question :
(TCO
5) In Excel, which of the following is NOT a method for splitting a worksheet?
Drag
a split box.
IN
Double-click a split box.
Right-click
in the active cell and click Split.
Click
Split in the Window group on the View tab.
Comments:

Question
5. Question :
(TCO
5) Which of the following external references is for a workbook and worksheet
that have no spaces?
“”[New.Jersey.xlsx]Qtr4!””B6
‘[New.Jersey.xlsx]Qtr4!’B6
IN
[New.Jersey.xlsx]Qtr4!,B6
[NewJersey.xlsx]Qtr4!B6
Comments:

Question
6. Question :
(TCO
5) Excel’s ability to manage worksheets allows you to do all EXCEPT:
validate
data in worksheets.
hide
worksheets.
arrange
windows to view multiple sheets at once.
split
a worksheet window to see separate sections at once.
Comments:

Question
7. Question :
(TCO
5) Which of the following is the proper use of a 3D formula?
=SUM(Yr1:Yr5!C7)
IN
=SUM(Yr1-Yr5!C7)
=SUM(‘Yr1:Yr5’!C7)
=SUM(“”Yr1:Yr5″”!C7)
Comments:

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
Comments:

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?
IN
Scenario Manager
Goal
Seek
One-variable
data table
Two-variable
data table
Comments:

Question
10. Question :
(TCO
6) What is the main difference between Goal Seek and variable data tables?
Goal
Seek produces a list of result values.
Goal
Seek uses the original worksheet data to change an input.
Goal
Seek manipulates multiple variables to produce multiple results.
Goal
Seek shows results in a separate table.
Comments:

Question
11. Question :
(TCO
6) The Scenario Manager dialog box enables you to do all the following EXCEPT:
format
scenarios.
add
scenarios.
IN
delete scenarios.
edit
scenarios.
Comments:

Question
12. Question :
(TCO
6) Which of the following is NOT in the What-If Analysis command in the Data
Tools group on the Data tab?
Scenario
Manager
Goal
Seek
Data
Table
Solver
Comments:

Question
13. Question :
(TCO
6) Which of the following is NOT one of the three parameters in Solver?
IN
Constraints
Objective
cell
Changing
variable cells
Input
value
Comments:

Question
14. Question :
(TCO
6) Which of the following is NOT required for Solver to generate a solution?
Constraints
A
formula that produces a value to be optimized
Precedent
values
IN
Variables that change within the specified limitations
Comments:

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.
Comments:

Question
1. Question : (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.IN
create links among the worksheets.Comments:
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.Comments:
Question
3. Question : (TCO
5) If the active cell is in column A, but not in row 1, when you click the
Split command, the worksheet will appear in two ________ panes.horizontalIN
verticaldiagonalsquareComments:
Question
4. Question : (TCO
5) In Excel, which of the following is NOT a method for splitting a worksheet?Drag
a split box.IN
Double-click a split box.Right-click
in the active cell and click Split.Click
Split in the Window group on the View tab.Comments:
Question
5. Question : (TCO
5) Which of the following external references is for a workbook and worksheet
that have no spaces?””[New.Jersey.xlsx]Qtr4!””B6′[New.Jersey.xlsx]Qtr4!’B6IN
[New.Jersey.xlsx]Qtr4!,B6[NewJersey.xlsx]Qtr4!B6Comments:
Question
6. Question : (TCO
5) Excel’s ability to manage worksheets allows you to do all EXCEPT:validate
data in worksheets.hide
worksheets.arrange
windows to view multiple sheets at once.split
a worksheet window to see separate sections at once.Comments:
Question
7. Question : (TCO
5) Which of the following is the proper use of a 3D formula?=SUM(Yr1:Yr5!C7)IN
=SUM(Yr1-Yr5!C7)=SUM(‘Yr1:Yr5’!C7)=SUM(“”Yr1:Yr5″”!C7)Comments:
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,
twotwo,
oneone,
twoone,
oneComments:
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?IN
Scenario ManagerGoal
SeekOne-variable
data tableTwo-variable
data tableComments:
Question
10. Question : (TCO
6) What is the main difference between Goal Seek and variable data tables?Goal
Seek produces a list of result values.Goal
Seek uses the original worksheet data to change an input.Goal
Seek manipulates multiple variables to produce multiple results.Goal
Seek shows results in a separate table.Comments:
Question
11. Question : (TCO
6) The Scenario Manager dialog box enables you to do all the following EXCEPT:format
scenarios.add
scenarios.IN
delete scenarios.edit
scenarios.Comments:
Question
12. Question : (TCO
6) Which of the following is NOT in the What-If Analysis command in the Data
Tools group on the Data tab?Scenario
ManagerGoal
SeekData
TableSolverComments:
Question
13. Question : (TCO
6) Which of the following is NOT one of the three parameters in Solver?IN
ConstraintsObjective
cellChanging
variable cellsInput
valueComments:
Question
14. Question : (TCO
6) Which of the following is NOT required for Solver to generate a solution?ConstraintsA
formula that produces a value to be optimizedPrecedent
valuesIN
Variables that change within the specified limitationsComments:
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.Comments:
“