Page 118 - IT-802_class_12
P. 118
9. Mr Tapas shares the computer in his office with other colleagues. He wants to make sure no one sees the financial data he
saves on the computer. What should he do?
i. Lock the computer in a cupboard
ii. Change the password of his computer so that no one can use it
iii. Apply a password to the financial data sheet
iv. Leave it as it is and hope that no one will open it
10. Which of the following is the correct step for printing a presentation?
i. FileÆPrint ii. FileÆPrintÆHandout
iii. FileÆPrintÆHandoutÆOK iv. FileÆOK
11. Mr Gupta 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 fast? What would Mr Gupta do? He will: [NCERT]
i. apply filter ii. sort the data
iii. use password iv. format data.
12. What do you need to install on your computer to be able to run Impress? [NCERT]
i. Google ii. Microsoft Office
iii. LibreOffice iv. Apple iOS
B. Fill in the blanks.
1. ............................... consists of an operand and the operators that operate upon the data.
2. Sorting is the process of arranging data in ............................... .
3. Presentation software is a tool used to create ............................... .
4. ............................... is a tool used to create visual presentations.
5. The............................... can be changed by using the Font Color button.
C. State whether the following statements are true or false:
1. Calc is the spreadsheet component of OpenOffice.org.
2. Status bar contains shortcut buttons for frequently used options.
3. We need to press and hold the Shift key to select multiple columns or rows that are not contiguous.
4. Functions are in-built formulas in ‘Calc’ that can be used to perform arithmetic and non-arithmetic tasks.
5. The text colour can be changed by using the Font Color button and selecting the colour of your choice.
Section B
(Subjective Type Questions)
A. Answer the following questions:
1. What is a spreadsheet? Give a few examples of spreadsheet software.
2. What is the difference between a cell and a cell address?
3. What is auto filter?
4. What is sorting?
5. What is ClipArt?
6. What are the different components in a spreadsheet?
7. Define relative referencing, mixed referencing, and absolute referencing.
8. How would you protect a spreadsheet with a password?
9. Explain some advanced features of digital presentation.
116 Touchpad Information Technology-XII

