Index
Spreadsheet Gaps Exercise
Spreadsheet Matching Exercise
Matching exercise
Match the items on the right to the items on the left.
Check
The name of the spreadsheet application you have been using
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This is used to carry out basic calculations
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This is an example of a cell reference
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This stops data in cells from getting changed accidentally
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This is used to perform a calculation on many cells
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This would find the average number between cells A1 and A10
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
Information could be shown on this to make it more understandable
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
When this is option is selected, the information is calculated only when the user tells it to
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This is an example of absolute replication
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
This adds up all the numbers between cells F5 and F12
???
F4
Chart
=SUM(F5:F12)
=AVERAGE(A1:A10)
Formula
Manual Calculation
Excel
$B$9
Cell Protection
Function
Check
OK
Index
Spreadsheet Gaps Exercise