1) Which of the following is true about creating a blank PivotTable? (1 point) A
ID: 424047 • Letter: 1
Question
1)
Which of the following is true about creating a blank PivotTable?
(1 point)
A PivotTable may only be created from a table.
A PivotTable may be created on the same worksheet as the source data.
A PivotTable may not be created on a connection to an external dataset.
A PivotTable may not be created from a range.
3)
Which of the following is not controlled by a PivotTable style?
(1 point)
bold fonts
borders
subtotal calculations
row and column shading
4)
A PivotChart ________.
(1 point)
does not use a PivotTable's COLUMNS area fields
represents the consolidated data of a PivotTable visually
is not altered by filters and slicers
displays fields from the VALUES area on the legend
5.)
You would like to see both average sales and total sales for a category in a pivot table. Which of these would best accomplish both a Total and an Average column on the field Sales?
(1 point)
Add sales to the VALUES area once and select both AVERAGE and SUM functions.
Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.
Add sales to the ROWS area and then choose Average.
Add sales to the COLUMNS area.
6)
Creating a data model in Excel is very similar to creating relationships between tables in Access.
(1 point)
True
False
7)
Build a PivotChart in the PivotChart wizard on the PivotTable Tools Design tab.
(1 point)
True
False
8)
You cannot change the label of a value.
(1 point)
True
False
9)
You cannot create custom calculations in a PivotTable.
(1 point)
True
False
10)
Match each of the following Show Value as Options to its best description:
(5 points)
No Calculation
Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Grand Total
Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Column Total
Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Row Total
Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Parent Row Total
11)
A(n) ________ specifies the cell that contains a formula that produces the value to be optimized with Solver.
(1 point)
variable cell
target cell
objective cell
set value
12)
If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?
(1 point)
3.0%, 3.25%, 3.5%, 3.75%
APR
$150,000, $160,000, $170,000
$583.73, $630.02, $659.97
13)
The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.
(1 point)
constraints
goal seek cells
objective cells
changing variable cells
14)
________ values replace the original value of a variable in a data table.
(1 point)
Table
Primary
Substitution
Range
15)
Where would you setup the two substitution values in a two-variable data table?
(1 point)
In the first row and first column in the table
In the Series dialog box
In the bottom row and last column
Excel does this for you.
16)
A Scenario Manager Summary report displays the single best input to achieve the desired outcome.
(1 point)
True
False
17)
The number of scenarios that Scenario Manager can manage is unlimited.
(1 point)
True
False
18)
A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.
(1 point)
True
False
19)
Solver is on the Formulas tab.
(1 point)
True
False
20)
Match each of the following terms to its best description:
(5 points)
Objective cell
An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Solver
An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Optimization model
An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Binding constraint
An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Non-binding constraint
Which of the following is true about creating a blank PivotTable?
(1 point)
A PivotTable may only be created from a table.
A PivotTable may be created on the same worksheet as the source data.
A PivotTable may not be created on a connection to an external dataset.
A PivotTable may not be created from a range.
Explanation / Answer
Answer: 1 Option (A) A PivotTable may only be created from a table.
Answer: 3 Option (A) Bold Font
Answer: 4 Option (B) represents the consolidated data of a PivotTable visually
Answer 5 Option (B) Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.
Answer: 6 True
Answer: 7 True
Answer: 8 False
Answer: 9 False
Answer: 10
No Calculation -Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Grand Total - Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Column Total - Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
% of Row Total - Each value displays as a percentage of the hierarchical level above it.Each value displays as a percentage of the whole and adds up to 100%.Default value shows the raw summary of the value.Each value shows as a percentage of the row.Each value displays as a percentage of the column.
Answer: 11 Option © objective cell
Answer; 12 Option (A) 3.0%, 3.25%, 3.5%, 3.75%
Answer: 13 Option (B) Goal Seek cell
Answer: 14 Option (C ) Substitution
Answer: 15 Option (D) Excel does this for you.
Answer: 16 False
Answer: 17 False
Answer: 18 True
Answer: 19 False
Answer: 20
Objective cell- An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Solver- An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Optimization mode- An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
.Binding Constraint - An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you imposeCell that contains the formula to produce a value to be optimizedFind the highest, lowest, or exact value for one particular result by adjusting values for selected variablesA limit that Solver must follow to find the optimal valueA constraint that does not restrict the target value that Solver finds
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.