GOVT.

Industrial Training Institute, PUSAD

TEST – Janewary-2024
NAME:………………………………………………........................ROLL NO:-………………………………

Marks : 100 ALL QUESTIONS ARE COMPULLSORY TRADE : COPA Time : 1 hrs
1. To open a new file in MS word, the shortcut key is
1) Ctrl+ X 2) Ctrl+ N 3) Ctrl +Y 4) Ctrl+ V 5) None of these
2. Which extension is given to Word document by default?
1) .ext 2) .com 3) .doc 4) none of these 5) All of these
3. Mark the most appropriate option statement
1) Mail Merge can be used to print the form letters 2) Mail Merge can be used to print the form letters
and mailing label 3) Mail Merge can be used to print envelopes
4) All of the above 5) None of the above
4. What is the term used for the word processing programs that show
You directly on the PC screen the appearance of your final document As you might expect on the
paper? 1) Search and Replace 2) pagination 3) Soft Copy 4 WYSIWYG 5) None of the above
5. Creating form letters using Mail Marge involves
1) Creating the main document 2) Creating the main documents and data source
3) Inserting merge fields in the main document and merging the main document
With data source 4) Both:’2’ and ‘3’ 5) None FO the above
6. Wich of the following gives the status of your document like page
Number, number of page?
1) Status bar 2) Standard 3) Formatting toolbar 4) none of these 5) All of these
7. Alignment buttones are available on which toolbar?
1) Status bar 2) Standard 3) Formatting toolbar 4) none of these 5) All of these
8. Heaber is
1) Ante printed at the top of every page 2) Any graphics printed at the top of every page
3) Any graphics printer at the top of particular page. 4) Any text or graphics printed at the top of
every page 5) None of the above
9. This case converts first character of first word of selected sentence to capital
1) Sentence 2) Upper 3) Toggle 4) Title 5) None of these
10. Which of the following is not an option of edit menu?
1) Cut 2) Copy 3) Paste 4) Page setup 5) No one of these
11. Which of the following will you use as an option for saving a file?
1) Save button Standard toolbar 2) Save option from File menu 3) Pressing Ctrl +3 4) All
of the above 5) None of These
12. A file name cannot contain in MS-Word database file
1) A letter 2) Number 3) Underscore 4) Space 5) None of these
13. When you start MS-Word, the opening document has the name as
1) DOC 1 2) Document 1 3) Document 4) Work book 5) Task book
14. The following shortcut keys are used for selecting the whole document
1) Ctrl+ A 2) Ctrl+ S 3) Ctrl+ W 4) Ctrl + X 5) Ctrl +Alt
15. Replace’ option is available in
1) Edit menu 2) File menu 3) Tools menu 4) Insert menu 5) None of these
16. Afier selecting the Replace’ option form the Edit Menu, the following dialog box appears
1) REPLAACE 2) Find 3) Find and Replace 4) Edit
17. MS- Word can in sent/import the graphics
1) Created in paintbrush 2) Created by using auto shapes 3) From clip Art gallery
4) All of the above 5) Both’2’ and ‘3’
18. You can use the following objects created in MS- Word in a web page
1) Auto shapes 2)Bullets 3) Tables and charts 4) All of these 5) None of these
19. Blinking point which shows your position in the text is called
1) Cursor 2) Blinker 3) Position 3) Status 4) Place
20. Spacebar is used for
1) Giving space 2) deleting space 3) Moving next line 4) All of these 5) None of these
21. You can start Microsoft word by using which button?
1) New 2) Start 3) Program 4) All of these 5) None of these
22. It is a software tool that lets one enter, calculate,
Manipulate set of numbers
1) Speed sheet 2) spread sheet 3 ) Silage sheet 4) All of these 5) Work book
23. It is a grid of cells made up of horizontal and Vertical columns
1) Worksheet 2) sheet 3) Spreadsheet 4) page 5) Work book
24. It is group of worksheets
1) Folder 2) document 3) Work book 4) books 5) Files
25. Three types of data can be entered in a worksheet, Number/characters, text and
1) Formulas 2) functions 3) Logic 4) All of these 5) None of these
26. To select the current row press
1) Shift + Enter 2) Shift +Spacebar 3) Ctrl + Spacebar 4) Ctrl + C
27. To select the current column press
1) Ctrl + Spacebar 2) Ctrl + B 3) Shift + Enter 4) Ctrl + Enter 5) Ctrl +shift
28. To select the entire worksheet
1) Ctrl + B 2) Ctrl + V 3) Ctrl + A 4) Ctrl + C 5) Ctrl + X
29. The Extension of saved file in MS-Excel?
1) XIS. 2) .XAS 3) .XLS 4).XLL 5) .LXS
30. All formula start with, which sign in M-S Excel?
1) + 2) – 3) @ 4) = 5) = =
31. for creating an absolute cell reference, which sign is used?
1) $ 2) @ 3) # 4)! 5) None of these
32. A cell entry can be edited in the cell or in the
1) Menu bar 2) edit menu 3) Function bar 4) formula bar 5) None of these
33. In this chart only one chart data series can be plotted
1) Pie 2) line 3) Bar 4) column 5) None of these
34. A chart placed in a worksheet is called
1. Formatting chart 2. embedded chart 3. Aligning chart 4. Hanging chart 5. None of these
35. This chart shows the relationships of parts to a whole
1) pie 2) line 3)stacked Bar 4)embedded 5)None of these
36.Scatter chart is also known as
1)XX chart 2)YX chart 3)XY chart 3)YY chart 5)XZ chart
37.The cell having bold boundary called
1)Reative 2)Active 3)Absolute 3)Mixed
38.Call address A4 in a formula means it is a
1) mixed cell reference 2) absolute cell reference
3) relative cell reference 4) All of the above 5)None of the above
39.Cell address $A$4 in a formula means it is a
1)mixed cekk reference 2)absolute cell reference
3)reative cell reference 4)All of the above 5) None of the above
40.Cell address $A4 in a foromula means ti is a
1) mixed cell reference 2) absolute cell reference
3)relative cell reference 4) All of the adove 5) None of the above
41.Cell address A$4 in a formula means it is a
1)mixe cell reference 2) absolutw cell reference 3) reative cell reference
4)All ofthe above 5) None of the above
42.Using the F11 shortout key to create a chart on chart sheet creates
1)A default chart 2)A 2-dimensional column chart
3)A 2-dimensional bar chart 4)A 2dimensional line chart 5) None of the adove
43. You can print
1) a range of cells by range name 2) an entire worksheet
3) a single worksheet 4)All of the above 5)None of the above
44.You can create only a horizontal page break by first selecting
1)a row below the row where you want the page break to 2)a cell in row 1
3)a cell in column A 4)Both ‘1’ and ‘3’ 5)All of the above
45. You can create hyperlinks from the Excel work book to
1)a web page on company internet 2)a web page on the internet
3)other office 97 application document 4)All of the above 5)None of the above
46.The advantage of using a apreadsheet is
1)calculations can be done automatically 2)changing data automatically updates
Calculations 3)more flexibility 4)All of the above 5)None of the above
47.You can not link excel worksheet data to word document
1)with the right drag method 2)with a hyperlink
3)with the copy and paste special commands 4)with the copy and paste buttons on the
standard toolbar 5)None of these
48.Which of the following is a popular DOS based spreadsheet package?
1)Word 2)Smart cell 3)Excel 4)Lotus 1-2-3 5)None of these
49. Which file formal can be added to a PowerPoint Show?
1) .jpg 2).giv 3).wav 3)All of these 4)None of these
50. In Microsoft Power Point two kind of sound effects files that can be added to the presentation are
1).wav files and .mid files 2).wav files and .gif files 3).wav files and .jpg files 4).jpg files and .gif
files 5)None of the these
 GOVT.Industrial Training Institute, PUSAD
