## 50 terms · excel 3

### Deleting the contents of a cell also removes the format that has been applied to the cell.

false

### Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the =.

true

### Percent for new value is calculated using this formula: ________.

Base Percent + Percent of Increase

### 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

What-if Analysis

### The percentage rate of increase is calculated by using this formula: ________.

Amount of Increase/Base

### Under Paste Options you have the choice to paste the calculated values instead of the formulas.

true

### The ________ is the percent by which one number increases over another during a specified time frame.

percentage rate of increase

### According to Excel's order of operations, addition and subtraction are done before exponentiation.

false

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

false

### One way to tell which slice of pie on a pie chart goes with which set of data is to look at the

Legend

### A ________ is a value that originates in a worksheet cell and is represented in a chart.

data point

### A(n) ________ is a line that borders the chart plot area and serves as a frame of reference for measurement.

axis

### Excel's Number format leaves a space at the right of the number for a closing parenthesis in case the value is negative.

false

### A(n) ________ refers to a cell by its fixed position in the worksheet.

absolute cell reference

### Excel's ________ allows you to select a chart element so that you can format it.

Chart Elements box

### To identify which slice of pie corresponds to which set of data points, you look at the value axis.

false

### To ________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

Explode

### A cell address used in a formula using a(n) ________ will be adjusted appropriately when the formula is copied to another cell.

relative cell reference

### Why would you explode a slice on a pie chart?

To emphasize the slice to the person viewing the chart.

### Value after increase is calculated by using this formula: ________.

base * percent for new value

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

true

### When calculating the amount of increase, the ________ is the starting point for the data.

base

### The sizes of pie slices are automatically adjusted when the underlying data values are changed.

true

### Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast?

pie chart