NSQF IT /ITeS SSLC LEVEL 2 karnataka MCQ-old question paper MCQ with answers

 

Four Alternatives are given for each of the following question incomplete statement. Choose the correct alternative and write the complete answer along with its question number and alphabet

1. The impairment such as low-vision, complete or partial blindness and colour blindness is called

    A) Hearing Impairment  B) Visual Impairment

    C) Motor Impairment      D) Cognitive Impairment

2.  Accessibility option are available under

A) Documents                   B) All Programs

C) Help & Support            D) Control Panel

3. Paragraph group is available under this tab.

A) Insert tab                C) Review Tab

B) Page Layout tab      D) Home Tab

 4. These are text or images included at the top of the page

A) Footers B) Headers C) Shortcuts D) Graph

5. It is a sample fill-in-the blank document

A) Style   B) Graph   C) clip-art   D) Template

6. Autosum is available under this group

A) Cells  B) Editing  C) Styles  D) Alignments 

 7. This feature allows to change the formatting of the cell based on the

    (A) Conditional Formatting      (B) Freeze Panes

    (C) Unconditional Formatting  (D) Sort & filter 

8. Sticky key is available in this tab

    (A)   Keyboard   (B) Sound   (C) Display   (D) Mouse

9. Observe the analogy and write the answer Filter keys : Keyboard :: Mouse Keys : ..............

(A) Sound tab          (B) General tab  

(C) Mouse tab          (D) Display tab

10. The default tab stop position value is

(A) 0·5^||  (B) 1·2^||  (C) 1·8^||  (D) 2·5^||

11. Header is available under this tab

(A) Home tab       (B) Page layout tab   

(C) Review tab     (D) Insert tab

12. File extension of word processing document is

(A) .pptx    (B) .docx    (C) .xlsx    (D) .jpeg

13. Conditional formatting is available under this

(A) Formula (B) Zoom (C) Insert (D) Home

14. Freeze panes are available under this tab

(A) Style (B) Cells (C) View (D) Review

15. All the computers which have equal status are called

 (A) Client Server     (B) Peer to Peer

 (C) www                  (D) LAN

16. It is a type of computer network which connects limited geographical area.

(A) LAN   (B) MAN   (C) WAN   (D) CAN

17. In insert tab, footer option is available under the group

(A) Text                             (B) Symbol 

(C) Header & Footer       (D) Link

18. File extension of template document is

(A) .pptx     (B) .docx     (C) .xlsx     (D) .pdf

19. Clip art option is available under the group

 (A) Illustration  (B) Equation  (C) Symbol  (D) Text

20. Format ( hide/unhide ) option is available under the group

(A) Font   (B) Style   (C) Cells   (D) Clip board

21. By selecting this feature we can freeze the entire row or column.

 (A) Freeze top row            (B) Freeze panes

 (C) Freeze first column     (D) Freeze last column

22. Page breaks option is available in this tab

(A) Mailing             (B) References   

(C) Page Layout     (D) Page header

23. The new template option is available in

(A) Start button      (B) Office button 

(C) Open button     (D) Task button

24. The Formula which is used to add two numbers in spread sheet is

(A) Sum ( a, b )              (B) = Sum ( a, b ) 

(C) = Sum ( a + b )         (D) = Sum a, b

25. In presentation grouping option helps to

(A) cut, paste, move        (B) move, rotate, resize 

(C) move, paste, undo     (D) paste, undo, cut

26. The view that is not supported by calendaring software is

 (A) Day   (B) Week    (C) Hour   (D) Month

26. The correct way to open meeting request window is

(A) Go to Start → new → meeting request

 (B) Go to Insert → meeting request

(C) Go to File → new → meeting request

(D) Go to Format → meeting request

27. The select statement used to retrieve all the columns in a table is

 (A) Select * from tablename;   

(B) Select from tablename;

(C) Select where tablename;

(D) Select orderby tablename;

28. Full screen option is available under this tab

