Inside Story

Class 12 Information Technology Sample paper :2021-22

This Sample Paper based on the latest pattern of , it sample paper class 12. Solve this quiz to test your knowledge. Best of luck champs!

Best of luck! Let's begin...

Information Technology sample paper MCQs test, CBSE Class 12 Term 1: 2021-22

IT Class 12 Sample paper MCQs

GENERAL INSTRUCTIONS
* Please read the instructions carefully.
* This Question Paper is divided into 03 sections, viz., Section A, Section B, and Section C.
» Section A is of 05 marks and has 06 questions on Employability Skills.
* Section B is of 15 marks and has 20 questions on Subject Specific Skills.
* Section C is of 05 marks and has 07 competency-based questions.
* Do as per the instructions given in the respective sections.
* Marks allotted are mentioned against each section.
* All questions must be attempted in the correct order.

1 / 32

SECTION-A

Employability Skills

Answer any 5 questions out of the given 6 questions (1 x 5 = 5 marks)

1. In the ..................... process, words or non-verbal means are utilized to translate the thought into a message

a) decoding

b) encoding

c) feedback

d) visual communication

2 / 32

2. ............. barrier in communication occurs when people are unable tounderstand each other's customs and traditions, resulting in inconveniences and difficulties.

a) Cultural

b) Intrapersonal

c) Interpersonal

d) Organizational

3 / 32

3. .............. means to stay updated on the best practices and be ready for new changes, so that transitions can happen seamlessly.

a) Time management

b) Adaptability

c) Responsibility

d) Self-awareness

4 / 32

4. By managing ......................, you can deal with daily pressures and triggers, and meet challenges head-on.

a) routine

b) time

c) stress

d) work-life balance

5 / 32

5. The machinery of a computer which includes keyboard, monitor, CPU, etc., is known as

a) Operating System

b) Software

c) Hardware

d) Hard disk

6 / 32

6. ................. includes using or distributing unlicensed and unauthorized copies of a computer program

software.

a) Trojan Horse

b) Online scam

c) Identity theft

d) SOftware Piracy

7 / 32

SECTION -B

KNOWLEDGE BASED QUESTIONS

A/AN ................ is a set of formats that you can apply to selected pages, text, frames and other elements in your document.

a) Style

b) Template

c) Image

d) Format

8 / 32

8. In setting up subtotals in the subtotal dialog box, which option in not avialable in the use fu

nction box?

a) Sum

b) stD-evp

c) VarP

d) Percentage

9 / 32

9. A database is an organized collection of

a) data

b) attributes

c) records

d) None of the above

10 / 32

10. Wh ich of these styles includes header and footer, border and margins ?

a) Character Style

b) page Style

c) Frame style

d) Presentation Style

11 / 32

11. By adding a scenario, we can quickly change the .................. of a formula and view the new results.

a) results

b) arguments

c) variables

d) data

12 / 32

12. Which of the following is not a database program ?

a) MySQL

b) Oracle

c) Writer

d) LibreOffice Base

13 / 32

13. Which of these options ca n be used to apply font size, bold and italics format etc., to the selected text?

a) Graphics Styles

b) Numbering Styles

c) Page Styles

d) Character Styles

14 / 32

14. In OpenOffice.org Calc, we ca nnot consolidate data by...............

a) Row Label

b) column label

c) linking the label

d) none of the above

15 / 32

15. .............. stores data in single table.

a) Flat File

b) Relational

c) single file

d) one file

16 / 32

16. What is the shortcut for opening styles and formatting window?

a) F9

b) F10

c) F11

d) F12

17 / 32

17. Duplication of data is called ...........

a) Inconsistency

b) Consistency

c) Redundancy

d) Foreign Key

18 / 32

18. ...............are dedicated computers that hold the actual databases, and run on ly DBMS and related Software.

a) MainServers

b) Web Servers

c) Database Servers

d) None of these

19 / 32

19. ............... is used to apply a style to many different areas quickly without having to go back to the Styles and Formatting window, and double-click every time.

a) Format Mode

b) FillM0de

c) Fill Style Mode

d) Fill Format Mode

20 / 32

20. Which option in the Options tab of Subtotal is deselected to deactivate Sort tab?

a) page break between groups

b) case sensitive

c) pre-sort area according to groups

d) custom sort order

21 / 32

21.

GUl acts as front end and database server acts as........

a) Container

b) Backend

c) End

d) None ofthe above

22 / 32

22. We can create style by :

a) New style form a selection

b) Dragging and Dropping

c) Both of the above

d) None of the above

23 / 32

23.

 Which option is not available in the Settings option of Create scenario dialog box?

a) Comment

b) Display border

c) Copy back

d) copy entire sheet

24 / 32

24.

 Which function key is used to edit a formula in Excel?

a) F1

b) F2

c) F3

d) F4

25 / 32

25.

We can also modify the predefined styles -True or False?

a) True

b) False

c) maybe

d) none of these

26 / 32

26.

What does + sign indicate in this section of spreadsheet?

a) Will not insert any sheet but open the Insert Sheet dialog box

b) Insert a new sheet and open the Insert Sheet dialog box

c) Insert a new sheet without opening the Insert Sheet dialog box

d) None of the above

27 / 32

27.

SECTION-C

Competency Based Questions

Answer any 5 questions out of the given 6 questions(1 x 5 = 5 marks)

Study the table given below and answer the following:

Sonam's monthly budget
water	348
cable	250
Car Installment	2,500
Insurance	1,000
Rent	4,000
Gas	500
Power	2,500
Groceries	1,500
Entertainment	890
cinema	1,400
Outdoor Eating	1,890
Club membership	1,500
Total Amount	18,278

After working out her budget, Sonam realizes that total expenses, i.e. = 18,278 ismuch more than her income, i.e. = 12850. She wants to modify her budget byreducing all her non-essential budget items. Which analytical tool can she use toachieve this?

a) She should use Goal Seek to change her total expenses by modifying the selected cells which contain non-essential items.

b) Data tables will allow her to change all the amounts to fit in with her income.

c) She should use Solver to change her total expenses by editing all the cells which contain non-essential items.

d) She should use the PMT function to calculate her monthly budget payments and exclude non-essential items.

28 / 32

28.

Global Artwork Ltd. did its maximum sales of art books and notebooks in themonth of April and wanted to highlight the worksheet tab for that month with redcolour. How can they make their worksheet tab look red?

a) Double-click the April tab and select red from the ribbon

b) Right-click the April tab, click Tab Color, and then select red

c) Open the Worksheet Tab Color Wizard

d) None of the above

29 / 32

29.

Raman is working on a photo album and is using picture toolbar. He wants toknow what does the percentage value in the given box signify?

a) Burnt effect

b) Transparency effect

c) Dodge effect

d) Aging effect

30 / 32

30.

Rehman wants to write a blog for his trip to Himalayan Ranges. He has clickedsome pictures as well which should come along with the write up. Which featureisthe most suited to achieve this?

a) Shapes

b) Themes

c) Text wrapping

d) Graphic filters

31 / 32

31.

Databases available on the database servers are accessed through command lineor graphic user interface tools referred to as ........; database servers arereferred to as .......... Such type of data access is referred to as a.........

a) Frontends, Back-ends, client-server model

b) Back-ends, Frontends, client-servermodel

c) Frontends, Back-ends, Peer to Peer model

d) Back-ends, Frontends, Peer to Peer model

32 / 32

32.

Given below are the two files maintained by the Admin and the Academicsdepartment separately, for keeping records of their students. Which of thefollowing problem occursin the records?

file1 it sample paper class 12