Unit 4: Post Test: Spreadsheets and Databases

True or False A balance sheet is a type of spreadsheet that shows how well a business has done over the past year.

• True
• False

Leigh has information on how many customers purchase bagels at her coffee shop. With the bagel sales numbers from the past four months, she wants to predict the bagel sales numbers for the next month. What spreadsheet function could she use?

• Format cell
• Predict trend
• Estimation
• Round up

Which calculations come last in the order of operations? (**Think PEMDAS)

• Division and multiplication
• Calculations with exponents
• Addition and subtraction
• Calculations with parentheses

True or False An active cell is the cell that is currently selected in a spreadsheet and has a heavier black boarder around it.

• True
• False

Jerry keeps a spreadsheet of all the tools he owns. He wants to figure out how many nails and screws he has so he knows how many more he needs to buy to have 500 total. If the number of nails and screws is in cells B2 and B3, what formula would he use to solve this problem?

• =500-SUM(B2:B3)
• =SUM(B2:B3)-500
• =500-ADD(B2:B3)
• =ADD(B2:B3)

When we use the * symbol in a formula it means

• Addition
• Subtraction
• Multiplication
• Division

True or False You would use a nested IF statement to calculate a person's tax rate based on earnings.

• True
• False

Why would you want to create a bar graph from a budget spreadsheet?

• To look at the percentage of your whole budget being spent in a particular area
• To see how much your budget has increased from the previous year
• To see the change over time of how you spend your money
• To see where most of your money is going

Which spreadsheet function is used to conduct a logical test to see if the conditions of a given expression can be met?

• Cell protection
• Round up
• IF function

True or False The purpose of a report is to display data returned from a query in a specially formatted way.

• True
• False