TEST –February-2024
NAME:………………………………………………........................ROLL NO:-………………………………

Marks : 100 ALL QUESTIONS ARE COMPULLSORY TRADE : COPA Time : 1 hrs

51. Material consisting of text and number is best presented as

(1) A table slide 2) A bullet slide 3) A title slide 4) All of these 5) None of these
52. What is a motion path?
(1) A type of animation entrance effect 2) A method of advancing slides
3) A method of moving items on a slide 4) All of these
4) None of the above
53. What is a slide- title master pair?
(1) The title area text arrspecific slide
(2) A slide master and title master merged into a single slide
(3) A slide master and title master for a specific design template
(4) All of the above
(5) None of the above
54. Which of the following should you use if you want all the slides in the
presentation to have the same look?
(1) The slide layout option
(2) Add a slide option
(3) Outline view
(4) A presentation design template
(5) None of the above
55. In the context of animations, what is tagger?
(1) An action button that advances to the next slide
(2) An item on slide that perform an action when clicked
(3) The name of a motion path
(4) All of the above
(5) None of the above
56. To select one hyperlink after another during a slide presentation, what do you
press?
(1) Tab
(2) Ctrl=K
(3) Ctrl=H
(4) All of the above
(5) None of the above
57. Special effects used to introduce slide in a presentation are called
(1) Effects
(2) Custom animations
(3) Transitions
(4) Present animations
(5) None of the above
58. You can edit an embedded Organization chart object by
(1) Clicking edit object
(2) Double clicking the organization chart object
(3) Right clicking the chart object, then clicking edit MS-Organization chart object
(4) Both 2 and 3
(5) None of the above
59. Which of the following toolbars provide different options in various master
views?
(1) Common tasks toolbar
(2) Drawing toolbar Formatting toolbar
(3) Standard toolbar
(4) None of the above

60. How can you create a uniform appear an adding a background image to all slide
?
(1) Create a template
(2) Edit the slide master
(3) Use the autocorrect wizard
(4) All of the above
(5) None of the above
61. How do you create speaker note pages the slides , related notes and your
complain on each page?
(1) Edit the notes master add add your complain logo
(2) Edit the slide master and insert your complain logo and notes space
(3) Edit the handout master to include company logo and one slide per page
additional note space
(4) All of the above
(5) None of the above

62 . Which of the following tool enables you to an to a slide without using the start
placeholders?

(1) Text tool box

(2) Line tool
(3) Drawing tool
(4) Auto shapes tool
(5) None of these

63. In notes master view, how do you modify the size of the text for all the notes of
a presentation?
(1) Modify the slide design
(2) Modify the notes master layout
(3) Modify the text within the body place hold
(4) All of the above
(5) None of the above

64.In notes master view, hold do you modify the size of text for all the notes of a
presentation

(1)Slide sorter

(2)Notes pages vie

(3)Slide view

(4)Outline view

(5)none of these
65. Which command brings you to the first sli your presentation?

(1)Next slide button

(2)Page up

(3)Ctrl+Home

(4)Ctrl+End

(5)None of these

66.In normal view,how can you quickly chan handout master view?

(1)Click the outline tab and select master view

(2)Press the shift key and click the har master view button

(3)on the view menu, click slide sorter and click handouts

(4)All if the above

(5)none of the above

67.Which can you quickly reinstate a deleted footer placeholder in master view?

(1)Create a new slide master

(2)Re-apply the footer placeholder

(3)Re-apply the slide layout

(4)All of the above

(5)None of the above

68.Which of the following can you use to add times to the slide in a presentation?

(1)slide show menu

(2)Rehearse timing button

(3)Slide transition button

(4)All of the above (5)None of the above

69.To select all of the boxes of an Organization chart

