Spreadsheets

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

17

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

20

Every time you go to the gas station you are 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

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

=IF(B2>6)

Saving a spreadsheet allows you to keep your file for future use. One difference between Microsoft Excel, Google Sheets, Apple Numbers, and Open Office Calc is that ___ saves changes automatically.

Excel

the steps of the information processing cycle

input process output store

In the image, the 4-headed arrow on the edge of the cell allows the user to

move the data

To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the

IF function

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

Which of the following are the two methods of selecting a range of adjoining cells in Excel?

Select the first cell in the range then hold down the shift key and select the last cell in the range Select the first cell in the range and drag down to the last cell

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

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)

Because interest rates are advertised as annual percentage rates (APRs), when using the PMT function to determine a monthly payment it is necessary to divide the rate by:

12

The four basic functions of a computer are to:

1 - accept data input 2 - process data into information 3 - present output 4 - provide storage

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

analogous colors

provide little contrast

Place the following steps in order to create a VLookup.

select the name and range of cell for the vlookup to search click the insert function button search for and select the vlookup button enter the necessary arguments click OK

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

Holding down the ___ allows users to select a range of adjoining cells

shift

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

spreadsheet programs

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

true or false

column

vertical line of cells

In Excel and Sheets the freeze cells or panes option is located in the

view menu

what do dollar signs mean?

an absolute reference

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

sigma sign signifies

autoSUM

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

blue border

Put the steps in order for converting an iCloud Numbers file to an Excel file.

click tools button select download a copy and choose a format name the file save the file

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

color theory

CSV

comma separated values

To select nonadjoining cells in a spreadsheet, hold down the _____ while selecting cells

control or ctrl

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

count function

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? Multiple choice question.

csv

Pivot tables provide a quick way to organize information.In most spreadsheet programs, click the

data tab

row

horizontal line of cells

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

how to open google sheets

login to google account click the apps launcher select google sheets

in the black

making a profit

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

max function

How to save a spreadsheet in excel, numbers, or calc

open file menu name the file determine where the file should be stored select save (or save as)

Useful to showing parts of a whole, the ___ is created by highlighting the desired data and choosing from the Insert menu. Multiple choice question.

pie chart