Application Software

Model Questions
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 docents 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 latter 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

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
(5) 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)