parameters let you run more specific and complex queries
🔄 Click to see term
Term1/17
Which of the following considerations should you identify when building a database
🔄 Click to see definition
Definition1/17
i should recognize what i want to do with the data
🔄 Click to see term
Term1/17
Let you show only certain records on a table when you sort them.
🔄 Click to see definition
Definition1/17
filters
🔄 Click to see term
Term1/17
What is an important step to take before entering your first data into your database
🔄 Click to see definition
Definition1/17
planning
🔄 Click to see term
Term1/17
Hiro was using the database to prepare information for a presentation to potential investors. Which tool is he likely to use
🔄 Click to see definition
Definition1/17
reports
🔄 Click to see term
Term1/17
Kieran wants to search a database quickly for information on the last time a patient came to his medical facility. This information is contained in one table. Which feature would make the most sense f
🔄 Click to see definition
Definition1/17
sort
🔄 Click to see term
Term1/17
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 scre
🔄 Click to see definition
Definition1/17
the formula is =500-sum(B2:B3)
🔄 Click to see term
Term1/17
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.
🔄 Click to see definition
Definition1/17
predict trend
🔄 Click to see term
Term1/17
What mathematical process is the following formula performing C2D3
🔄 Click to see definition
Definition1/17
multiplication
🔄 Click to see term
Term1/17
In which of the following scenarios would you need to use a nested IF statement
🔄 Click to see definition
Definition1/17
to calculate a person's tax rate based on earnings
🔄 Click to see term
Term1/17
Why does each record need a unique ID number
🔄 Click to see definition
Definition1/17
a unique ID number is essential if you want to build to proper
relationships between tables
🔄 Click to see term
Term1/17
Elliot keeps spreadsheets of the expenses required to keep his stationary store in business. One keeps track of the monthly rent electric bill water bill and Internet bill. Which cells would it make s
🔄 Click to see definition
Definition1/17
rent and internet bill
🔄 Click to see term
Term1/17
Which calculations come last in the order of operations
🔄 Click to see definition
Definition1/17
addition and subtraction
🔄 Click to see term
Term1/17
Which spreadsheet type will determine how well a business has done over the past year
🔄 Click to see definition
Definition1/17
profit-and-loss statement
🔄 Click to see term
Term1/17
Why would you want to create a bar graph from a budget spreadsheet
🔄 Click to see definition
Definition1/17
to see where most of your money is going
🔄 Click to see term
Term1/17
A saves your query and formats it in a professional-looking way.
🔄 Click to see definition
Definition1/17
report
🔄 Click to see term
Term1/17
How does information technology bring employees closer to upper management
🔄 Click to see definition
Definition1/17
employees can with upper management directly through email
🔄 Click to see term
🥳
Great job!
You studied all the cards in this guide.
Rate this guide:
☆★☆★☆★☆★☆★
Start overPrint
Full screen
Rate this Study Guide:
☆★☆★☆★☆★☆★
Cards in this guide (17)
What do parameters allow you to do
parameters let you run more specific and complex queries
Which of the following considerations should you identify when building a database
i should recognize what i want to do with the data
Let you show only certain records on a table when you sort them.
filters
What is an important step to take before entering your first data into your database
planning
Hiro was using the database to prepare information for a presentation to potential investors. Which tool is he likely to use
reports
Kieran wants to search a database quickly for information on the last time a patient came to his medical facility. This information is contained in one table. Which feature would make the most sense f
sort
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 scre
the formula is =500-sum(B2:B3)
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.
predict trend
What mathematical process is the following formula performing C2D3
multiplication
In which of the following scenarios would you need to use a nested IF statement
to calculate a person's tax rate based on earnings
Why does each record need a unique ID number
a unique ID number is essential if you want to build to proper
relationships between tables
Elliot keeps spreadsheets of the expenses required to keep his stationary store in business. One keeps track of the monthly rent electric bill water bill and Internet bill. Which cells would it make s
rent and internet bill
Which calculations come last in the order of operations
addition and subtraction
Which spreadsheet type will determine how well a business has done over the past year
profit-and-loss statement
Why would you want to create a bar graph from a budget spreadsheet
to see where most of your money is going
A saves your query and formats it in a professional-looking way.
report
How does information technology bring employees closer to upper management
employees can with upper management directly through email