WorksheetsExcel Review
Total questions: 9
Worksheet time: 5mins
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
