spreadsheets x Flashcards
what is a column?
columns are boxes in a vertical line and are labelled with letters
what is a row
rows are boxes in a horizontal line. rows are labelled with numbers
what is a cell?
a cell is an individual box with an unique cell reference.
what does each box have?
it’s own special address
e.g. E4 which means it’s in the 5th column (E) and the fourth row (4)
what can cells hold?
information
e.g. you can type numbers, words or anything
what is a label
a piece of text that you add to a spreadsheet to help describe the numbers
what is a value?
a number that you type into a spreadsheet. it is a number that you already know
what does every formula start with?
an equals sign
what is the formula for adding 2 cells up?
=A1+B1
what is the formula for subtracting 2 cells?
=A1-B1
what is the formula for multiplying 2 cells together
=A1*B1
what is the formula for dividing 2 cells?
=A1/B1
what are functions?
predefined operations
what do formulas use?
functions
what functions add up all the numbers from A1 to A5
=SUM (AI:A5)
