Chapter 3

When resizing a chart, which of the following keys can be used to lock a chart to a row or column?

ALT

Any chart that is added to an Excel worksheet. Embedded charts can be moved and resized?

Embedded chart

An Excel analytics tool that uses the same data processing features as a PivotTable but can display trends and comparisons in any of the chart types available in Excel?

PivotChart

An Excel analytics tool that can group and aggregate date to show data comparisons and trends. Data can also be sorted and specific data points can be studied by applying filters?

PivotTable

An Excel data visualization tool that arranges data in a hierarchy so the largest and smallest components of a dataset can be easily identified?

Treemap Chart

Arranging data from lowest value to highest value?

ascending order

Which of the following is true with regards to a PivotChart? a. It must be created on a separate worksheet that does not include a PivotTable. Excel will not be able to process a dataset for both a PivotTable and a PivotChart at the same time. b. It has the same features and processing power as a PivotTable and can display data using several of the chart types available in Excel. c. It has the same features and processing power as a PivotTable but can only display data using the column chart type. d. It has some of the features and processing power of a PivotTable but can display data using any chart type available in Excel.

b. It has the same features and processing power as a PivotTable and can display data using several of the chart types available in Excel.

Which of the following is true with respect to PivotTables? a. To change a field name, click the cell location on the PivotTable that contains the current field name and type a new one. b. To change a field name or format the values in a field, click the field name on the PivotTable and then click the Field Settings button in the Analyze tab of the Ribbon. Make the desired changes using the Value Field Settings dialog box. c. All of the above are true. d. To format the values on a PivotTable, highlight the values and use any of the formatting features in the Home tab of the Ribbon.

c. All of the above are true.

Which of the following would allow you to sort a dataset based on the values in two or more columns? a. The Sort dialog box will set up sort options for every column included in a highlighted range. b. Click the "My data contains headers" check box in the Sort dialog box. c. Click the Add Level button in the Sort dialog box. d. Click the Insert button in the Home tab of the Ribbon and select Sort Level from the dropdown menu.

c. Click the Add Level button in the Sort dialog box.

Which tab of the Ribbon contains the command to add or remove subtotals and grand totals on a PivotTable? a. Insert b. Analyze c. Design d. Home

c. Design

Which of the following is true with respect to data visualization? a. It is the only data visualization tool available in Excel is a Treemap chart. b. It is a way of imagining how data should appear before a worksheet is designed. c. This can be any visual display of data that is presented in an organized manner such that trends and solutions can be easily identified. d. This is a basic technique for presenting data to an audience.

c. This can be any visual display of data that is presented in an organized manner such that trends and solutions can be easily identified.

A worksheet that can only contain a chart and does not contain any cell locations for adding data?

chart sheet

Which of the following must be done to create an effective Treemap chart? a. An add-in feature must be launched first in order to have access to the Treemap chart in Excel. b. After the chart is created, it must be moved to a chart sheet. c. A dataset must be reduced to two columns. d. A dataset must be sorted using the left-most column to establish the first level of the sort sequence.

d. A dataset must be sorted using the left-most column to establish the first level of the sort sequence.

When sorting a dataset, which of the following must be done first? a. The Insert tab of the Ribbon must be opened. b. A new worksheet must be added to the workbook to display the sorted output. c. All of the column headings in a dataset must be hidden or not included in the highlighted range of cells that is being sorted. d. All data in a contiguous range of cells that is being sorted must be highlighted.

d. All data in a contiguous range of cells that is being sorted must be highlighted.

Data analytics technique used for analyzing data visually to make discoveries and find solutions for various data projects?

data visualization

The center area of a chart that displays data and labels based on the chart type, i.e., bars, dots, blocks, etc?

plot area

Circles around the perimeter of a chart indicating the chart is activated. Any of the circles can be clicked and dragged to change the size of a chart?

sizing handles

An analytics technique that arranges a dataset in ascending or descending order based on the values in one or many columns?

sorting