cell - unique unit/box in a sheet, cell address - a cell's column letter followed by it's row number, value - a number inside a cell which can be used in a calculation, title - text entered into a cell, to explain what the numbers refer to, =A10*C10 - example of a formula, function - a pre-existing command to carry out a specific calculation, eg find the biggest number, J6:J15 - example of a cell range, Fill Down - to copy the content of a cell down a column, Fill Across - to copy the content of a cell across a row, relative reference - a cell reference which changes to reflect its new position when filled down / across, absolute reference - a cell reference which stays the same when copied down / across, = B5 * $C$2 - $C$2 is an example of an absolute cell reference, =if(E6 > 59,"Pass","Fail") - example of a conditional function, a test is made in order to decide what to enter into the cell, >,<,=,>=,<= - examples of comparison operators,
0%
Spreadsheet Terms
Share
Share
Share
by
Ictdept1
Y9
Computing
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Match up
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
More formats will appear as you play the activity.
Open results
Copy link
QR code
Delete
Continue editing:
?
Ictdept1