(A) Home tab      (B) Insert tab 

(C) View tab        (D) Page Layout tab

29. Chart option that is NOT available in chart group is

(A) Link chart    (B) Pie chart 

(C) Bar chart      (D) XY (Scatter) chart

30. File extension of presentation document is

(A) .pptx   (B) .docx   (C) .pdf   (D) .xlsx

31. The option used to present the presentation for audience is

(A) Custom show          (B) Slide show 

(C) Presentation show    (D) Full show

32. Identify the wrap text option

 (A) Round   (B) Square   (C) Expand   (D) Rewrite

33. Share workbook option is available under

(A) Window group in view tab 

(B) Changes group in data tab

(C) Changes group in review tab 

(D) Window group in data tab.

34. The option available under wrap text is

(A) square (B) arrow (C) circle (D) triangle

35. The group of charts that include cylinder, cone and pyramid subtypes is

(A) Bar chart, Pie chart 

(B) Bar chart, Column chart

(C) Pie chart, Column chart 

(D) Area chart, Line chart

36. The actions that can be performed by an user are called

(A) notes             (B) appointments 

(C) journals         (D) tasks

37. With reference to database

 INSERT statement :Insertion of new information :: SELECT  statement :…….

(A) retrieval of information

 (B) modification of information

(C) deletion of information 

(D) specifying of information

38. An option available under Editing group of Home tab in a spreadsheet is

(A) Format                 (B) Autosum 

(C) Freeze panes        (D) Page layout

39. The option to be clicked to get two additional options while accepting a meeting request is

(A) Accept                           (B) Decline 

(C) Propose New Time      (D) Tentative

40. The accessibility function which is designed for people who have vision impairment is

(A) Filter keys    (B) Toggle keys 

(C) Sticky keys   (D) Mouse keys

41. The first character in the first word of the selected sentence will be converted to capital letter by selecting

(A) Lower case         (B) Upper case 

(C) Sentence case      (D) Toggle case

42. “ABC company”. This line has to be inserted at the top of each page of a document. The option for this is available under the group

(A) Illustrations     (B) Header & Footer

 (C) Symbols          (D) Paragraphs

43. Conditional formatting can not control

(A) font size             (B) font colour 

(C) border colour     (D) number format

44. The option available under “Arrange windows” dialog box while opening multiple windows in a spreadsheet is

(A) Horizontal     (B) Square 

(C) Tight             (D) Through

45. A table can be inserted into a presentation using

(A) Design option                     (B) Chart option

(C) Title and content option      (D) Group option

46. A table can be inserted into a presentation using

(A) Design option                 (B) Chart option 

(C) Title and content option  (D) Group option

47. The major difference between LAN and WAN is in terms of

(A) scanner   (B) area  (C) speed   (D) printer

48. Wrap text option is available under the tab

(A) insert   (B) home   (C) review   (D) format

49. The option used to make the workbook cover the entire screen is

 (A) page layout     (B) full screen 

(C) custom             (D) page break preview

50. With reference to charts Line chart : relationship of changes in data over a period of time :: Area chart : ………………. .

        (A) correlation among data points 

        (B) variation over a period of time

        (C) relative importance of values over time

        (D) comparison between items at fixed point of time

51. Three views provided by calendar software are

(A) Day, fortnight, month 

(B) Week, month, year

(C) Day, week, month 

(D) Day, week, fortnight

52. The where clause of SELECT statement specifies

(A) Which columns to retrieve

(B) An order in which columns should be returned

(C) Which rows to retrieve

(D) An order in which rows should be returned

53. The tab to be used to insert a movie clip to a presentation using Title and content option is

(A) Insert    (B) Home    (C) Format    (D) Design

54. In a worksheet, page break preview is available under

 (A) View Tab — workbook views group

(B) View Tab — page setup group

C) Home Tab — Cells group

(D) Home Tab — Workbook group

55. Switch windows option helps you to

(A) Switch off windows operating system

