Spreadsheets - Year 9 L1

Question 1 of 10

1

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

Select correct option below corresponding to the highlighted 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.

+ ❌
- ❌
* ❌
/ ❌

Select option below to complete the highlighted 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

	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

Select correct option below corresponding to the highlighted 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. + ❌ - ❌ * ❌ / ❌

Select option below to complete the highlighted 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.

+ ❌
- ❌
* ❌
/ ❌