All Categories
Computer Skills
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 ________.