1 of 30
Term
How can you determine if the Solver add-in is active?
(Check all that apply)
A. Solver is an option in the Home tab of the Ribbon
B. Solver is available via right-click
C. Solver appears in the Data tab of the Ribbon
D. Solver appears in the Goal Seek dialog box to make it appear as a
label.
Give this one a try later!
A and C Lookup_value
D C
Don't know?
, 2 of 30
Term
The original mortgage loan was for $300,000 with a 5% APR for 30
years. You want to calculate the interest on the last monthly payment
at the end of the 15th year. What value should be referenced for the
per argument in the IPMT function? Hint: Number of payment
periods in a year is 12.
a. 180
b. 15
c. 30
d. 0.05/12
Give this one a try later!
D B
C A
Don't know?
3 of 30
Term
What settings should you select for a PivotTable if you want to apply
a different color scheme and display different fill colors for main
category rows and horizontal lines within the PivotTable?
A. Banded Rows check box and a different PivotTable style.
B. Banded Columns check box and a different PivotTable style.
, C. Banded Rows and Banded Columns check boxes.
D. A different PivotTable style only.
Give this one a try later!
D A
C B
Don't know?
4 of 30
Term
Which of the following tools can incorporate constraints?
A. Goal Seek
B. Solver
C. Data Tables
D. Scenario Manager
Give this one a try later!
C A
B D
Don't know?
Term
How can you determine if the Solver add-in is active?
(Check all that apply)
A. Solver is an option in the Home tab of the Ribbon
B. Solver is available via right-click
C. Solver appears in the Data tab of the Ribbon
D. Solver appears in the Goal Seek dialog box to make it appear as a
label.
Give this one a try later!
A and C Lookup_value
D C
Don't know?
, 2 of 30
Term
The original mortgage loan was for $300,000 with a 5% APR for 30
years. You want to calculate the interest on the last monthly payment
at the end of the 15th year. What value should be referenced for the
per argument in the IPMT function? Hint: Number of payment
periods in a year is 12.
a. 180
b. 15
c. 30
d. 0.05/12
Give this one a try later!
D B
C A
Don't know?
3 of 30
Term
What settings should you select for a PivotTable if you want to apply
a different color scheme and display different fill colors for main
category rows and horizontal lines within the PivotTable?
A. Banded Rows check box and a different PivotTable style.
B. Banded Columns check box and a different PivotTable style.
, C. Banded Rows and Banded Columns check boxes.
D. A different PivotTable style only.
Give this one a try later!
D A
C B
Don't know?
4 of 30
Term
Which of the following tools can incorporate constraints?
A. Goal Seek
B. Solver
C. Data Tables
D. Scenario Manager
Give this one a try later!
C A
B D
Don't know?
