APCSP T3.3.3

search a database quickly for info on the last time a patient came in. Which feature would make the most sense to use?

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

Which calculations come last in the order of operations?

Why does each record need a unique ID number?

What does complex sorting allow that simple sorting does not?

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

What mathematical process is the following formula performing: C2*D3?

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

Penelope wants to search for all customers who spent more than $500 in one day.What is the best way to do this?

A _____ saves your query and formats it in a professional-looking way.

Which consideration should you identify when building a database?

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

In which scenario would you need to use a nested IF statement?

Keeps track of the monthly rent, electric bill, water bill, and Internet bill. Which cells would it make sense to lock?

What do parameters allow you to do?

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

Ana wants to predict the bagel sales numbers for the next month. What spreadsheet function could she use?

What is the purpose of a report?

If the number of nails and screws is in cells B2 and B3, what formula would Paul use to solve this problem?

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