Excel

Chapter 2 Study Guide

Correct answers in GREEN. Your answers in BLUE. | Review Page |

1. | A formula in a cell that contains a reference back to itself is called a ____ reference.

A: hidden

B: loop

C: nested

D: circular | EX 73 |

2. | The Edit the Rule Description area allows you to view and edit the rules for the ____ format.

A: specified

B: narrow

C: customized

D: conditional | EX 100 |

3. | The ____ is the order in which arithmetic operators are calculated.

A: order of values

B: order of operations

C: order of signs

D: order of calculations | EX 75 |

4. | ____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.

A: Fit

B: Fit-to-Contents

C: Fill

D: Best Fit | EX 103 |

5. | To override the order of operations, use ____.

A: brackets

B: asterisks

C: quotes

D: parentheses | EX 75 |

6. | To check the spelling of the text in a single cell, double-tap or double-click the cell to make the formula bar active and then tap or click the Spelling button (____ tab | Proofing group).

A: REVIEW

B: VIEW

C: FORMAT

D: DATA | EX 109 |

7. | The ____ button gives options for how to fill cells following a fill operation.

A: Insert Options

B: Auto Fill Options

C: Auto Sum

D: Format Fill | EX 79 |

8. | The default view for a worksheet is ____.

A: Normal View

B: Standard View

C: Page View

D: Basic View | EX 110 |

9. | The ____ function sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range.

A: RANGE

B: MIN

C: MEAN

D: AVERAGE | EX 86 |

10. | The ____ version of a worksheet shows the results of formulas.

A: results

B: values

C: formulas

D: calculations | EX 115 |

11. | ____ colors tend to reach towards your worksheet's reader.

A: Cooler

B: Darker

C: Warmer

D: Brighter | EX 93 |

12. | A(n) ____ is a prewritten formula that is built into Excel.

A: operation...