answersLogoWhite

0

Microsoft Excel

User Avatar

Haylee Leannon

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 function would you use to change the appearance of data in a cell from decimal to percentage
Definition1/25

I would use the Format options, not a function.

Term1/25
Scanning for viruses and checking for patches are two ways to software.
Definition1/25

troubleshoot

Term1/25
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
Definition1/25

roundup

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
Of the following which calculation comes first in the order of operations
Definition1/25

parentheses

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
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
Which of the following is an example of a database
Definition1/25

the names and ages of children in a class

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

relationships

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
In the diagram below DE is parallel to XY what is the value of x 110
Definition1/25

(apex) its 110

🥳
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 function would you use to change the appearance of data in a cell from decimal to percentage

I would use the Format options, not a function.

Scanning for viruses and checking for patches are two ways to software.

troubleshoot

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

roundup

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

Of the following which calculation comes first in the order of operations

parentheses

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

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

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

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

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

Which of the following is an example of a database

the names and ages of children in a class

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

relationships

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

In the diagram below DE is parallel to XY what is the value of x 110

(apex) its 110

Related study guides

Math and Arithmetic

23 cards

Area of trapezoid

Some of the eye of the tiger notes on alto saxophone

How can 8 friends share 3 bags of candy and what would the fraction be

Mary traveled 200 miles at an average rate of 50 miles per hour how long did it take her

➡️
See all cards
☆★☆★☆★☆★☆★
No Reviews

Math and Arithmetic

18 cards

What human relations skills is most clearly related to communication

Near the end of page 124 of your reading material you are shown a calculation to determine a car's final speed after accelerating for four seconds

Which agents of socialization are most important at certain stages of human development

What is a veterinary assistant required clothing

➡️
See all cards
3.0
☆★☆★☆★☆★☆★
2 Reviews

Math and Arithmetic

24 cards

Two people are painting a fence one takes 3 hours to complete the job and one takes 6 hours to complete the same job how long would it take for both to complete the same job

Some of the eye of the tiger notes on alto saxophone

Martha wants to rent a car for a week and to pay no more than 130 How far can she drive if the car rental costs 94 per week plus 12 a mile

The hypotenuse of a triangle is 5 feet long The longer of the two legs is one foot longer than the other Find the length of the shorter leg

➡️
See all cards
3.0
☆★☆★☆★☆★☆★
4 Reviews

Math and Arithmetic

18 cards

What term describes an educated guess about what the answer to a question might be

The custom of watching fireworks on the Fourth of July would be studied by this social science

A jogger runs at an average speed of 5 ms for 3 minutes then finishes with an average speed of 4 ms for 2 minutes What is his average speed in ms for the run

The hypotenuse of a right triangle is 50 meters long and one side is 30 meters long What is the length of the remaining side

➡️
See all cards
3.0
☆★☆★☆★☆★☆★
1 Review

Geometry

27 cards

What is the measure of RVE

Four points are always coplanar if

What types of statement can be used to explain the steps of a proof

What is three-dimensional and infinitely large

➡️
See all cards
☆★☆★☆★☆★☆★
No Reviews

Resources

Leaderboard All Tags Unanswered

Top Categories

Algebra Chemistry Biology World History English Language Arts Psychology Computer Science Economics

Product

Community Guidelines Honor Code Flashcard Maker Study Guides Math Solver FAQ

Company

About Us Contact Us Terms of Use Privacy Policy Disclaimer Cookie Policy IP Issues
Answers Logo
Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.