All Categories
Computer Skills
Explore questions in the Computer Skills category that you can ask Spark.E!
- ________ are filtering controls with buttons that enable you to drill down through large amounts of data.
- Which of the following is a button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart?
- A logical function that returns a result of TRUE if all the conditions are met.
- Use Solver when you need to make a decision that involves more than ________ variable(s).
- When using Solver, which of the following will not be identified during the process?
- When using Solver, the ________ cell is the cell that contains a formula for the results you are trying to achieve.
- When the Scenario Values dialog box displays, it lists the ________ value in each of the decision variable cells.
- When you choose to add a Scenario Summary, Excel inserts a new ________ in your workbook.
- You can limit the display of data to specific information by using ________.
- Scenario Manager is one of the tools under ________ in the Forecast group on the Data tab.
- In Solver, ________ are cells in which the values will change to achieve the desired results.
- When you use Solver, your worksheet will include ___ cells that contain values that limit or restrict the outcome.
- In a PivotTable report, the calculations can be modified.
- A ___ is a prediction of the future, often based on past performances.
- By default, when a non-numeric field is added to a PivotTable, it is placed in the ________ area.
- Which of the following is a report that is useful when you want to analyze related totals, such as when you have a long list of numbers to sum and you want to compare several facts about each total?
- The ________ is a window that lists all the fields from the source data in a PivotTable and provides an area in which you can arrange the fields in the PivotTable.
- The Clear Filter command removes a filter.
- A sequence of averages computed from parts of a data series is ________.
- The ________ of a function specifies the arrangement of the arguments in the function.