(B) Move from one workbook to the other

 (C) Switch on windows operating system

(D) Merge one workbook with the other

56. If the presentation is to be made to an audience, the option to be used is

(A) Browsed by an individual ( window )

(B) Presented by a speaker ( full screen )

(C) Setup slideshow

(D) Browser at a kiosk ( full screen )

57. In a digital presentation, for grouping of objects like pictures, clip art, shapes and text Box, the tab to be used is

(A) Design    (B) Insert    (C) Format    (D) Home

58. Tasks do not include the following Action Item

(A) Booking ticket

(B) Booking a conference room

(C) Reminder for completing work

(D) List of grocery items

59. With reference to the database Columns : Fields :: Rows : ………………. .

(A) Records        (B) Views

 (C) Tables           (D) Groups

60. Identify a DBMS in the following

(A) Microsoft Access

(B) Microsoft PowerPoint

(C) Microsoft Excel

(D) Microsoft Windows

61. The type of file used to store data in a single table is

A) Relational File             B) Heap File        

C) Flat File                      D) Hash File

62. Data type that is NOT available in data time data type is

            A) Date               B) Time   

            C) Timestamp     D) Binary date

IT -ENGLISH MCQ

1.    Observe the following analogy and write the answer : Bengaluru : Noun :: Walking : ………………… .

(A) Pronoun (B) Adjective (C) Conjunction (D) Verb

2. Come to shop .................. 5 p.m.

(A)   in     (B) at     (C) for     (D) on

 3. First Course in a meal is called

                A) Starter                 B) desert     

          C) Main course        D) beverage

4. Choose the correct sentence

A) I will not fighting     B) I will not fight 

C) I does not fight         D) I don’t fighting

5. Observe the analogy and write the answer. Past tense: visited :: Present tense: _______

a) Visit          b) Visiting     c) Visits    d) Visitors

6. Park your car ................. the parking lot behind the mall.

(A)    in     (B) for     (C) on     (D) is.

7. Resume includes

(A) phone bill        (B) phone number 

(C) friend name     (D) shop size.

8. Observe the analogy and write the answer : Ready : adjective : : Readily :

            (A)   noun                 (B) pronoun 

            (C) conjunction       (D) adverb.

9. Identify the future continuous tense of the sentence “I contacted my broker Vikram”.

(A) I am contacting my broker Vikram

(B) I will be contacting my broker Vikram

(C) I should contact my broker Vikram

(D) I will contact my broker Vikram.

 10. Kiran Lal Grocery is next to the mobile shop. The meaning of the underlined words is    

            (A)   beside     (B) opposite 

            (C) across     (D) in front of.

11. The point at which a road divides into branches is called

            (A)   intersection     (B) junction 

            (C) crossroad         (D) fork

12. Identify the sentence that is in simple past tense

(A) Rekha is taking pictures of the palace

(B) Rekha will be taking pictures of the palace

(C) Rekha was taken pictures of the palace

(D) Rekha took pictures of the palace

13. One of the examples for Dessert is

(A)   Fried rice      (C) Fruit salad with ice cream

       (B) Rumali roti    (D) Gobi Manchurian

14. Identify the passive voice of the sentence "Hariprasad had to revise the Question paper"

  (A) The Question paper had to be revised by Hariprasad

  (B) The Question paper has to be revised by Hariprasad

  (C) The Question paper have to be revised by Hariprasad

  (D) The Question paper is to be revised by Hariprasad

15. "I am ready to climb the Himalaya mountains". The underlined word in the above sentence is a/an

            (A)   Adverb     (B) Adjective 

            (C) Pronoun     (D) Noun

 16. Identify the modal in the sentence given below : "May I help you" ?

            (A)   May     (B) I     (C) Help     (D) You

17. The words used to connect phrases and words are .................. .

            (A)     Prepositions     (B) Adjective 

            (C) conjunctions       (D) Adverb

        18. You did me ............ favour.

            (A) huge     (B) large     (C) great     (D) maximum