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
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Match up
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?