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

Addition, subtraction, multiplication and division 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 organised way

• d. To excel your research papers

A1:D4 is an example of a cell...

• Range
• Selection
• Highlight
• Choice

Putting cells into A-Z order is called?

• Sort Ascending
• Sort Descending
• Filter Ascending
• Filter Descending

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

Which of the following is a valid formula?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)