(1)clicking and edit and select all (2)right click the chart
background and then click select all (3)press and hold the shift key and click each
box

(3)press and hold the shift key and click each box

(4)All of the above

(5)None of the above

70.You can show the shortcut menu during the slide show by

(1)clicking the shortcut button on the formatting toolbar

(2) right clicking the current slide

(3) clicking an icon on the current slide

 (4) Both ‘1’ and ‘2’

(5) None of the above

71. Auto clipart is feature that

(1) Automatically place clipart in your presentation

(2) Scans your presentation for incorrect spelling in your words on each slide

(3) Scans your position for incorrect spelling in Word At objects

(4) All of the above

(5)None of the above

72. Which of the following allow you to select more than one slide in a
presentation?

(1) alt+clickeach slide

(2) Shift+drag each slide

(3) Shift+Click each slide

(4) Ctrl+click each slide

(5) None of the above

73. Which bar is usually located blow the title bar that provides categorized option?

(1) Menu bar (2) Status bar

(3) Tool bar (4) scroll bar

(5) None of these

74. Example of centralized multi-user databases are

(1) Airline reservations and other national global booking systems,

(2) Barclays’ Bank customer accounts

(3) Supermarket stock control, organ donor

Database, client database

(4)All of these

(5) None of these

75. When a customer makes an online hotel booking,

The database is update in

(1) Batch mode 2) pseudo real time

3) 2 days 4) All of these
5) None of these

76. What is the name for match between the words

or Phrase being searched and the items found in an

Electronic database?
1) Bug 2) Hit 3)
It 3) Default 5)
None of this

78. DBMS is

1) collection of data 2)set of

programs to access those data 3) set programs
to access those data 4) All of the above
5) None of the above

79. COPY STRUCTURE command is used to

1) copy contents of an active database to a new file 2) copy all

record of an active database to disk 3) copy content of an
active database to disk 4)copy structure of an active
database to a new file5) None of above

80. COUNT command is used to

1) count the number of data fields in an active database file -2) count the
number of data files which are active 3) count the record which
are undated 4) count the number of records in
an active database file 5) None of the above

81. Which is the short key to invoke the spell checker in MS Access?

1) F2 2) F7 3) Alt +
F7 4) F3 5) F4

82. A specialist in charge of the database of an organization. Select the best fit
for answer. 1) Database
management approach 2) DBMS uses
3) Database administrator 4)
Query language 5) None
of the above

83. You want to keep track of addresses, phone numbers, parent/Guarding names as
well as class attendance, average and grades. Every so often you want to send reports
home that select foiling grades and excessive absences. Which part of the Microsoft
Office suit used in this course is best suited for this kind of information?

1) Excel 2) Power point 3) Access

4) Word 5)
None of the above

84. A treelike structure of record in a database Selected

The best fit for answer.

1) Hierarchical database structure 2)

Relational database structure 3)
Multidimensional database structure 4)
Sequential database Access 5)
None of these

85. Which statement is not valid about indexing?

 1)It stores the index fields 2) It
stores the corresponding record number 3) It
maintains the alphabetically order 4) It
duplicates the database file 5) None
of the above

86. Device that could be used to input data a database are

1) Keyboard, fax roller ball

2)mouse ,keyboard, monitor 3)
mouse, keyboard, touch screen 4) All
of the above 5) None of
the above

87. The taskbar is located

1) on the start menu 2) at

the batten of the screen 3)
4) at the top of the screen 5)
None of the above 88. A……… is
an additional set of commands that the computer displays after you make a
selection from the main menu.

1) dialog box
2) sub menu 3)
menu selection 4)All of
these 5)None of the
above

89. In Excel charts are created using which option?

1) Chart wizard
2) Pivot table 3)
Pie chart 4) Bar
chart
5) None of these 90.
Which element of a word document can be displayed in cooler?

1) Only graphics 2) Only

text 3) All
elements 4) All
elements, but only if you have a cooler printer 5) None
of the above

