1) A ________ is a group of numbers, text, dates, or time periods that come in succession.

A) chain

B) sequence

C) series

D) succession

2) The Excel feature used to automatically adjust column width to the longest column entry is ________.

A) AutoFit

B) AutoComplete

C) AutoAdjust

D) AutoFill

3) The displayed value of a cell is replaced with a series of # symbols when ________.

A) there is an error in the underlying formula

B) the name of a function is misspelled

C) the column is too narrow to display the entire value

D) a cell in the underlying formula has no value

4) Which symbol is the error indicator that appears in a cell having a formula that has broken a rule?

A) green triangle

B) green square

C) red exclamation point

D) yellow caution sign

5) When a section of a worksheet displaying numeric values is selected, the ________ appears; this is used to apply conditional formatting or to insert a chart or table based on the selected content.

A) Quick Access Lens button

B) Quick Analysis Lens button

C) Quick Analysis Lens contextual tab

D) Quick Format Lens button

6) Which is NOT a category in the Quick Analysis gallery?

A) Formatting

B) Charts

C) AutoSum

D) Tables

7) A cell that remains the same when it is copied or filled to other cells is a(n) ________.

A) relative cell reference

B) constant cell reference

C) fixed cell reference

D) absolute cell reference

8) The ________ outlines all the cells referenced in a formula.

A) error value

B) range finder

C) error indicator

D) range detector

9) A message that appears in a cell when a formula cannot perform the specified calculations is a(n) ________.

A) error value

B) failure message

C) edit message

D) error indicator

10) The number of decimals places and the appearance commas, dollar signs, or other symbols are features of number ________.

A) format

B) style

C) layout

D