Finds the average of cells A1, E1 and everything in between.
11 of 20
What does this function do: =IF(A1>49,'Pass","Fail")?
IF functions make decisions. If the test score is larger than 49, the result of Pass will be displayed. Otherwise, Fail will be displayed.
12 of 20
What does this function do: =MIN(A1:E1)?
Finds the smallest number in the range of cells A1 to E1.
13 of 20
What does this function do: =MAX(A1:E1)?
Finds the largest number in the range of cells A1 to E1.
14 of 20
What formatting techniques can be used to improve a spreadsheet?
Coloured borders, Formatting data types, Merged cells, Font, Background Fill.
15 of 20
What happens when you Replicate a formula down a spreadsheet?
The cells in the formula will change depending on what row the formula is in.
16 of 20
What is it called when you replicate a formula down a spreadsheet?
Relative Cell Reference.
17 of 20
How can we stop Relative Cell Reference happening?
Place dollar sigs before each letter and number of the cell reference.
18 of 20
What is it called when we stop Relative Cell Reference happening?
Absolute Cell Referencing.
19 of 20
Benefits of using spreadsheets?
When data changes, formulas automatically recalculate. Computers do not make mathematical errors. Chart and graphs can be produced easily. You can change information in a spreadsheet model to make and test predictions.
Comments
No comments have yet been made