Class 12 ICT Skills Questions and Answer
Unit 3: Information and Communication Technology Skills
Session 1: Getting Started with Spreadsheet
Multiple choice questions
1. A _____________ is an electronic document used to store data in a systematic way and perform calculations just like an expense sheet.
(a) spreadsheet
(b) worksheet
(c) workbook
(d) name box
Answer: (a) spreadsheet
2. Which of the following functions can be performed with the help of spreadsheets?
(1) Maintaining records
(2) Creating videos
(3) Analysing data
(4) Performing financial calculations
(5) Writing letters
(a) 1, 2, 3, 4, 5
(b) 1, 3, 4
(c) 1, 3, 5
(d) 3, 4, 5
Answer: (b) 1, 3, 4
3. Match the columns, and then, choose the correct answer.
- Grid of horizontal rows and vertical columns A. Row
- Horizontal arrangement of cells numbered 1, 2, 3, 4 B. Workbook
- Where rows and columns meet or intersect C. Columns
- Which contains one or more worksheets D. Cell
- Vertical arrangement of cells named A, B, C, D E. Worksheet
(a) 1-E, 2-A, 3-B, 4-D, 5-C
(b) 1-E, 2-B, 3-C, 4-D, 5-A
(c) 1-A, 2-B, 3-C, 4-D, 5-E
(d) 1-E, 2-A, 3-D, 4-B, 5-C
Answer: (d) 1-E, 2-A, 3-D, 4-B, 5-C
4. A _______ is an arrangement of cells in a horizontal manner.
(a) column
(b) row
(c) cell
(d) worksheet
Answer: (c) cell
Class 12 ICT Skills Questions and Answer
Session 2: Performing Basic Operations in a Spreadsheet
Multiple choice questions
1. The correct order of steps for entering data in a spreadsheet is:
(a) type the data, click the cell and press Enter.
(b) click the cell, type the data and press Enter.
(c) press Enter, click the cell and type the data.
(d) click the cell, press Enter and type the data.
Answer: (b) click the cell, type the data and press Enter.
2. What will you do to select an entire worksheet in a spreadsheet?
(a) Click the File tab and select properties from the list
(b) Click the grey row heading
(c) Click the grey rectangle in the upper left corner of the spreadsheet
(d) Click the grey column heading
Answer: (c) Click the grey rectangle in the upper left corner of the spreadsheet
Class 12 ICT Skills Questions and Answer
Session 3: Working with Data and Formatting Text
Multiple choice questions
1. What is the default alignment of numbers in a cell?
(a) Left aligned
(b) Right aligned
(c) Center aligned
(d) Randomly aligned
Answer: (b) Right aligned
2. “By default, the text in a cell is left aligned.” State whether this is true or false.
(a) True
(b) False
Answer: (a) True
3. What is the shortcut key to underline text in a spreadsheet?
(a) Ctrl+b
(b) Ctrl+i
(c) Ctrl+l
(d) Ctrl+u
Answer: (d) Ctrl+u
4. Which of the following features is used to perform addition in spreadsheets?
(a) Format option
(b) Charts
(c) Graphs
(d) Formula
Answer: (d) Formula
5. Which of the following signs define a formula?
(a) +
(b) /
(c) =
(d) +
Answer: (c) =
Class 12 ICT Skills Questions and Answer
Session 4: Advanced Features in Spreadsheet
Multiple choice questions
1. Which menu option will you use to sort data?
(a) Tools
(b) Data
(c) Format
(d) View
Answer: (b) Data
2. 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:
(a) apply filter
(b) sort the data
(c) use password
(d) format data
Answer: (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 the computer. 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
Answer: (c) Apply password to the financial data sheet
Class 12 ICT Skills Questions and Answer
Session 5: Presentation Software
Multiple choice 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?
(a) Chart paper
(b) Word document
(c) Presentation software
(d) Spreadsheet
Answer: (c) Presentation software
2. What do you need to install on your computer to be able to run Impress?
(a) Google
(b) Microsoft Office
(c) LibreOffice
(d) Apple iOS
Answer: (c) LibreOffice
3. How many textboxes does the first slide of LibreOffice Impress have by default?
(a) 1
(b) 2
(c) 3
(d) 4
Answer: (b) 2
Class 12 ICT Skills Questions and Answer
Session 6: Opening, Closing, Saving and Printing a Presentation
Multiple Choice Questions
1. Which is the correct step to save a presentation?
(a) File>Save As>Type file name>Save
(b) File>Open>File name>Open
(c) File>Template>Save as Template
(d) File>Close>Save>OK
Answer: (a) File>Save As>Type file name>Save
2. Which is the correct step to close a presentation?
(a) File>Save As>Type file name>Save
(b) File>Exit
(c) File>Close
(d) File>Export
Answer: (c) File>Close
3. Which is the correct step for printing a presentation?
(a) File>Print
(b) File>Print>Handout
(c) File>Print>Handout>OK
(d) File>OK
Answer: (c) File>Print>Handout>OK
Class 12 ICT Skills Questions and Answer
Session 7: Working with Slides and Text in a Presentation
Multiple choice questions
1. Which menu option do you use to insert a slide?
(a) Edit
(b) Insert
(c) Slide
(d) Tools
Answer: (c) Slide
2. How will you, usually, align the title of a slide?
(a) Left
(b) Right
(c) Center
(d) Justify
Answer: (c) Center
3. Which option will you use to change the colour of the text?
(a) Font Color
(b) Font
(c) Highlight Color
(d) Format
Answer: (a) Font Color
Class 12 ICT Skills Questions and Answer
Session 8: Advanced Features used in Presentation
Multiple choice questions
1. Which menu option will you click on to insert shapes and images?
(a) Format
(b) Tools
(c) Edit
(d) Insert
Answer: (d) Insert
2. What are the steps to insert a square shape in a presentation?
(a) Insert > Shape> Line> Square
(b) Tools > Shape> Line> Square
(c) Insert > Shape> Basic > Square
(d) Format > Text > Basic> Square
Answer: (c) Insert > Shape> Basic > Square
3. What happens when you change the layout of a slide?
(a) The format of the text changes
(b) New slide is inserted
(c) The arrangement of content (text, images, shapes) changes
(d) The title gets aligned to the center of the slide
Answer: (c) The arrangement of content (text, images, shapes) changes