Quiz 1

An element of the Excel window that displays the name of the selected cell, table, chart, or object a) Name Box b) Cell content c) Formula bar

a) Name Box

A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas: a) Quick Analysis Tool b) Autocomplete c) Insert Option Button

a) Quick Analysis Tool

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious. a) Legend b) Sparkline c) Axis

b) Sparkline

A cell reference that refers to cells by their fixed position in a worksheet: a) Relative Cell Reference b) Absolute Cell Reference c) Cell address

b) absolute cell reference

An equation that performs mathematical calculations on values in a worksheet: a) Operator b) Formula c) AutoSum

b) formula

An Excel feature that generates and extends values into adjacent cells based on the values based on the values of selected cells: a) AutoFit b) AutoSum c) Auto Fill

c) Auto Fill

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. a) Cell reference b) Cell content c) Cell style

c) Cell Style

The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells. a) Chart Filters b) Chart Type c) Chart Layout

c) Chart Layout

A specific way in which Excel displays number in a cell. a) Label b) Number values c) Number format

c) Number format

A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa. a) Merge & Center b) Insert Axis c) Switch Row/Column

c) Switch Row/Column