Excel Chapter 3 Quiz

b. data point

A __________ is a value that originates in a worksheet cell and is represented in a chart. a. legend b. data point c. chart sheet d. data marker

c. pie chart

A __________ shows the relationship of each part of the data to the whole. a. line chart b. bar chart c. pie chart d. column chart

b. relative cell reference

A cell address used in a formula using a(n) __________ will be adjusted appropriately when the formula is copied to another cell. a. general cell reference b. relative cell reference c. absolute cell reference d. base cell reference

False

A line chart emphasizes the distinct values of each data point. True or False

False

A pie chart can only be based on one data series. True or False

False

A pie chart must have a legend. True or False

False

A relative cell reference refers to a cell by its fixed position in the worksheet True or False

c. chart sheet.

A workbook sheet that contains only a chart is called a(n) a. data marker. b. axis. c. chart sheet. d. legend.

d. absolute cell reference

A(n) __________ refers to a cell by its fixed position in the worksheet. a. general cell reference b. relative cell reference c. base cell reference d. absolute cell reference

True

Absolute cell references are indicated by placing a $ in front of the row and column indicators. True or False

False

According to Excel's order of operations, addition and subtraction are done before exponentiation True or False

a. what‐if analyis.

Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing a a. what‐if analyis. b. 3‐D analysis. c. data point analysis. d. why analysis.

b. panes

Excel displays various ________ on the right to enable you to format different chart elements. a. check boxes b. panes c. dialog boxes d. windows

False

Exploding a slice of a pie chart causes it to completely disappear from the chart. True or False

d. what‐if analysis

Goal Seek is an example of a __________ tool. a. charting b. plotting c. function d. what‐if analysis

True

If a value is changed in a cell, Excel recalculates all formulas that reference that cell. True or False

c. line

If you want to chart trends over time, you should use a __________ chart. a. pie b. scatter c. line d. bar

c. chart area

In Excel, the ________ is made up of the chart and all of its elements. a. data marker b. plot area c. chart area d. data point

b. category axis.

On a line chart, the x‐axis is also known as the a. value axis. b. category axis. c. base axis. d. legend axis.

d. value axis.

On a line chart, the y‐axis is also known as the a. base axis. b. legend axis. c. category axis. d. value axis.

False

Once a pie chart is created, it cannot be rotated. True or False

a. legend.

One way to tell which slice of pie on a pie chart goes with which set of data is to look at the a. legend. b. value axis. c. base. d. category axis.

False

When writing a formula in Excel, use quotation marks to specify the order in which the operations should occur. True or False

c. To emphasize the slice to the person viewing the chart.

Why would you explode a slice on a pie chart? a. To change the color of the slice. b. To increase the size of the slice. c. To emphasize the slice to the person viewing the chart. d. To remove it completely from the chart.

True

The AutoFill feature will continue a series based on the values placed in two or more consecutive cells. True or False

False

The order of operations used in Excel says that consecutive operators with the same level of precedence are done from right to left. True or False

True

The plot area and the chart area are the two background elements of an Excel chart. True or False

True

The sizes of pie slices are automatically adjusted when the underlying data values are changed. True or False

d. explode

To __________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart. a. bevel b. tick c. base d. explode

True

Under Paste Options you have the choice to paste the calculated values instead of the formulas. True or False

c. base

When calculating the amount of increase, the __________ is the starting point for the data. a. axis b. rate c. base d. goal