Session 4: Advanced Features in Spreadsheet
Unit 3: Information and Communication Technology Skills
Textual Question-Answers
Check Your Progress
A. Multiple choice questions
1. Which menu option will you use to sort data?
(a) Tools
(b) Data
(c) Format
(d) View
Ans: (b) Data
2. Mr Gupta has a spreadsheet with a list of 500 items in his shop. Acustomer comes and asks for a particular item. How should he arrangethe data so that he can find that item fast? What would Mr Gupta do? He will:
(a) apply filter.
(b) sort the data.
(c) use password.
(d) format data.
Ans: (b) sort the data.
3. Mr Verma shares the computer in his office with other colleagues.
He wants to make sure no one sees the financial data he saves on thecomputer. What should he do?
(a) Lock the computer in a cupboard
(b) Change the password of his computer so that no one can use it
(c) Apply password to the financial data sheet
(d) Leave it as it is and hope that no one will open it
Ans: (c) Apply password to the financial data sheet
