Excel Review

All Excel formulas begin with the ____.

• plus sign (+)

• equals sign (=)

• minus sign (-)

• colon (:)

In Excel, MAX and AVERAGE are examples of _____.

• lists

• formula prefix

• reference operator

• functions

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

• relative

• absolute

• mixed

• definite

The default file extension for an Excel 2016 workbook is ____.

• .docx

• .xslx

• .xltx

• .xlsx

##### in a cell means that the _____.

• content in that cell is hidden

• column is too narrow to display the value completely

• formula contains an error

• column is too wide for the content

On a chart created in Excel, the horizontal axis is also called the ______.

• x-axis

• y-axis

• z-axis

• category axis

On a chart created in Excel, the vertical axis is also called the ______.

• x-axis

• y-axis

• value axis

• z-axis

The areas between the horizontal axes and the vertical axes is called the ____

• value axis

• category axis

• data markers

• plot area

An example of a _____ chart is a column chart with a line chart.

• complex

• combo

• clustered

• histogram