Year 7 Spreadsheet basics

A spreadsheet program is used to store data in:

• a database.

• a text document.

• rows and columns.

• letters and numbers.

Spreadsheet rows are easily identified by:

• Numbers.

• Letters.

• Roman numerals.

• Colours.

Spreadsheet columns are easily identified by:

• Roman numerals.

• numbers.

• letters.

• colors.

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

• Column C

• =SUM

• Row 1

• A5

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

• Formulas

• Calculations

• Functions

• Spreadsheet data

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

• Formulas

• Conditional formatting

• Functions

• Spreadsheet data

What is the purpose of spreadsheets?

• To present information on different engaging slides

• To deliver a speech to a crowd

• To perform basic and complex mathematical calculations in an organized way

• To excel your written work

Which formula would be used to calculate a total?

• =MAX(B5:B10)

• =SUM(B5:B10)

• =AVGERAGE(B5:B10)

• =SUM(B5*B10)

Which formula would be used to calculate average?

• =MAX(B5:B10)

• =SUM(B5:B10)

• =AVGERAGE(B5:B10)

• =SUM(B5*B10)

Which formula would be used to calculate the largest number?

• =MAX(B5:B10)

• =SUM(B5:B10)

• =AVGERAGE(B5:B10)

• =SUM(B5*B10)