Unit 2 Review

What do you call the spreadsheet cell that is in effect and has a heavier black border around it?

• TREND cell

• Basic cell

• SUM cell

• Active cell

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?

• The formula is =ADD(B2:B3).

• The formula is =500-SUM(B2:B3).

• The formula is =SUM(B2:B3)-500.

• The formula is =500-ADD(B2:B3).

Which calculations come last in the order of operations?

• Addition and subtraction

• Calculations with parentheses

• Calculations with exponents

• Division and multiplication

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?

• Estimation

• Round up

• Predict trend

• Format cell

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

• Cell protection

• IF function

• Trend function

• Round up

Which spreadsheet type will determine how well a business has done over the past year?

• Invoice

• Balance sheet

• Profit-and-loss statement

• Budget

When would you use database software instead of spreadsheet or word processing software?

• When I need to perform calculations with data.

• When I need to complete a simple typed document.

• When I need to see table relationships and sort data by custom fields.

• When I need to complete a task of moderate complexity.

What does complex sorting allow that simple sorting does not?

• Data can be sorted according to two different fields.

• Data can be sorted in numerical order.

• Data can be sorted in either ascending or descending order.

• Data can be sorted according to one field.

Penelope wants to search a transaction database to find all customers who spent more than $500 in one day so that these people can receive a coupon. What is the best way for Penelope to find this information?

• She could create table relationships to link all transaction totals that are more than $500.

• She could update the query to only find transaction totals higher than $500.

• She could generate a report because it will automatically filter transactions by their totals.

• She could add search parameters to only find records that have transaction totals higher than $500.

A(n) _____ evaluates a specified data set and returns certain fields from that data set as instructed.

• query

• output

• report

• form