HideShow resource information
• Created by: daynayume
• Created on: 17-05-16 18:36
To perform calculations using a computer.
1 of 20
What are Labels?
2 of 20
What is Data?
The text or numbers that you type in.
3 of 20
What are formulas?
Automatic Calculations.
4 of 20
What does this formula do: =A1+B1?
Adds up cells A1 and B1.
5 of 20
What does this formula do: =A2-B2?
Takes away B2 from A2.
6 of 20
What does this formula do: =A3*B3?
Multiplies A3 by B3.
7 of 20
What does this formula do: =A4/B4?
Divides A4 by B4.
8 of 20
What are functions?
9 of 20
What does this function do: =SUM(A1:E1)?
Adds up cells A1, E1 and everything in between.
10 of 20
What does this function do: =AVERAGE(A1:E1)?
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
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.
20 of 20

## Other cards in this set

What are Labels?

What is Data?

### Card 4

#### Front

What are formulas?

### Card 5

#### Front

What does this formula do: =A1+B1?