1.11 - Spreadsheets (WJEC)

HideShow resource information
  • Created by: daynayume
  • Created on: 17-05-16 18:36
Why are Spreadsheets used?
To perform calculations using a computer.
1 of 20
What are Labels?
Headings explaining the data.
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?
More advanced calculations.
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
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.
20 of 20

Other cards in this set

Card 2

Front

What are Labels?

Back

Headings explaining the data.

Card 3

Front

What is Data?

Back

Preview of the front of card 3

Card 4

Front

What are formulas?

Back

Preview of the front of card 4

Card 5

Front

What does this formula do: =A1+B1?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »