NAME: ________________________

# ← Excel Chapter 2Test

### Question Limit

of 45 available terms

### 5 Matching Questions

1. formulas version
2. Best fit
3. Floating dollar sign
4. New Rule
5. AVERAGE
1. a ______ means that the width of the column will be increased or decreased so the widest entry will fit in the column.
2. b The ________ of the worksheet shows the actual formulas you have entered, rather than the resulting values.
3. c A(n) __________ is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces.
4. d The ________ function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
5. e Click ________ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.

### 5 Multiple Choice Questions

1. True or False: With conditional formatting, if the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting.
2. To save a previously saved workbook with a new name or on a different drive, ________.
3. The process of finding and correcting errors in a worksheet is called _________.
4. The values used with a function are called ______________.
5. The _________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.

### 5 True/False Questions

1. TrueA ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.

2. MAXThe __________ function displays the highest value in a range.

3. conditionIf a _______ is true, then Excel applies the formatting. If false, then Excel suppresses the formatting.

4. Selection option buttonIn the Print dialog box, the _________ instructs Excel to print the worksheet currently on the screen.

5. Increase DecimalThe ________ button lists formatting options following an insertion of cells, rows, or columns.