Page 117 - IT-802_class_12
P. 117
interdisciplinary
B. Competency-based/Application-based questions:
1. You have a summer vacation project on how to make biogas. You have done a lot of research, clicked pictures of biogas
plants and taken videos of people who use biogas. Now, you have to make a presentation before the class. What would you
use? Subject Enrichment
Ans. OpenOffice Impress
2. Mr Tapas has a spreadsheet with a list of 500 items in his shop. A customer comes and asks for a particular item. How should
he arrange the data so that he can find that item quickly? What would Mr Tapas do?
Ans. He can use sorting feature to arrange the data alphabetically.
Unsolved Exercise
Section A
(Objective Type Questions)
A. Choose the correct option.
1. Which of the following is a type of spreadsheet?
i. Microsoft Excel ii. LibreOffice Calc
iii. Google Sheets iv. All of the above
2. A ............................... software makes our work more expressive and presentable?
i. Presentation ii. Workbook
iii. Notebook iv. None of these
3. You can also use the keyboard to select the entire sheet by pressing ............................... .
i. Ctrl + C ii. Ctrl + V
iii. Ctrl + A iv. Ctrl + Z
4. The extension of Spreadsheet (OpenOffice) is ................................
i. .xls ii. .ods
iii. .txt iv. All of the above
5. What would you do to select an entire worksheet in a spreadsheet?
i. Click on the File tab and select Properties from the list
ii. Click on the grey row heading
iii. Click on the grey rectangle in the upper left corner of the spreadsheet
iv. Click on the grey column heading
6. Ms Kaushiki is the class teacher of Std XII and has just started using a computer spreadsheet instead of her manual marks
register. She has entered the marks of her students in various subjects in a spreadsheet. Now, she wants to find out the total
marks for each student. What should she do?
i. She can use the Sum function ii. She can use + operator
iii. Both (i) and (ii) iv. None of these
7. What is the default alignment of numbers in a cell?
i. Left aligned ii. Right aligned
iii. Center aligned iv. Randomly aligned
8. Ms Kusum is sharing the computer with other teachers and staff. She may want to protect her data. She may not
want anyone else to look at and make changes to her work. She can do this by protecting her spreadsheet using
a ................................
i. password ii. track changes
iii. read only iv. None of these
ICT Skills-IV 115

