Computer Skills Questions
Explore questions in the Computer Skills category that you can ask Spark.E!
If you change the underlying data on which a PivotTable report is based, you must also ________ or update the PivotTable to reflect the new data.
After creating several scenarios, you can create a Scenario ___, which compares all options side by side.
By using a PivotTable, you can show the same data in a table in ________.
In a PivotTable, a single piece of information for every record is called a ________.
Solver is located in the ___ group on the Data tab.
A PivotTable report ________ large amounts of data so you can analyze related totals.
Excel uses the column titles as the ________ for the categories of data.
To show trends over time, use a ________ chart.
In the PivotTable field section, you can rearrange existing fields by using which of the following areas in the layout section?
When a numeric field is added to a PivotTable, it is placed in the ________ area of the PivotTable field list.
Which of the following areas of a PivotTable field list enables you to display average values?
A ___ is a set of values that Excel saves and can substitute automatically in your worksheet.
Variable expenses vary depending on the amount of ___
Match the following five terms to their meanings:I.constraintII.decision variableIII.objective cellIV.constraint cellV.variable cellA.In Solver, a cell in which the values will change to achieve the desired results.B.In Solver, a cell that contains values that limit or restrict the outcome.C.In Solver, a cell in which the value will change to achieve the desired result.D.In Solver, this cell contains a formula for the result you are trying to determine.E.In Solver, a condition or restriction that must be met.
________ can help determine values that result in maximum or minimum value for a formula in one cell.
A logical function that adds the values in cells that meet specific criteria in multiple ranges.
In the ________ you can choose between a Scenario summary, which displays the data in a table, or a Scenario PivotTable report.
Use Excel's ___ Manager tool to compare several possible solutions to a problem.
___ is one of Excel's what-if analysis tools with which you can find an optimal value for a formula in one cell
A set of values that Excel saves and can substitute automatically in your worksheet is ________.