Computer Skills Questions

________ 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.