Question 1

D4 =B4*C4*E$2
E4 =B4*C4+D4
E15 =SUM(E4:E14)
H3 =E15
H6 =H3*H10
H7 =SUM(H3:H6)

Question 2

G4 =D4*D$2+E4*E$2+F4*F$2
D11 =AVERAGE(D4:D9)
D12 =MAX(D4:D9)
D13 =MIN(D4:D9)

Question 3

1 Highlight the cells from A2 to G8
2 Insert 2-D Column chart
3 Change Chart Title to S2 Computer Literacy
4 Change Horizontal and Vertical Axis Title to Class and Number of Students respectively
5 Show Legend at Right

Question 4

B7 =B$2*(1+B$3/B$4)^(A7*B$4)
C7 =B7-B2
C8 =B8-B7
C28 =SUM(C7:C26)

Question 5

B5 =B3
C5 =QUOTIENT(B5,2)
B6 =MOD(B5,2)

Question 6

B18 =$B3+$B4*(B14-1)+$B5*B15+$B6*B16
B19 =B13-B18
B20 =IF(B19<0,0,IF(B19<$D9,B19*$B9,$D9*$B9+(B19-$D9)*$B10))

Question 7

E4 =B4*C4*IF(D4="Y",1-B$1,1)
E9 =SUM(E4:E7)

Question 8

C2 =QUOTIENT(B2,5)+IF(MOD(B2,5)=0,0,1)
D2 =C2*5-B2