NEW
Font size
WorksheetsCFII: Unit 4 Study Guide
Total questions: 25
Worksheet time: 13mins
Your employer withholds money from each paycheck. What is this money used for?
To deposit into a separate company account.
To pay for federal and state taxes and other deductions.
To maintain your office building.
To make up for hours of work you missed.
A spending plan or record of projected and actual income and expenses over a period
Budget
Credit
Debt
Saving
Money earned from investments and employment
Expense
Budget
Credit
Income
The cost of goods and services, including those that are fixed (such as rent and auto loan payments) and those that are variable (such as food, clothing, and entertainment).
Expenses
Debt
Checking
Saving
The process of setting income aside for future spending.
Budget
Savings
Credit
Income
What is Jonathan’s gross income for this period?
$644.41
$2,100
$800
$875
How much social security tax has been deducted from Jonathan’s paycheck this year?
$30.45
$307.20
$130.20
$54.25
What is usually written in the box that the arrow is pointing to?
The check account owner's name
The check amount in numbers
The payer's signature
The check amount in words
What is usually written on the line that the arrow is pointing to?
The payee (Person or store receiving the check)
The payer (Person writing the check)
The check amount in words
The check account owner's name
______ moves data to a new line when the cell is not wide enough to display all the contents
Alignment
Merge & Center
Wrap Text
Number Format
______ combines several cells into one cell and centers the data in the merged cell
Alignment
Merge & Center
Wrap Text
Number Format
______ changes the way numbers looks in a cell
Alignment
Merge & Center
Wrap Text
Number Format
_____ determines the best width for a column or the best height for a row based on its contents
Autofit
Number Format
Merge
Alignment
A chart is a graphical representation of data.
True
False
A cell is the intersection of a row and column.
True
False
In the picture, which of the following functions would be correct to show the result you see in cell F12?
=SUM(F7:F11)
=SUM(F5:F10)
+SUM(F7:F11)
SUM(F7:F11)
The arrow in the picture is pointing to which part of a formula?
Function Name
Argument
Equal Sign
Range Reference
What is arrow #10 pointing to?
File Name
Name Box
Formula Bar
Sheet tab
Every formula begins with a/an
Equal sign
Parenthesis
Function name
Argument
The following formula is written correctly: =MIN(A2:A10)
True
False
The picture shows an example if which formatting feature in Excel?
Orientation
Wrap Text
Merge & Center
Number Format
You would use the tool pictured to perform what operation in Excel?
adjust the height of a row
autofill the contents of a cell
adjust the width of a column
select the entire column
If a cell containing numbers is too small to fit within the cell, it will display as
#####
!!!!!!
blank cell
Numbers will carry over to the next cell
Columns appear vertically and are identified by letters at the top of the worksheet window.
True
False
What's the difference between net pay and gross pay?
Net pay is what you deposit into an account and gross pay is what you cash.
Gross pay is what you get from a full time job and net pay is what you get from a part time job.
Net pay is your total paycheck and gross pay is what you take home after taxes.
Gross pay is your total paycheck and net pay is what you take home after taxes.
