Tags Microsoft Excel Database Programming Business and Industry

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

Microsoft Excel

Mandy Johnston ∙

Lvl 10

∙ 2y ago

☆★☆★☆★☆★☆★

No Reviews

Leave the first rating

Term1/25

Where can you enter data in a spreadsheet

Definition1/25

in a cell

Term1/25

What formula would be used to add two cells together after the equal sign

Definition1/25

column#row+column#column#row#

Term1/25

The formula to calculate percentage is the same as which other function

Definition1/25

division

Term1/25

To analyze data from a survey you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. However the results do not look like percentages. How can spreadsheet

Definition1/25

by changing the decimal to a percentage

Term1/25

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

Definition1/25

multiply first, and then add

Term1/25

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Definition1/25

nested IF statement

Term1/25

Locking a cell so that others cannot alter its contents is known as .

Definition1/25

cell protection

Term1/25

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

Definition1/25

income tax preparation

Term1/25

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

Definition1/25

inventory

Term1/25

Olivia needs to provide a visual summary of expenses to management. She chooses a system that shows different levels for the expenses based on filled in sections. What did she create

Definition1/25

bar graph

Term1/25

Clem has entered the following formula into his spreadsheet VLOOKUP(A5A7G203TRUE). What advanced feature is he using

Definition1/25

lookup table

Term1/25

Molly wants to make some cells in her balance spreadsheet different colors so that she can more quickly find important data. What can she do

Definition1/25

use conditional formatting

Term1/25

Omar wants to know how his organization has been doing financially over the last year. He wants to also compare this information to the previous year's data. What type of spreadsheet document should h

Definition1/25

profit-and-loss statement

Term1/25

Jerry is entering information from the documents that show what customers bought and what they owe. What document is he working with

Definition1/25

invoice

Term1/25

What are the business debts called

Definition1/25

liabilities

Term1/25

Defining table creates links between tables that identify a correspondence of fields from one table to another.

Definition1/25

relationships

Term1/25

Which of the following would be a good example of data where complex sorting would be helpful

Definition1/25

states and cities of hometowns of members of an organizations

Term1/25

Adding to a query specifies conditions that must be met for the values of the records to be returned by the query.

Definition1/25

search parameters

Term1/25

Which of the following type of software is the most powerful for managing complex sets of data

Definition1/25

database software

Term1/25

A business owner wishes to know which clients are the highest paying clients of his business. What tool is he likely to use to find this information

Definition1/25

sorting

Term1/25

Let you show only certain records on a table when you sort them.

Definition1/25

filters

Term1/25

What is an important step to take before entering your first data into your database

Definition1/25

planning

Term1/25

A restaurant owner wants to use a database to help his business. What would be a good thing for him to do first

Definition1/25

ask himself what his purposes will be for using a database

Term1/25

A certain database has numerous tables but they do not share any fields in common. This database will not be as powerful as others because it is not .

Definition1/25

relational

Term1/25

Hiro was using the database to prepare information for a presentation to potential investors. Which tool is he likely to use

Definition1/25

reports

🥳

Great job!

You studied all the cards in this guide.

Rate this guide:

☆★☆★☆★☆★☆★

Rate this Study Guide:

☆★☆★☆★☆★☆★

Cards in this guide (25)

Where can you enter data in a spreadsheet

in a cell

What formula would be used to add two cells together after the equal sign

column#row+column#column#row#

The formula to calculate percentage is the same as which other function

division

by changing the decimal to a percentage

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

multiply first, and then add

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

nested IF statement

Locking a cell so that others cannot alter its contents is known as .

cell protection

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

income tax preparation

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

inventory

Olivia needs to provide a visual summary of expenses to management. She chooses a system that shows different levels for the expenses based on filled in sections. What did she create

bar graph

Clem has entered the following formula into his spreadsheet VLOOKUP(A5A7G203TRUE). What advanced feature is he using

lookup table

Molly wants to make some cells in her balance spreadsheet different colors so that she can more quickly find important data. What can she do

use conditional formatting

profit-and-loss statement

Jerry is entering information from the documents that show what customers bought and what they owe. What document is he working with

invoice

What are the business debts called

liabilities

Defining table creates links between tables that identify a correspondence of fields from one table to another.

relationships

Which of the following would be a good example of data where complex sorting would be helpful

states and cities of hometowns of members of an organizations

Adding to a query specifies conditions that must be met for the values of the records to be returned by the query.

search parameters

Which of the following type of software is the most powerful for managing complex sets of data

database software

A business owner wishes to know which clients are the highest paying clients of his business. What tool is he likely to use to find this information

sorting

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

A restaurant owner wants to use a database to help his business. What would be a good thing for him to do first

ask himself what his purposes will be for using a database

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

➡️

See all cards

5.0

☆★☆★☆★☆★☆★

1 Review

Microsoft Excel

Rate this Study Guide:

Database Programming

To analyze data from a survey you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. However the results do not look like percentages. How can spreadsheet

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Locking a cell so that others cannot alter its contents is known as .

Database Programming

To analyze data from a survey you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. However the results do not look like percentages. How can spreadsheet

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Locking a cell so that others cannot alter its contents is known as .

Database Programming

What is typically unique in each database table

To analyze data from a survey you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. However the results do not look like percentages. How can spreadsheet

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Microsoft Excel

Where can you enter data in a spreadsheet

What function would you use to change the appearance of data in a cell from decimal to percentage

You are trying to determine how many 12-foot boards you need to make a new deck. You will have to cut one board because you need an extra 8 feet. What function would help you determine how many boards

What formula would be used to add two cells together after the equal sign

Microsoft Excel

Where can you enter data in a spreadsheet

The formula to calculate percentage is the same as which other function

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Resources

Top Categories

Product

Company