Deck 52: Advanced Spreadsheet Tools

Question 1

An Excel PivotTable can have a(n)____ applied,so that its rows and columns appear in color.

A) font
B) theme
C) animation
D) style

Answer 1

D

Question 2

When creating a PivotTable,the usual first step in the process is to convert the data in the worksheet to a table.

Answer 2

True

Question 3

In Excel,the term what-if analysis means trying out different values in a worksheet to see how the formula results change.

Answer 3

True

Question 4

Solver is now present in the Analysis group on the DATA tab.What was done to add Solver to the ribbon?

A) Linear programming options were enabled in Excel Options.
B) All add-ins were enabled in Excel Options.
C) The Solver Add-in was enabled in Excel Options.
D) A what-if analysis was created,which enabled the Solver Add-in.

Question 5

In Excel,to use the Solver,you must first purchase it.

Question 6

A PivotTable's name is changed by clicking in the ____ Name box in the PivotTable group on the PIVOTTABLE TOOLS Options tab.

A) Pivot
B) PivotTable
C) Active Field
D) TableName

Question 7

To focus on a smaller portion of your spreadsheet's PivotTable data for analysis,use the ____ tool.

A) Goal Seek
B) Slicer
C) Format
D) Field List

Question 8

A PivotTable can be formatted so that its output looks similar to a row.

Question 9

PivotTables,PivotCharts,and Slicers are all examples of Excel functions.

Question 10

A PivotTable is an Excel table that is used to provide different views of a range of data to assist in the analysis of the data.

Question 11

Data is added to an existing PivotTable by ____ from the PivotTable Field List to its label and filter areas.

A) creating tables
B) entering formulas
C) dragging fields
D) copying

Question 12

With the ____ option,you can plug values into an existing formula within a spreadsheet until you achieve the set of result assigned.

A) What-if analysis
B) Data Validation
C) Solver
D) Goal Seek

Question 13

When creating a new PivotTable to be placed on a new worksheet,the new worksheet is placed ____.

A) to the left of the sheet containing the PivotTable data
B) to the right of the sheet containing the PivotTable data
C) at the front of the list of worksheets
D) at the end of the list of worksheets

Question 14

Use the ____ option to help resolve a problem when you know your target value but two or more variables remain unknown.

A) What-if analysis
B) Data Validation
C) Goal Seek
D) Solver

Question 15

Which add-in should be enabled so that you can predict future auto sales based on past years' performance?

A) PivotChart
B) PivotTable
C) Solver
D) Data Analysis

Question 16

A graphical representation of data in a spreadsheet's PivotTable is referred to as a ____.

A) PivotChart
B) Chart
C) PivotTable
D) ChartTable