NEW
Font size
WorksheetsExcel Quiz Review
Total questions: 14
Worksheet time: 7mins
Using the handout at your workstation, identify letter A.
Active Cell
AutoSum
Column
Wrap Text
Using the handout at your workstation, identify letter C.
Auto Sum
Name Box
Row
Wrap Text
Using the handout at your workstation, identify letter D.
Active Cell
Merge & Center
Name Box
Wrap Text
Using the handout at your workstation, identify letter E.
Active Cell
Column
Name Box
Row
Using the handout at your workstation, identify letter F.
Name Box
Wrap Text
Column
Row
To calculate the total of cells F1, F2, F3, and F4, you would use the ______ function
Average
MAX
MIN
SUM
The formula to calculate 7% of cell E11 is:
=E11+7%
=E11-7%
=E11*7%
=E11/7%
The place where a row and column intersect is called:
Active cell
AutoFill
AutoSum
None of the above
A feature that automatically continues a series of text/data based on a pattern you create is called _____.
Active cell
Auto Fill
AutoSum
An Excel file never contains more than one worksheet.
True
False
A _____ is a group of cells in a row, column, or block.
formula
label
range
workbook
In cell C5 you enter the text "Item Cost", this entry is a _____.
label
value
In cell C6 you enter the number 102.37, this entry is a _____.
label
value
A formula is an equation or instruction that performs calculations, such as adding, subtracting, averaging, etc.
True
False
