Page 330 - TP_IT_V1.0_C9_flipbpookl
P. 330
b. Write the formulas to Calculate the total number of students in cell C9, the total number of students present in cell D9
and the total number of absentees in cell E9.
c. Write the formulas to calculate the percentage of students present in cell D10 and the percentage of students absent
in cell E10.
Ans. a. E3= C3-D3
Use the Auto Fill feature to copy this formula in the cells E4 to E8.
b. C9=sum(C3:C8)
D9=sum(D3:D8)
E9=sum(E3:E8)
c. D10=(D9/C9)*100
E10=(E9/C9)*100
2. Identify the output while doing the following calculations in a LibreOffice Calc.
a. If C2=200, C3=300, C4=150, C5=150 what will be the result of =average (C2: C5)?
b. If A2=35 what will be the result of A2 * 2?
c. If C4=200 and D4=2 then what will be the output of =C4 / D4 + 22?
Ans. a. 200 b. 70 c. 122
3. Consider the following spreadsheet and write functions/formulas to answer the following queries:
a. Cell D4 to display the total marks of theory and practical of Term 1.
b. Cell G4 to display the total marks of theory and practical of Term 2.
c. Cell H4 to display 40% of the total of Term 1.
d. Cell I4 to display 60% of the total of Term 2.
e. Cell J4 to display the sum of weightage of Term 1 and Term 2.
f. Cell B12 to display the highest scorer of Term 1 Theory.
g. Cell B13 to display the lowest scorer of Term 1 Theory.
Ans. a. D4 = B4 + C4, copy the formula for the rest of the students.
b. G4 = E4 + F4, copy the formula for the rest of the students.
c. H4 = D4 * H$3, copy the formula for the rest of the students.
d. I4 = G4 * I$3, copy the formula for the rest of the students.
328 Trackpad Information Technology (Ver. 1.0)-IX