91. If was text highlighted and edit copy was clicked, what would happen ?

(1) Text would be copied from the document and

Placed in the clipboard

(2) Text would be remove from the document

and placed in the clipboard

(3) Text from the clipboard would be placed in the

 Document at the placed where the cursor

blinking

(4) Both ‘2’ and ‘3’

(5) None of the above

92. Which groupings do you work with when

Formatting text in word ?

(1)Tables, paragraphs and indexes

(2)Paragraphs, indexes and sections
(3)Characters, sections and paragraphs
(4)Indexes, characters and tables
(5)None of the above

93. How are the data organized in a spreadsheet?

(1) Lines and spaces (2) Layers and planes

(3) Height and width (4) Row and columns

(5) None of these

94. When cutting and pasting the item out is

temporarily stored in

(1)Rom (2) Hard drive

(3 )Diskette (4) Dashboard

95.Which of the following can be use to select the

Entire document ?

(1)Ctrl + A
(2)Alt + F5
(3)Shift + A
(4)Ctrl + K
(5)Ctrl + H

96.The basic unit of worksheet into which you

Enter data in excel called a

(1)Tab (2) Cell

 (3)Box (4) Range

(5) None of these

97.In word you can force a page break

(1) by positioning your cursor at the appropriate

Place and pressing the F1 key

(2)Bye positioning your cursor the appropriate

Place and pressing Ctrl + Enter
(3)By using the insert /section break
(4)By changing the font size of your document
(5)None of the above

98. In excel _____________ allows users to bring together

copies of workbooks thet other users have

worked on independently.

(1)Coping
(2)Merging
(3)Pasting
(4)Compiling
(5)None of the above

99. The letter and number of this intersecting column

and row is the

(1)cell location (2) cell posting

(3)cell address (4) cell coordinates

( 5) cell contents

100. In PowerPoint the header and footer button can

be found on the insert tab in what group?

(1)Illustration group (2) object group

(3) text group (4) tables groups

(5) None of these

101. When entering text within a document, the enter

Key is normally pressed at the end of every

(1)Line (2) sentence

(3) paragraph ( 4) word

(5) file
102. What is the overall term for creating, editing

Formatting, storing, retrieving and printing a text

Document?

(1)Word processing
(2)Spread sheet design
(3)Web design
(4)Database management
(5)Presentation generation

103. Which power point view displays each slide of the

Presentation as a thumbnail and is useful for

rearranging slides?

(1)Slides sorter (2) Slide show

(3) Slide master (4) Notes page

(5) Slide design

Answers
1.(2) 2.(3) 3.(4) 4.(4) 5.(4) 6.(1) 7.(3) 8.(4) 9.(1) 10.(4)

11.(4) 12.(4) 13.(2) 14.(1) 15.(1) 16.(3) 17.(4) 18.(5) 19.(1) 20.(1)

21. (2) 22.(2) 23.(1) 24.(3) 25.(3) 26.(2) 27.(1) 28. (3) 29. (3) 30.(4)

31.(1) 32.(4) 33.(1) 34.(2) 35.(3) 36.(3) 37.(2) 38.(3) 39.(2) 40.(1)

41.(1) 42.(2) 43.(4) 44.(4) 45.(4) 46.(4) 47.(4) 48.(4) 49.(4) 50.(1)

51.(1) 52.(3) 53.(3) 54.(4) 55.(2) 56.(1) 57.(3) 58.(4) 59.(1) 60.(2)

61.(3) 62.(1) 63.(3) 64.(1) 65.(3) 66.(2) 67.(2) 68.(2) 69.(4) 70.(2)

71.(4) 72.(3) 73.(1) 74.(1) 75.(2)76.(2) 77.(3) 78.(4) 79.(4) 80.(4)

81.(2) 82.(2) 83.(3) 84.(1) 85.(4) 86.(3) 87.(2) 88.(2) 89.(1) 90.(3)