WorksheetsExcel and Payroll
Total questions: 20
Worksheet time: 12mins
What is a box called in a spreadsheet?
Cell
Box
Rectangle
Square
What are the labels for the columns?
Letters
Numbers
Which command would you use to group a set of cells together?
Merge
Cut
Format as Table
Cell Group
Which tool allows you to draw edges to cells?
Cell fill
Borders
Wrap Text
Alignment
You hold which key on the keyboard to select separate groups of cells?
CTRL
SHIFT
ALT
DEL
Which symbol is used for multiplication in formula?
*
/
x
@
What is the name of the function that adds up a list of numbers?
SUM
AVERAGE
ALL
ADDUP
What function could you use to find the minimum value in a list?
SUM
MAX
ROUND
MIN
What symbol do all functions or formulas start with?
=
^
+
!
Total pay due after deductions
net pay
social security tax
gross pay
tax base
How do you calculate net pay?
Subtract the total deductions from the total earnings.
Subtract taxes from the total earnings.
Subtract social security from the total earnings.
Subtract Medicare from the total earnings.
