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

A chart ________________ identifies which data series each color represents.

• a. legend
• b. vertical axis
• c. title
• d. horizontal axis

Sum, average, count, maximum value, and minimum value are examples of what?

• a. Formulas
• b. Calculations
• c. Functions
• d. Spreadsheet data

Addition, subtraction, multiplication, division, and exponentiation are examples of what?

• a. Formulas
• b. Conditional formatting
• c. Functions
• d. Spreadsheet data

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

What does this symbol represent in MS Excel?

• a. Subtract
• b. AutoSum
• c. Formula
• d.    Average