# Unit 3 Class 12 ICT Skills Questions and Answer

## 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.

(b) worksheet

(c) workbook

(d) name box

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

3. Match the columns, and then, choose the correct answer.

1. Grid of horizontal rows and vertical columns A. Row
2. Horizontal arrangement of cells numbered 1, 2, 3, 4 B. Workbook
3. Where rows and columns meet or intersect C. Columns
4. Which contains one or more worksheets D. Cell
5. 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

## 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

2. “By default, the text in a cell is left aligned.” State whether this is true or false.

(a) True

(b) False

3. What is the shortcut key to underline text in a spreadsheet?

(a) Ctrl+b

(b) Ctrl+i

(c) Ctrl+l

(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

5. Which of the following signs define a formula?

(a) +

(b) /

(c) =

(d) +

## Class 12 ICT Skills Questions and Answer

Multiple choice questions

1. Which menu option will you use to sort data?

(a) Tools

(b) Data

(c) Format

(d) View

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

(d) format 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

## 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

2. What do you need to install on your computer to be able to run Impress?

(b) Microsoft Office

(c) LibreOffice

(d) Apple iOS

3. How many textboxes does the first slide of LibreOffice Impress have by default?

(a) 1

(b) 2

(c) 3

(d) 4

## 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

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

## 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

2. How will you, usually, align the title of a slide?

(a) Left

(b) Right

(c) Center

(d) Justify

3. Which option will you use to change the colour of the text?

(a) Font Color

(b) Font

(c) Highlight Color

(d) Format

## 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

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