Chapter 4 - Spreadsheets _MISY_3310

In the image, if the Enter key is pressed, what will appear in cell A3?

#DIV/0!

Select all that apply Which of the following are the common uses of spreadsheets?

-Finance -Budgeting

Column D shows the value of each sale for the day. If you want cell D37 to display the number of sales, you would use the ( ) function.

COUNT

To delete column D, ( ) -click and then select Delete from the menu.

right

Placing the cursor between row headings 3 and 4 allows you to adjust the:

row height.

An advantage of using Google Sheets is that any changes made are automatically ( ).

saved

Color ( ) attempts to describe how colors convey feeling. It also describes the way most people perceive messages through color.

theory

In the image, the user has placed the pointer between columns B and C. This will allow the user to adjusts the column ( )

width or size

In the Excel image, cell A3 contains a formula that subtracts A1 (Panda) from A2 (20). If the user hits the Enter key, what will appear in cell A3?

#VALUE!

The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip?

$10.50

You treat a classmate for a coffee and decide to leave a 20% tip on your $12 bill. What will be the total charge on your debit card?

$14.40

Put the steps in order for opening Google Sheets.

1. Login to your google account 2. Click the Apps Launcher 3. Select Google Sheets

What does the above symbol represent in spreadsheets?

AutoSUM

If you want to find the mean of the values in cells A1, A2, and A3, what function would you place in A4?

Average

Programs, such as Microsoft Excel, iWorks (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called _____ programs.

spreadsheet

Computer programs that allow users to easily arrange, calculate, and present numerical data are called programs.

spreadsheets

Sports analysts often use ___ to keep track of statistics, times, and scores of nearly every sporting event.

spreadsheets

Which cell contains a value?

A2

What function would you use to display how many entries are made in column A above cell A37?

COUNT

You created a spreadsheet in Calc and wish to add chart elements. You know they are located in the Insert menu, but when you click on the menu the options to add elements are not appearing. This is because you have not:

selected the chart.

Because they make it easy to arrange, display, and calculate numerical data, ___ programs are often used in budgeting, accounting, finance, grading, gambling houses, and even sports analysis.

spreadsheet

Select all that apply Which of the following statements are true regarding labels?

-Can be created by typing an apostrophe in front of a number -Remain on the left side of a cell when entered -Usually a text or text+number combination

In the above Calc file, the user has selected D.

column

In the image, if the user right-clicks and selects Insert, a blank column will be inserted to the of column D.

left

To display the highest value in a range quickly, use the ( ) function.

max

Use the AutoSUM function if you want to quickly ( ) a series of values in a spreadsheet.

add or sum

If you type = 2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

20 (it solves the answer for you)

If you see the Apache OpenOffice icon on your desktop, you know that there probably is spreadsheet software on the computer. The spreadsheet program in OpenOffice is called ( ).

Calc

A pivot table can quickly organize a spreadsheet's info. The pivot table creation options are located under the ___ tab.

Data

If you are using OpenOffice Calc and wish to send your spreadsheet to a colleague who uses Microsoft Excel, use the ___ feature.

Save As

Which principle of finance states that a dollar in your hand today is worth more than a dollar you will receive in the future because a dollar in hand today can be invested to turn into more money in the future?

TVM (Time Value of Money

In Numbers (above) the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the:

View.

In the spreadsheet above the word Uber is found in B6. B6 is called a reference.

cell

Select all that apply In the image, which of the following two methods allow a user to move the data in cell C3 to another cell?

-Drag the data to the desired cell since the drag-hand is already showing -Right-click the cell and then cut and paste the data into the desired cell

Select all that apply The active cell in a spreadsheet is the cell into which the user can input data. In most spreadsheet programs the active cell can be identified by which of the following items?

-Name box (in the upper left corner of the sheet) -Highlighted column and row headings -Heavy border

Match the spreadsheet with its manufacturer. Numbers Sheets Calc Excel

-Numbers --- Apple -Sheets --- Google (Alphabet) -Calc --- OpenOffice (Apache) -Excel --- Microsoft

Select all that apply Select three reasons why many presenters use color in their spreadsheets.

-Color can be used to highlight trends or outlying data. -Color can make it easy to see different categories of data. -Color can make the data more memorable.

In most spreadsheet programs the active cell is shown with a thick black border. In Google Sheets (as shown above), the active cell has a thin ( ) colored border.

blue

If you do not see the Numbers icon on your iMac toolbar, you could go to the Launchpad to open the app. Alternatively, you could look for it through the ( ).

Finder

To create a chart in Excel, first highlight the appropriate data and then open the ( ) menu.

Insert

You have just highlighted the data you wish to depict with a chart. Which tab should you open next to create the chart?

Insert

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ( ) tab to create a pivot table.

data

There are various pointer functions included with most spreadsheet programs. It is important to check on the style of the pointer to ensure you are executing the correct command.

True

In spreadsheets all functions and calculations begin with __.

an equals sign (=)

In most spreadsheet programs, the first step in adding chart elements is to ___.

select the chart

If you type = 3 + 22 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

135 (it solves the answer for you)

You made a simple spreadsheet for an online class assignment for a group project and want all group members to be able to open it regardless of what spreadsheet program they use. Which format would be the best to use?

CSV

To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the function.

PMT or payment

In the spreadsheet above, the entries in cells A1 and B2 look the same, but A1 contains a ___ while B2 contains a label.

value

You need to save your OpenOffice Calc file as an Excel file so that you can then e-mail it to a coworker. Place the following steps in the correct order with the first step at the top.

1. Open the File menu 2. Select Save As 3. Choose a folder and name the file 4. Open the Save as type menu 5. Select Excel

Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order, placing the first step at the top.

1. Open the file menu 2. Name the file 3. Determine where the file shall be stored 4. Select Save (or Save As)

To quickly display the highest number of boxes of cookies purchased by one buyer (column B), use the ___ function.

Max

Select all that apply Which of the following arguments must be entered when using the PMT function?

Rate Nper Pv

Match the color with their impact, according to basic color theory. Red through yellow (including browns) Green through violet (including greys)

Red through yellow (including browns) -- Tend to excite, or to make data come forward in most viewers' perception Green through violet (including greys) -- Tend to calm, or make data recede in most viewers' perception

___ clicking on the row heading for row 3 and selecting Insert will put a blank row above row 3.

Right

Complete the problem. The IF function uses logical tests. A logical test is any value that can be evaluated as:

True or False.

In the spreadsheet above, if you wanted to make cell B2 show the sum of cells A2 and B1 you would first click on cell B2 and then enter:

an equals sign.

In the image, the 4-headed arrow on the edge of the cell allows the user to ( ) the data.

drag or move

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ___ options.

freeze

You created a simple spreadsheet in Google Sheets and wish to send the data to a friend. If you do not know what spreadsheet program your friend uses you should send it as a ___ file since it can be opened in any spreadsheet program.

.csv

An easy means of depicting different categories of items in a spreadsheet is to use different ___ to separate the categories.

colors

In this worksheet, what is in cell C5?

$14.67

In the above Calc file, cell B3 contains the text entry, Cookie Sales. In spreadsheets, this sort of entry is referred to as a(n) ( ).

label

If you type = 8 / 2 * 4 + 1 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

17 (it solves the answer for you)

Which of the following IF function logical tests would show if a student scored above 60% in the 10-point quiz results shown above?

=IF(B2>6)