answersLogoWhite

0

Microsoft Excel

User Avatar

Nelda Stiedemann

Lvl 10
∙ 4y ago
☆★☆★☆★☆★☆★
No Reviews
Leave the first rating

Rate this Study Guide:

☆★☆★☆★☆★☆★
Cards in this guide (25)
Is it true that Formatting can change the actual data of a cell

No it will just change the appearance of a label, it does not alter the data.

What pitch is a viola

C3 to C6

Where can you enter data in a spreadsheet

in a cell

How does email software protect the privacy of your messages

serves encrypt all incoming and outgoing messages

Which of the following is a defining characteristic of microcomputers

microcomputers are small enough for individuals to use

Which operating system introduced new features such as virtual memory and the ability to drag and drop files in 1991

macintosh

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.

Clem just bought a new local printer and wants to connect it to her laptop. How can she do this

plug the printer's cord into the laptop's USB port

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

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

cell protection

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

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

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

database software

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

Search can be added to queries to obtain more specific results.

parameters

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

reports

Related study guides