Page 293 - TP_IT_V1.0_C10_flipbpookl
P. 293
21 st
Century #Media Literacy
Skills
Video based question Scan the
QR Code
Watch the video and answer the question. https://www.youtube.com/watch?v=xCL9hgGePGA
What is cell reference in LibreOffice Calc?
21 st #Technology Literacy
LAB ACTIVITY Century #Critical Thinking
Skills
1. Create the following worksheet in LibreOffice 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
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.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 291

