Spreadsheet Exercises Solutions

---

Exercise 1 solution

---

Exercise 2 solution

---

Exercise 3 solution

---

Exercise 4 solution

B2 should contain the formula =B$1*$A2

---

Exercise 5 solution

---

Exercise 6 Solution

---

Exercise 7 Solution

7.1 7.567
7.2 7
7.3 7.57
7.4 =Round(-34.5632,1)
7.5 4
7.6 8
7.7 =Sqrt(234)
7.8 =RAND()
7.9 =Rand()*10
7.10 =Int(Rand()*10)+1
7.11 =Rand()*7+3

---

Exercise 8 STATISTICAL FUNCTIONS

8.1 8 18 4
8.2 15.33 81 3
8.3 Use average(range), max(range) and min(range) functions.
8.4 Use the Sum(range)
8.5 Use the Count(range) function.

---

Exercise 9 If Statement Solutions

9.1 Cell C5 should contain the function
=if(A1<=100,100,300)

9.2 Cell C5 should contain the function
=if(A1<100,100,if(A1=100,200,300))

9.3 Cell C5 should contain the function

=if(A1>1000,400,if(A1>100,300,if(A1=100,200,100)))

9.4 Cell C4 should contain the function

=if(and(A4>0,B4>0),100,0)

9.5 Below is part of row 5 showing suitable formula

	F	G	H
Row 5	=IF(D5=1,E5," ")	=IF(D5=2,E5," ")	=IF(D5=3,E5," ")

---

Exercise 9 Lookups

9.6 Exercise 3 as a LOOKUP table.

Cell C5 contains the simpler function =Vlookup(A1,A3:B7,2)

---