APCSP T3.3.3

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

What does complex sorting allow that simple sorting does not?

Why does each record need a unique ID number?

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

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

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

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

Which calculations come last in the order of operations?

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

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

What is the purpose of a report?

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

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

What do parameters allow you to do?

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

Which consideration should you identify when building a database?

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

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

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

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