Spreadsheets - Year 9 L1

Question 1 of 10

1

Label the key sections of a spreadsheet by dragging and dropping the labels

Drag an answer into the correct orange point.

Row

Cell

Column

Explanation

Question 2 of 10

1

The correct cell reference for this cell is:

Select one of the following:

A1
6B
B6
5B

Explanation

Question 3 of 10

1

Click on each orange point and write the correct answer.

Label the Cell References correctly

Explanation

Question 4 of 10

1

All formulas (and functions) start with...

Select one of the following:

+
=
*
A cell reference

Explanation

Question 5 of 10

1

Some of the important symbols in a spreadsheet are below. Drag and drop their meanings into place.

+ ❌
- ❌
* ❌
/ ❌

Drag and drop to complete the text.

add

multiply

divide

subtract

Explanation

Question 6 of 10

1

The symbol for the function menu ( or "Autosum" dropdown) looks like

Select one of the following:

Σ
M
+
=f(x)

Explanation

Question 7 of 10

1

The correct formula to add up the numbers in this spreadsheet is:

Select one of the following:

=add(A1:A5)
=A1+A2+A3+A4
=SUM(A1:A5)
=(A1:A5)

Explanation

Question 8 of 10

1

The correct formula to calculate the average of the numbers in this spreadsheet is:

Select one of the following:

=MEAN(A1:A5)
=AVERAGE(A1:A5)
=A1+A2+A3+A4+A5/5
=AVE(A1:A5)

Explanation

Question 9 of 10

1

Fill the blank spaces to complete the text.

A spreadsheet can create many types of or charts. Some of these include line graphs, (or "bar") charts and charts.

Explanation

Question 10 of 10

1

Formatting means...

Select one of the following:

Making a spreadsheet for some dude called Matt
Changing numbers to see what happens
Changing how the spreadsheet looks
Changing the words to describe what the numbers mean

	Created by Jon Rogers over 7 years ago

Quiz on Spreadsheets - Year 9 L1, created by Jon Rogers on 18/08/2017.

Spreadsheets - Year 9 L1

Question 1 of 10

Label the key sections of a spreadsheet by dragging and dropping the labels

Drag an answer into the correct orange point.

Explanation

Question 2 of 10

The correct cell reference for this cell is:

Select one of the following:

Explanation

Question 3 of 10

Click on each orange point and write the correct answer.

Label the Cell References correctly

Explanation

Question 4 of 10

All formulas (and functions) start with...

Select one of the following:

Explanation

Question 5 of 10

Some of the important symbols in a spreadsheet are below. Drag and drop their meanings into place. + ❌ - ❌ * ❌ / ❌

Drag and drop to complete the text.

Explanation

Question 6 of 10

The symbol for the function menu ( or "Autosum" dropdown) looks like

Select one of the following:

Explanation

Question 7 of 10

The correct formula to add up the numbers in this spreadsheet is:

Select one of the following:

Explanation

Question 8 of 10

The correct formula to calculate the average of the numbers in this spreadsheet is:

Select one of the following:

Explanation

Question 9 of 10

Fill the blank spaces to complete the text.

A spreadsheet can create many types of or charts. Some of these include line graphs, (or "bar") charts and charts.

Explanation

Question 10 of 10

Formatting means...

Select one of the following:

Explanation

Some of the important symbols in a spreadsheet are below. Drag and drop their meanings into place.

+ ❌
- ❌
* ❌
/ ❌