spreadsheets for businesses

Who made numbers

Apple

A legend shows which items are being identified by the different colors, lines, bars, or pie segments.

True

What are the two most common spreadsheet charts?

bar graphs line graphs

A traditional 30-year mortgage has 12 monthly payments per year. This means the loan has a total of 360 ________.

payments

You created a spreadsheet in Calc and wish to send the data to a friend who only uses Excel. You can do this by using the ___ feature.

save as

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

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

Put the steps in order for opening Google Sheets.

1. log into your google account 2. select the app launcher 3. select google sheets

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 file menu 2. name the file 3. determine where the file should be saved 4. select save or save as

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

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

In spreadsheets all functions and calculations begin with __.

=

Every time you go to the gas station you're amazed by how much prices have increased. At this time last year the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?

= ((4.25 - 3.20) / 3.20) * 100

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 comma separated format

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

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

The total amount of money (principal + interest) that lender receives from a borrower at the end of the loan is referred to as the loan's

FV future value

Who made sheets

Google (Alphabet)

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?

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

Who made calc

OpenOffice (Apache)

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 Money

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 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

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

cell

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

When displaying financial information, the accepted practice is that ________ indicates negative values.

red

To Insert a Column to the left of Column D in an OpenOffic Calc file, select Column D and then ________ and select Insert.

right click

Select three true statements regarding labels.

usually a text or text+number combination can be created by typing an apostrophe in front of a number remain on the left side of a cell when entered

To retain a row or column, but remove it from view, right-click on the row or column heading and select

hide

The amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.

principal

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets.

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

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.

= (25 + 50 + 75) / 3

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.

= (4 + 2 + 5 + 5) / 4

Which of the following are the common uses of spreadsheets?

Finance Budgeting

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

Freeze

Who made excel

Microsoft

Select the two spreadsheet programs.

OpenOffice Calc Apple Numbers

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n) ___.

cell

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's

interest.

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

saved

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

Because they make it easy to arrange, display, and calculate numerical data, ________ programs are commonly used in nearly every business setting.

spreadsheet

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

spreadsheet

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

spreadsheets

Which two of the following refer to the amount of money a lender charges for borrowing money (excluding any origination fees)?

the interest rate the APR (annual percentage rate)

In the spreadsheet above, the entry in cell A1 (Patient), does not interact with other cells and cannot be used in a calculation. In this case, the entry in cell A1 is a ______.

label