Page 262 - Trackpad 402_Class-X_Final
P. 262
a. To calculate AMOUNT with the help of corresponding RENT and DURATION as RENT*DURATION to be written in E2.
b. To calculate TAX as 10% of corresponding AMOUNT to be written in F2.
c. To calculate BILLAMOUNT as total of corresponding AMOUNT and TAX to be written in G2.
d. To find highest RENT from the column B to be written in B8.
e. To count the number of rooms occupied from the column C to be written in C8.
24. Arguments passed to a macro from Calc are always . [2022]
a. Strings b. References
c. Numbers d. Values
25. List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet. [2020]
26. What could you do to add an absolute reference? [2016]
a. Add dollar signs around the cell b. Click F4
c. Both (a) and (b) d. None of the above
27. What is conditional formatting? Explain “sort” and “filter” features available in spreadsheet. [2017]
21 st #Leadership & Responsibility
LAB ACTIVITY Century #Creativity
Skills
1. Create the following worksheet in OpenOffice Calc and display the sum of items according to items and
then city.
2. Enter the following data into the worksheet and compute the strike rate of the batsman:
Runs Scored 67
Balls Faced 78
Strike Rate 85.90
End of document Ctrl + Shift + End
Now find out the strike rate on the basis of the following records:
i. When score is 45 and balls faced are 30.
ii. When score is 40 and balls faced are 90.
iii. When score is 89 and balls faced are 100.
3. Create the following worksheet in Calc:
English Hindi Maths
Test 1 17 16 17
Test 2 15 16 18
Test 3
Use the goal seek feature to predict how much marks should the student score in Test 3 to get 88% marks
in total.
262 Trackpad Information Technology-X

