Year 7 & 8 PRACTICAL .xlsx

	A	B	C	D	G	H	I	J	S	T	U	V	Y	Z	AB	AC	AJ	AK	AL	AM	AN	AO	AP	AS	AT	AU	AV	AW	BB	BC	BD
1	Task 1: Simple Formulas				Task 2: Functions & Creating a Graph				Task 3: Absolute Cell Referencing (Locking a Cell)				Task 4: Count Functions				Task 5: IF Statements							Task 6: SumIF & IF Statements					Task 7: SumIF
2	Task 1: Simple Formulas				Task 2: Functions & Creating a Graph				Task 3: Absolute Cell Referencing (Locking a Cell)				Task 4: Count Functions				Task 5: IF Statements							Task 6: SumIF & IF Statements					Task 7: SumIF
3
4	6	+	54	60	Colours	Students					10%		Numbers		Mobile Brands			Manchester		Sales Target Met: Yes/NO	London		Sales Target Met: Yes/NO	Student Names	House	Year	Marks	Fail <50, Pass>=50	Apps	Category	Total Sales
5	5	x	10		Red	26					Student Discount	New Student Price	The Range	1	The Range	Apple	Phone Name	Sales	Target	Sales Target Met: Yes/NO	Sales	Target	Sales Target Met: Yes/NO	Abdulla	East	7	23		Minecraft – Pocket Edition	Games	5
6	100	/	2		Blue	18			Mobile Phone	Price	Student Discount	New Student Price		3		Apple	Sony Xperia	105	67		95	75		Ahmed	East	8	54		Goblin Sword	Games	45
7	200	-	125		Green	25			Sony Xperia M	£ 119.95				1		Samsung	Samsung s5	85	125		75	75		Claudia	East	7	64		Sleep Cycle alarm clock	Health	64
8	10	+	58		Purple	6			Nokia Lumia 1320	£ 229.45				4		Sony	Samsung s5 mini	23	85		34	35		James	South	8	34		Afterlight	Photo & Video	4
9	20	/	5		Other	7			HTC One	£ 360.59				4		Apple	Apple I Phone 5	125	140		43	65		Mustafa	East	7	66		7 Minute Workout Challenge	Health	75
10	45	-	10						Samsung Galaxy S4	£ 439.95						Blackberry	HTC ONE	23	50		54	25		Sarah	West	8	53		Videoshop	Photo & Video	35
11	55	+	22						Apple iPhone 5c	£ 539.99						Sony	Apple I Phone 4	126	100		72	75		Zaid	East	9	87
12	5	x	2											34		Apple								Zara	South	9	65		Count
13																Apple	Employee Name	Hours Worked	Full Time/Part Time							Max			Count All Apps
14						Phone Sales										Samsung	Ahmad	40								Min			Games
15					Phone Brands	January	February	March								HTC	Sarah	37								Average			Health
16					Apple	15	15	30								Sony	Mohammad	20								Total
17					Samsung	18	18	5									Saif	35											Sumif Total Sales
18					Sony	5	5	9					Count Numbers		Count All Phones		Shahad	35							SumIf			SumIf	Games
19					Other	6	2	30					Highest	4	Apple										North			7	Health
20					Total:								Lowest	1	Samsung										South			8	Photo & Video
21					Highest (Max):								Average	2.6	HTC										West			9
22					Lowest (Min):								Total	13	Sony										East
23					Average:
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100