Google Spreadsheets

 A spreadsheet program is used to store data in: 

• a. a database.
• b. a text document.
• c. rows and columns.
• d. letters and numbers.

Spreadsheet rows are easily identified by:

• a. numbers.
• b. letters.
• c. Roman numerals.
• d. colors.

Spreadsheet columns are easily identified by:

• a. Roman numerals.
• b. numbers.
• c. letters.
• d. colors.

Which of the following is an example of a cell reference?

• a. Column C
• b. =SUM
• c. Row 1
• d. A5

A ___________________ is a visual representation of data

• a. spreadsheet
• b. border
• c. chart
• d. table

What is the purpose of spreadsheets?

• a. To present information on different engaging slides
• b. To deliver a speech to a crowd
• c. To perform basic and complex math computations in an organized way
• d. To excel your research papers and citations

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

• =sum(C2:C11)

• =sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

• =sum(D2:D11)

• $13,442.90

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

• =sum(C2:C11)

• =average(C2,C11)

• =average(C2:C11)

• =average(B2:B11)

Which of these is NOT a reason to freeze a row or column?

• To keep others from being able to edit it

• To keep the row or column visible as you scroll through the data

• To exclude the row or column name when you sort the data

• To create a header row with column titles

When you sort data...

• You change the values of the cells.

• You choose how the data will be displayed.

• You remove values that don't fit in your data set.