8.

1 What is the shortcut key to “Center Align” the selected

text?
A. Ctrl + C
B. Ctrl + E
C. Ctrl + F
D. None of above
8.2 What is the shortcut key to “Undo” the last action in a
document?
A. Ctrl + X
B. Ctrl + Y
C. Ctrl + Z
D. None of above
8.3 What is the shortcut key to “Insert Hyperlink” in a
document?
A. Ctrl + H
B. Ctrl + L
C. Ctrl + K
D. None of above
8.4 What is the shortcut key for “Find and Replace” dialog
box?
A. Ctrl + F
B. Ctrl + R
C. Ctrl + H
D. Ctrl + Shift + F
8.5 What is the shortcut key for Spelling Check in
document?
A. F7
B. Shift + F7
C. Ctrl + F7
D. Alt + F7
8.6 What is the shortcut key to Update Formula in a table?
A. F9
B. Alt + F9
C. Ctrl + F9
D. Shift + F9
8.7 What is the shortcut key to Close Active Document in
Microsoft Word?
A. Ctrl + F4
B. Shift + F4
C. Ctrl + Shift + F4
D. None of above
8.8 What is the shortcut key for “Font” dialog box?
A. Ctrl + F
B. Ctrl + D
C. Ctrl + G
D. None of the above
8.9 What is the shortcut key for “Superscript” the selected
text?
A. Ctrl + =
B. Ctrl + -
C. Ctrl + Shift + =
D. Ctrl + Shift + -
8.10 What is the shortcut key for “Subscript” the selected
text?
A. Ctrl + =
B. Ctrl + -
C. Ctrl + Shift + =
D. Ctrl + Shift + -

Answers
1 – B / 2 – C / 3 – C / 4 – C / 5 – A / 6 – A / 7 – A / 8 – B / 9 – C / 10 – A

-1. Which do you press to force a page break?

A. CTRL+ALT
B. CTRL+ break
C. CTRL+ Enter
D. none of the above
7-2. Which do you choose to create footer? (in MS Office 2003)
A. format, header and footer
B. view, footer
C. insert, header and footer
D. view, header and footer
7-3. Which do you choose to create header? (in MS Office 2003)
A. format, header and footer
B. view, header
C. insert, header and footer
D. view, header and footer
7-4. Which do you choose to shade words and paragraph?
A. format, borders and shading
B. insert, borders and shading
C. view, shading
D. none of the above
7-5. to view headers and footers, you must switch to
A. normal view
B. print layout view
C. print preview mode
D. both B and C
7-6. Which of the following can you change using the page
setup dialog box?
A. margins
B. page orientation
C. vertical alignment
D. all of the above
7-7. By default, your document prints with:
A. 1 inch top and bottom margins
B. a portrait orientation
C. 1.25 inches left and right margins
D. all of the above
7-8. switching between portrait and landscape modes
involves the:
A. header and footer toolbar
B. print layout view
C. page setup dialog box
D. none of the above
7-9. What happens when you insert an AutoShape by simply
clicking in the document?
A. it appears near the insertion point
B. it is inserted in its default size
C. is selected
D. all of the above
7-10. What must be used to control the layering of objects?
A. formatting toolbar
B. picture toolbar
C. drawing toolbar
D. image toolbar

Answers
1 – C / 2 – D / 3 – D / 4 – A / 5 – D / 6 – D / 7 – D / 8 – C / 9 – D / 10 – C

1. When sharing data in Office, the ……… document is the

document in which the data was first entered.
A. source
B. destination
C. original
D. primary
5-2. Which command is used to establish a link between a
source document and a destination document?
A. Tools, Link, Documents
B. Tools, Link
C. Edit, Link
D. Edit, Paste Special
5-3. Which option enables automatic updates in destination
documents?
A. embedding
B. objects
C. links
D. relationships
5-4. Which is an Office feature that makes it easy to edit
embedded objects?
A. pasting
B. visual editing
C. tools, update, links
D. edit, links
5-5. Which is true when you insert an excel worksheet into a
word document?
A. word is the destination document
B. excel is the destination document
C. the worksheet is the destination document
D. the document is the source document
5-6. What would you do when you want to update the data
in an embedded worksheet range?
A. double click the worksheet range object
B. right click worksheet range object & choose format object
C. edit the data in the destination document
D. edit the data in the source document.
5-7. Which can be used for quick access to commonly used
commands and tools?
A. Status bar
B. Tool bar
C. Menu bar
D. Title bar
5-8. With which view can you see how text and graphics will
appear on the printed page?
A. Normal
B. Print Layout
C. Outline
D. Web Layout
5-9. Which simplifies the process of formatting text if the
same formatting is required in more than one location?
A. Auto Text
B. Format Painter
C. Font dialog box
D. None of the above
5-10. Which of the following is best for quick copy
operation?
A. Copy and Paste
B. Windows Clipboard
C. Drag and Drop
D. Auto Text
==================================
Answers
1 – A / 2 – D / 3 – C / 4 - B / 5 - A / 6 – A / 7 – B / 8 – B / 9 – B / 10 – C
==================================

 Post to Facebook
 Post to Twitter

 Post on Google Buzz

 Post to StumbleUpon
 Post to Blogger
 Send via Gmail
 Subscribe to the comments for this post?
 Post to Delicious
 Post to Digg
1. When typing in a word field manually, what must you
press to insert the code’s braces?
A. Ctrl + F6
B. Ctrl + F9
C. Alt + F11
D. Shift + F12
4-2. A word field may consist of an optional field instruction
called a(n) …………..
A. subdocument
B. symbol
C. signal
D. switch
4-3. Footnotes, endnotes, and indexes are all inserted as
………….
A. bookmarks
B. cross-references
C. hyperlinks
D. word fields
4-4. Before creating a master document, you must switch
to..……
A. Normal View
B. Outline View
C. Web Layout View
D. Print Layout View
4-5. Before moving a subdocument to another location
within a master document, you must switch to …………..
A. Normal View
B. Outline View
C. Web Layout View
D. Print Layout View
4-6. Which of the following can be used to navigate
documents?
A. frames
B. hyperlinks
C. web toolbar
D. all of the above
4-7. Which of the following can be used to divide a web page
into areas?
A. frames
B. theme
C. table of contents
D. none of the above
4-8. By default, Word automatically formats each heading in
a table of contents as ………..
A. bookmarks
B. cross-references
C. hyperlinks
D. word-fields
4-9. The ability to combine name and addresses with a
standard document is called ……….
A. document formatting
B. database management
C. mail merge
D. form letters
4-10. Which feature is used for monitoring all document
changes?
A. Edit Document
B. Monitor Change
C. Track Change
D. Track all
=========================
Answers
1 – B / 2 – D / 3 – D / 4 – B / 5 – B / 6 – B / 7 – A / 8 – C / 9 – C / 10 – C
=========================

1 What is the shortcut key for repeat the recent find?

A. CTRL + F4
B. SHIFT + F4
C. CTRL + F5
D. SHIFT + F5
5.2 Which is the Shortcut key to start a presentation from
the beginning?
A. F5
B. ALT + F5
C. CTRL + F5
D. SHIFT + F5
5.3 Which is the shortcut key to jump to the first slide of the
presentation?
A. Home
B. Alt + Home
C. Ctrl + Home
D. Shift + Home
5.4 To select more than one slide in the presentation
A. Just Click on slide
B. Ctrl + Click on slide
C. Alt + Click on slide
D. Shift + Click on slide
5.5 To place something in the same position on every slide
of presentation automatically, insert into
A. Slide master
B. Notes master
C. Handout master
D. None of the above
5.6 To edit an already inserted embedded organization chart
object by
A. Double Click on the organization chart object
B. CTRL + Click on the organization chart object
C. SHIFT + Click on the organization chart object
D. None of the above
5.7 Shortcut key to insert a hyperlink in a slide
A. Ctrl + H
B. Ctrl + K
C. Hyperlinks can’t be inserted in slides
D. None of the above
5.8 To draw the Square box in the slide by selecting
rectangle tool
A. Holding CTRL & Draw
B. Holding ALT & Draw
C. Holding SHIFT & Draw
D. All of the above
5.9 What is the maximum zoom percentage in Microsoft
PowerPoint?
A. 100%
B. 200%
C. 300%
D. 400%
5.10 Microsoft PowerPoint can insert objects from the
following add-ins?
A. Equation Editor
B. Organization Chart
C. Photo Album
D. All of these

Answers
1 – B / 2 – A / 3 – C / 4 – B / 5 – A / 6 – A / 7 – B / 8 – C / 9 – D / 10 – D

.1 Which type of template provides a design concept, fonts

& color scheme for presentation?
A. Format
B. Design
C. Content
D. Normal
4.2 In Normal view, this tab displays the content of each
slide.
A. Slides
B. View
C. Sort
D. Outline
4.3 Which is the menu to create a text box on a slide.
A. View -> Text Box
B. Tools -> Text Box
C. Insert -> Text Box
D. Format -> Text Box
4.4 Which is not the one of view options provided by
PowerPoint to look at and modify presentation.
A. Slide Show
B. Format Slide
C. Slide Sorter
D. Normal
4.5 In PowerPoint, when the mouse pointer appears as this
it indicates that the Draw Table feature is on
A. Solid plus sign
B. Solid arrow
C. I-beam
D. Pencil
4.6 Which is the menu command to recolor a picture on a
slide
A. Insert -> Picture -> Recolor
B. Tools -> Picture -> Recolor
C. Format -> Picture -> Recolor
D. Edit -> Picture -> Recolor
4.7 PowerPoint design templates are stored in a file with
this extension.
A. .ptt
B. .pot
C. .ppt
D. .dtp
4.8 In Power Point, this is a container for text or graphics.
A. Slide master
B. Table
C. Placeholder
D. Text box
4.9 This is the menu command used to apply a design
template in PowerPoint.
A. Tools -> Slide Design
B. Format -> Slide Design
C. Insert -> Slide Design
D. Insert -> Slide Design
4.10 This task pane shows the design that is currently being
used in a presentation.
A. Slide Show
B. Slide Style
C. Slide Design
D. Slide Format

Answers
1 – B / 2 – D / 3 – C / 4 – B / 5 – D / 6 – C / 7 – B / 8 – D / 9 – B / 10 – C

1. The spelling dialog box can be involved by choosing

spelling from ________ menu.
A. Insert
B. File
C. Tools
D. View
3-2. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
3-3. Which PowerPoint feature allows the user to create a
simple presentation without having to spend too much time
on it?
A. AutoContent Wizard
B. Animation
C. Color Schemes
D. Chart Wizard
3-4. Which PowerPoint feature adds special effects to
modify the appearance of the slides and the timing between
each slide?
A. Color Schemes
B. Animation
C. Transition Settings
D. Handouts
3-5. Slide sorter of PowerPoint is available on _____ menu.
A. Insert
B. File
C. View
D. Edit
3-6. To print the PowerPoint presentation, press
A. Ctrl + T
B. Ctrl + E
C. Ctrl + S
D. Ctrl + P
3-7. What is a slide transition?
A. Overheads
B. Letters
C. A special effect used to introduce a slide in a slide show
D. The way one slide looks
3-8. What does “apply design template” do?
A. Changes the content of the slide
B. Adds functionality to the slide
C. Changes the look of the slide without changing the content
D. None of the above
3-9. How can you stop a slide show?
A. Press the right arrow
B. Press Escape
C. Press the left arrow
D. Press the down arrow
3-10. What do you do to start the slide show?
A. Click on Go
B. Turn on transition
C. Click on the Slide Show icon
D. All of the above

Answers
1 – C / 2 – C / 3 – A / 4 – C / 5 – C / 6 – D / 7 – C / 8 – C / 9 – B / 10 – C

Slides can have

A. title, text, graphs
B. drawn objects, shapes
C. clipart, drawn art, visual
D. any of the above
2-2. A Chart can be put as a part of the presentation using
A. Insert -> Pictures –> Chart
B. Insert –> Chart
C. Edit –> Chart
D. View -> Chart
2-3. We can replace a font on all slides with another font
using the option :
A. Edit –> Fonts
B. Tools –> Fonts
C. Tools -> Replace Fonts
D. Format -> Replace Fonts
2-4. Which key on the keyboard can be used to view Slide
show?
A. F1
B. F2
C. F5
D. F10
2-5. Which option in PowerPoint allows you to create a
package of your presentation for showing to another
computer?
A. Save As
B. Save and Go
C. Pack and Go
D. Web and Go
2-6. Which view in Power Point can be used to enter Speaker
Comments?
A. Normal
B. Slide Show
C. Slide Sorter
D. Notes Page view
2-7. Which option can be used to set custom timings for
slides in a presentation?
A. Slider Timings
B. Slider Timer
C. Rehearsal
D. Slide Show Setup
2-8. Which option can be used to create a new slide show
with the current slides but presented in a different order?
A. Rehearsal
B. Custom Slide show
C. Slide Show Setup
D. Slide Show View
2-9. Which of the following is an example for Automatic Text
formatting?
A. Underlining Hyperlink
B. Adjusting extra space
C. Replacing two – s with a hyphen
D. All of the above
2-10. Power Point can display data from which of the
following add-in software of MS Office?
A. Equation Editor
B. Organization Chart
C. Photo Album
D. All of these

Answers
1 – D / 2 – A / 3 – D / 4 – C / 5 – C / 6 – D / 7 – C / 8 – B / 9 – D / 10 – D

1. Power Point presentation is a collection of ________

A. Slides and Handouts
B. Speaker’s notes
C. Outlines
D. All of the above
1-2. How can the slide show be repeated continuously?
A. loop continuously until ‘Esc’
B. repeat continuously
C. loop more
D. none
1-3. From where can we set the timing for each object?
A. slide show, custom transition
B. Slide show, Slide transition
C. slide show, custom animation
D. view, slide sorter
1-4. The arrangement of elements such as Title and subtitle
text, pictures, tables etc. is called :
A. Layout
B. Presentation
C. Design
D. Scheme
1-5. A File which contains readymade styles that can be
used for a presentation is called :
A. AutoStyle
B. Template
C. Wizard
D. Pre formatting
1-6. After choosing a predefined template, which option has
to be chosen to change the background color?
A. Design Template
B. Color Scheme
C. Animation Scheme
D. Color Effects
1-7. Ellipse Motion is a predefined ________
A. Design Template
B. Color Scheme
C. Animation Scheme
D. None of these
1-8. Animation Schemes can be applied to ________ in the
presentation.
A. All slides
B. Select slides
C. Current Slide
D. All of the above
1-9. To insert new slide in the current Presentation, we can
choose:
A. Ctrl+M
B. Ctrl+N
C. Ctrl+O
D. Ctrl+F
1-10. To open the existing presentation, press
A. Ctrl + L
B. Ctrl + N
C. Ctrl + A
D. Ctrl + O

Answers
1 – D / 2 – A / 3 – C / 4 – A / 5 – B / 6 – B / 7 – C / 8 – D / 9 – A / 10 – D

1 What is the shortcut key for repeat the recent find?

A. CTRL + F4
B. SHIFT + F4
C. CTRL + F5
D. SHIFT + F5
5.2 Which is the Shortcut key to start a presentation from
the beginning?
A. F5
B. ALT + F5
C. CTRL + F5
D. SHIFT + F5
5.3 Which is the shortcut key to jump to the first slide of the
presentation?
A. Home
B. Alt + Home
C. Ctrl + Home
D. Shift + Home
5.4 To select more than one slide in the presentation
A. Just Click on slide
B. Ctrl + Click on slide
C. Alt + Click on slide
D. Shift + Click on slide
5.5 To place something in the same position on every slide
of presentation automatically, insert into
A. Slide master
B. Notes master
C. Handout master
D. None of the above
5.6 To edit an already inserted embedded organization chart
object by
A. Double Click on the organization chart object
B. CTRL + Click on the organization chart object
C. SHIFT + Click on the organization chart object
D. None of the above
5.7 Shortcut key to insert a hyperlink in a slide
A. Ctrl + H
B. Ctrl + K
C. Hyperlinks can’t be inserted in slides
D. None of the above
5.8 To draw the Square box in the slide by selecting
rectangle tool
A. Holding CTRL & Draw
B. Holding ALT & Draw
C. Holding SHIFT & Draw
D. All of the above
5.9 What is the maximum zoom percentage in Microsoft
PowerPoint?
A. 100%
B. 200%
C. 300%
D. 400%
5.10 Microsoft PowerPoint can insert objects from the
following add-ins?
A. Equation Editor
B. Organization Chart
C. Photo Album
D. All of these

Answers
1 – B / 2 – A / 3 – C / 4 – B / 5 – A / 6 – A / 7 – B / 8 – C / 9 – D / 10 – D
.1 Which type of template provides a design concept, fonts
& color scheme for presentation?
A. Format
B. Design
C. Content
D. Normal
4.2 In Normal view, this tab displays the content of each
slide.
A. Slides
B. View
C. Sort
D. Outline
4.3 Which is the menu to create a text box on a slide.
A. View -> Text Box
B. Tools -> Text Box
C. Insert -> Text Box
D. Format -> Text Box
4.4 Which is not the one of view options provided by
PowerPoint to look at and modify presentation.
A. Slide Show
B. Format Slide
C. Slide Sorter
D. Normal
4.5 In PowerPoint, when the mouse pointer appears as this
it indicates that the Draw Table feature is on
A. Solid plus sign
B. Solid arrow
C. I-beam
D. Pencil
4.6 Which is the menu command to recolor a picture on a
slide
A. Insert -> Picture -> Recolor
B. Tools -> Picture -> Recolor
C. Format -> Picture -> Recolor
D. Edit -> Picture -> Recolor
4.7 PowerPoint design templates are stored in a file with
this extension.
A. .ptt
B. .pot
C. .ppt
D. .dtp
4.8 In Power Point, this is a container for text or graphics.
A. Slide master
B. Table
C. Placeholder
D. Text box
4.9 This is the menu command used to apply a design
template in PowerPoint.
A. Tools -> Slide Design
B. Format -> Slide Design
C. Insert -> Slide Design
D. Insert -> Slide Design
4.10 This task pane shows the design that is currently being
used in a presentation.
A. Slide Show
B. Slide Style
C. Slide Design
D. Slide Format

Answers
1 – B / 2 – D / 3 – C / 4 – B / 5 – D / 6 – C / 7 – B / 8 – D / 9 – B / 10 – C

The spelling dialog box can be involved by choosing spelling

from ________ menu.
A. Insert
B. File
C. Tools
D. View
3-2. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
3-3. Which PowerPoint feature allows the user to create a
simple presentation without having to spend too much time
on it?
A. AutoContent Wizard
B. Animation
C. Color Schemes
D. Chart Wizard
3-4. Which PowerPoint feature adds special effects to
modify the appearance of the slides and the timing between
each slide?
A. Color Schemes
B. Animation
C. Transition Settings
D. Handouts
3-5. Slide sorter of PowerPoint is available on _____ menu.
A. Insert
B. File
C. View
D. Edit
3-6. To print the PowerPoint presentation, press
A. Ctrl + T
B. Ctrl + E
C. Ctrl + S
D. Ctrl + P
3-7. What is a slide transition?
A. Overheads
B. Letters
C. A special effect used to introduce a slide in a slide show
D. The way one slide looks
3-8. What does “apply design template” do?
A. Changes the content of the slide
B. Adds functionality to the slide
C. Changes the look of the slide without changing the content
D. None of the above
3-9. How can you stop a slide show?
A. Press the right arrow
B. Press Escape
C. Press the left arrow
D. Press the down arrow
3-10. What do you do to start the slide show?
A. Click on Go
B. Turn on transition
C. Click on the Slide Show icon
D. All of the above

Answers
1 – C / 2 – C / 3 – A / 4 – C / 5 – C / 6 – D / 7 – C / 8 – C / 9 – B / 10 – C

1. Slides can have

A. title, text, graphs
B. drawn objects, shapes
C. clipart, drawn art, visual
D. any of the above
2-2. A Chart can be put as a part of the presentation using
A. Insert -> Pictures –> Chart
B. Insert –> Chart
C. Edit –> Chart
D. View -> Chart
2-3. We can replace a font on all slides with another font
using the option :
A. Edit –> Fonts
B. Tools –> Fonts
C. Tools -> Replace Fonts
D. Format -> Replace Fonts
2-4. Which key on the keyboard can be used to view Slide
show?
A. F1
B. F2
C. F5
D. F10
2-5. Which option in PowerPoint allows you to create a
package of your presentation for showing to another
computer?
A. Save As
B. Save and Go
C. Pack and Go
D. Web and Go
2-6. Which view in Power Point can be used to enter Speaker
Comments?
A. Normal
B. Slide Show
C. Slide Sorter
D. Notes Page view
2-7. Which option can be used to set custom timings for
slides in a presentation?
A. Slider Timings
B. Slider Timer
C. Rehearsal
D. Slide Show Setup
2-8. Which option can be used to create a new slide show
with the current slides but presented in a different order?
A. Rehearsal
B. Custom Slide show
C. Slide Show Setup
D. Slide Show View
2-9. Which of the following is an example for Automatic Text
formatting?
A. Underlining Hyperlink
B. Adjusting extra space
C. Replacing two – s with a hyphen
D. All of the above
2-10. Power Point can display data from which of the
following add-in software of MS Office?
A. Equation Editor
B. Organization Chart
C. Photo Album
D. All of these

Answers
1 – D / 2 – A / 3 – D / 4 – C / 5 – C / 6 – D / 7 – C / 8 – B / 9 – D / 10 – D

1. Power Point presentation is a collection of ________

A. Slides and Handouts
B. Speaker’s notes
C. Outlines
D. All of the above
1-2. How can the slide show be repeated continuously?
A. loop continuously until ‘Esc’
B. repeat continuously
C. loop more
D. none
1-3. From where can we set the timing for each object?
A. slide show, custom transition
B. Slide show, Slide transition
C. slide show, custom animation
D. view, slide sorter
1-4. The arrangement of elements such as Title and subtitle
text, pictures, tables etc. is called :
A. Layout
B. Presentation
C. Design
D. Scheme
1-5. A File which contains readymade styles that can be
used for a presentation is called :
A. AutoStyle
B. Template
C. Wizard
D. Pre formatting
1-6. After choosing a predefined template, which option has
to be chosen to change the background color?
A. Design Template
B. Color Scheme
C. Animation Scheme
D. Color Effects
1-7. Ellipse Motion is a predefined ________
A. Design Template
B. Color Scheme
C. Animation Scheme
D. None of these
1-8. Animation Schemes can be applied to ________ in the
presentation.
A. All slides
B. Select slides
C. Current Slide
D. All of the above
1-9. To insert new slide in the current Presentation, we can
choose:
A. Ctrl+M
B. Ctrl+N
C. Ctrl+O
D. Ctrl+F
1-10. To open the existing presentation, press
A. Ctrl + L
B. Ctrl + N
C. Ctrl + A
D. Ctrl + O

Answers
1 – D / 2 – A / 3 – C / 4 – A / 5 – B / 6 – B / 7 – C / 8 – D / 9 – A / 10 – D

 Post to Facebook
 Post to Twitter

11

11

11
 11

11

11

11

11

11

 Post to StumbleUpon
 Post to Blogger
 Send via Gmail
 Subscribe to the comments for this post?
 Post to Delicious
 Add to LinkedIn


1 A function inside another function is called _______

A. Nested function
B. Round function
C. Sum function
D. Text function
8-2 Which of the following is not an underline option in the
format cells dialog box?
A. Double
B. Single Accounting
C. Double Accounting
D. Single Engineering
8-3 Formulas in Excel start with
A. %
B. =
C. +
D. -
8-4 The default header for a worksheet is
A. Username
B. Date and Time
C. Sheet tab Name
D. None
8-5 Which of the following is not an option of the spelling
dialog box?
A. Ignore
B. Ignore all
C. Edit
D. Change
8-6 Which of the following methods will not enter data in a
cell?
A. Pressing the Esc key
B. Pressing an arrow key
C. Pressing the tab key
D. Clicking the enter button to the formula bar
8-7 The cell reference for cell range of G2 to M12 is _______
A. G2.M12
B. G2;M12
C. G2:M12
D. G2-M12
8-8 What is the keyboard shortcut for creating a chart from
the selected cell range?
A. F2
B. F4
C. F8
D. F11
8-9 The Software which contains rows and columns is called
______
A. Database
B. Drawing
C. Spreadsheet
D. Word processing
8-10 You can group noncontiguous worksheets with
A. The alt+enter key
B. The ctrl key and mouse
C. The shift key and the mouse
D. The group button on the standard toolbar

Answers
1 – A / 2 – D / 3 – B / 4 – D / 5 – C / 6 – A / 7 – C / 8 – D / 9 – C / 10 – B

1. The box on the chart that contains the name of each

individual record is called the ________.
A. cell
B. title
C. axis
D. legend
7-2. If you want all of the white cats grouped together in the
database, you need to sort by ________.
A. Color, then Gender
B. Pet Type, then Color
C. Pet Type, then Gender
D. Color, then Pet Name
7-3. You accidentally erased a record in the sheet. What
command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
7-4. Where a row and a column meet, what do you call that?
A. A cell
B. A block
C. A box
D. None of the above
7-5. How do you tell one cell from another?
A. By numbers
B. By letters
C. By its address
D. by color
7-6. Give me an example of a cell address.
A. 11 25
B. 911
C. 41A
D. A21
7-7. Which is an example of a formula?
A. =A1+A2
B. =add(A1:A2)
C. A1+A2
D. SUM(A1:A2)
7-8. Which is an example of a function?
A. =add(A1:A2)
B. =A1+A2
C. =SUM(A1:A2)
D. A1+A2
7-9. What is the symbol for multiplying?
A. >
B. /
C. !
D. *
7-10. What is the symbol for dividing?
A ./
B. %
C. &
D. #

Answers
1 – D / 2 – B / 3 – C / 4 – A / 5 – C / 6 – D / 7 – A / 8 – C / 9 – D /10 – A

1. B7:B9 indicates:
A. Cells B7 and cell B9 only.
B. Cells B7 through B9.
C. Cell B8 only.
D. None of the above.
6-2. The Cancel and Enter buttons appear in the:
A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs
6-3. MS-EXCEL can be used to automate
A. Financial statements, Business forecasting
B. Transaction registers, inventory control
C. Accounts receivable, accounts payable
D. Any of the above
6-4. NOT, AND, OR and XOR are
A. Logical Operators
B. Arithmetic operators
C. Relational operators
D. None of the above
6-5. In a report, you need to show the monthly rainfall in
Nepal. The best way to do this is to insert a
A. calendar
B. photograph of rainfall
C. chart showing rainfall amounts
D. database of rainfall
6-6. You want to record experiment information and create a
chart that shows the rate of crystal growth over a period of
time. The best application to use would be:
A. word processing
B. spreadsheet
C. database
D. graphics
6-7. You are editing an worksheet that you had previously
saved. If you want to save the edited sheet without losing
the original one, which command should you use?
A. New
B. Save As
C. Edit
D. Save
6-8. If you want to have a blank line after the title in a
worksheet, what is the best thing for you to do?
A. Re-format the spreadsheet
B. Insert a row
C. Increase the column width
D. Use the spacebar
6-9. In order to arrange the countries from those with the
highest population to those with the lowest, you need to
sort on the population field in ……………
A. ascending order
B. descending order
C. alphabetical order
D. random order
6-10. In order to perform a calculation in a spreadsheet, you
need to use a:
A. table
B. formula
C. field
D. variable

Answers
1 – B / 2 – B / 3 – D / 4 – A / 5 – C / 6 – B / 7 – B / 8 – B / 9 – B / 10 – B

1. The first cell in EXCEL worksheet is labeled as

A. AA
B. A1
C. Aa
D. A0
5-2. What happens when dollar signs ($) are entered in a
cell address? (ex. $B$2:$B$10)
A. An absolute cell address is created.
B. Cell address will change when it is copied to another cell.
C. The sheet tab is changed.
D. The status bar does not display the cell address.
5-3. What are the tabs that appear at the bottom of each
workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
5-4. What is represented by the small, black square in the
lower-right corner of an active cell or range?
A. Copy handle
B. Fill handle
C. Insert handle
D. Border
5-5. In Excel, a Data Series is defined as what?
A. A type of chart.
B. A cell reference.
C. A collection of related data
D. A division of results
5-6. In Excel, the Fill Color button on the Formatting toolbar
is used for what?
A. To insert a background.
B. To add borders.
C. To select a distribution of figures.
D. To add shading or color to a cell range.
5-7. In help menu of Excel, which of the following tabs are
found?
A. Contents tab
B. Answer Wizard tab
C. Index tab
D. all of the above.
5-8. A __________ is a grid with labeled columns and rows.
A. Dialog box
B. Worksheet
C. Clipboard
D. Toolbar
5-9. The active cell:
A. is defined by a bold border around the cell.
B. Receives the data the user enters.
C. It is the formula bar.
D. Only A and B.
5-10. Which function is used to calculate depreciation, rates
of return, future values and loan payment amounts?
A. Logical
B. Math & Trigonometry
C. Statistical
D. Financial
================================
Answers
1 – B / 2 – A / 3 – D / 4 – B / 5 – C / 6 – D / 7 – D / 8 – B / 9 – D / 10 – D
================================

-1. Which language is used to create macros in Excel?

A. Visual Basic
B. C
C. Visual C++
D. Java
4-2. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
4-3. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
4-4. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
4-5. Which setting you must modify to print a worksheet
using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
4-6. What do you call the chart that shows the proportions
of how one or more data elements relate to another data
element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
4-7. The spelling dialog box can be involved by choosing
spelling from ________ menu.
A. insert
B. file
C. tools
D. view
4-8. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
4-9. To record a sequence of keystrokes and mouse actions
to play back later we use:
A. Media player
B. Sound Recorder
C. Calculator
D. Macro Recorder
4-10. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
===================================
Answers
1 – A / 2 – D / 3 – D / 4 – B / 5 – B / 6 – C / 7 – C / 8 – C / 9 – D / 10 – D
===================================

-1. Which Chart can be created in Excel?

A. Area
B. Line
C. Pie
D. All of the above
3-2. What will be the output if you format the cell containing
5436.8 as ‘#,##0.00′?
A. 5,430.00
B. 5,436.80
C. 5,436.8
D. 6.8
3-3. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
3-4. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
3-5. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. format, cells, number
D. Format, cells, alignment
3-6. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
3-7. What is the short cut key to highlight the entire
column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
3-8. In the formula, which symbol specifies the fixed
columns or rows?
A. $
B. *
C. %
D. &
3-9. Excel displays the current cell address in the ……….
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
3-10. What is the correct way to refer the cell A10 on sheet3
from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
===========================
Answers
1 – D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A
===========================
1. An Excel Workbook is a collection of …….
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
2-2. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
2-3. MS-EXCEL is based on ……….?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2
2-4. In EXCEL, you can sum a large range of data by simply
selecting a tool button called …..?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
2-5. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
2-6. To return the remainder after a number is divided by a
divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )
2-7. Which function is not available in the Consolidate dialog
box?
A. Pmt
B. Average
C. Max
D. Sum
2-8. Which is not the function of “Edit, Clear” command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
2-9. Microsoft Excel is a powerful………..
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
2-10. How do you rearrange the data in ascending or
descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
=========================
Answers
1 – D / 2 – D / 3 – A / 4 – C / 5 – D / 6 – C / 7 – A / 8 – C / 9 – B / 10 – A

1. Comments put in cells are called …..

A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
1-2. Comments can be added to cells using …..
A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View –> Comments
1-3. Which menu option can be used to split windows into
two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split
1-4. Getting data from a cell located in a different sheet is
called….
A. Accessing
B. Referencing
C. Updating
D. Functioning
1-5. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
1-6. Which elements of a worksheet can be protected from
accidental modification?
A. Contents
B. Objects
C. Scenarios
D. All of the above
1-7. A numeric value can be treated as label value if ……
precedes it.
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Tilde (~)
1-8. Concatenation of text can be done using
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)
1-9. Which area in an Excel window allows entering values
and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
1-10. Multiple calculations can be made in a single formula
using…..
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula
===========================
Answers
1 – B / 2 – B / 3 – C / 4 – B / 5 – B / 6 – D / 7 – A / 8 – D / 9 – C / 10 – B
===========================

1. Which is not a view for displaying a report object?

A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
5-2. The report footer section is most useful for displaying:
A. grand totals
B. Column headings
C. subtotals
D. page numbers
5-3. Which function can not be used for calculated controls
in a report?
A. SUM
B. AVG
C. MPT
D. COUNT
5-4. Which setting you must modify to print a report using
letterhead?
A. Group
B. Margin
C. Section
D. Orientation
5-5. In the datasheet formatting dialogue box, which is not
an option in the border and line styles dropdown list box?
A. datasheet border
B. datasheet underline
C. Column Header underline
D. vertical gridline
5-6. Which is not an option for customizing a datasheet
window?
A. change one row’s height
B. hide one column
C. change one column’s width
D. freeze one column
5-7. Which is not a command that is selectable from right
click menu of a field column?
A. Hide columns
B. Unhide columns
C. freeze columns
D. sort descending
5-8. What do you call the process of restricting the display
of records in a table to those matching a particular
criterion?
A. filtering
B. restricting
C. sorting
D. sifting
5-9. In the relationships window, what does the appearance
of symbols, such as 1 and the infinity symbol, at the
endpoints of a relationship line mean?
A. Referential integrity is enforced
B. Referential integrity isn’t enforced
C. An inner join is set
D. An outer join is set
5-10. Which of the following is not an action query?
A. add
B. delete
C. make-table
D. update

Answers
1 – A / 2 – A / 3 – C / 4 – B / 5 – C / 6 – A / 7 – B / 8 – A / 9 – A / 10 – A

1. In an application created using the database wizard, the

main menu is presented as a:
A. form, called a switchboard
B. report, called a menu
C. table, called a switchboard
D. query, called a menu
4-2. Which leads you through the process of creating a
table?
A. wizard
B. assistant
C. relation
D. coach
4-3. Which data type is better to use for storing the price of
an item?
A. Text
B. AutoNumber
C. Number
D. Currency
4-4. Which do you click to display the table’s primary key
and indexes in a separate window?
A. indexes button
B. primary key button
C. view datasheet button
D. view design button
4-5. After right click the field selector button, which do you
choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field
D. remove rows
4-6. Which tool is used to generate printout of a table’s
structure?
A. Analyzer
B. Designer
C. Documenter
D. Generator
4-7. Which of the following is not a legitimate section for
form objects?
A. Form detail
B. Group header
C. Form header
D. Page footer
4-8. The basic elements of a form or a report are called:
A. Controls
B. Objects
C. Windows
D. Properties
4-9. Which control types is most often associated with a
bound control?
A. command button
B. label
C. text box
D. list box
4-10. Which control type do you use to create a calculated
control?
A. command button
B. combo box
C. text box
D. list box

Answers
1 – A / 2 – A / 3 – D / 4 – A / 5 – B / 6 – C / 7 – B / 8 – A / 9 – C / 10 – C

1. What do you call a collection of records matching

parameters of a query?
A. Field
B. Record
C. Query
D. Dynaset
3-2. Which query do you use to answer the question “Which
employees earn more than $5000 a month”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
3-3. In which order do you place the field to sort a Dynaset
first by zipcode, then by lastname and then by firstname?
A. zipcode, firstname, lastname
B. firstname, lastname, zipcode
C. zipcode, lastname, firstname
D. can’t sort by multiple fields
3-4. What does the expression [detail] ! [product] * 1.30 do?
A. multiplies the contents of detail and product fields by 1.3
B. First divides detail by product and then multiplies by 1.3
C. multiplies the contents of detail in the product table by 1.3
D. multiplies the contents of product in the detail table by 1.3
3-5. Which criteria return only those addresses beginning
with the letter “K”?
A. address = “K”
B. address = “K*”
C. address = “K?”
D. address = “K#”
3-6. Which criteria do not return the position “Officer” as a
match?
A. position = “*ff*”
B. position = “O??icer”
C. position = “ ?ff*”
D. position = “O#r”
3-7. Which query do you use to answer the question “What
is the average salary of the employees”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
3-8. What is the result of ‘Select * from customer where
CustID>10 and CustID<100’ query?
A. display all customers with CustID from 10 to 100
B. display all customers with CustID above 10
C. display all customers with CustID below 100
D. display all customers with CustID from 11 to 99
3-9. How to make a date field DOB store the dates like
“2002/10/17” ?
A. By setting the input mask property to “yyyy/mm/dd”
B. By setting the format property to “yyyy/mm/dd”
C. By entering dates in yyyy, mm, dd order
D. none of the above
3-10. You have field ‘Sex’ of type Byte Number. How to limit
its value to 0 and 1 only?
A. By setting required to ‘Yes’
B. By using default value
C. By defining validation rule
D. By using format

Answers
1 – D / 2 – C / 3 – C / 4 – D / 5 – B / 6 – D / 7 – C / 8 – D / 9 – B / 10 – C
1. Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports
2-2. What determines a table’s sort order?
A. AutoNumber field
B. Index field
C. Field order
D. Primary key
2-3. What is an intersection of a row and a column?
A. Form
B. Cursor
C. Cell
D. Record
2-4. Which tool do you use to create a query object?
A. Database wizard
B. Simple filter wizard
C. Simple query wizard
D. Table query wizard
2-5. Which of the following is not a view for interacting with
a form object?
A. Datasheet view
B. Design view
C. Form view
D. Layout view
2-6. What is the purpose of indexing?
A. To reduce table size
B. To speedup data search
C. both A and B
D. none of the above
2-7. Which is the valid data type in Access?
A. Number
B. Text
C. Currency
D. All of the above
2-8. How many relations may exist between two tables in
databases?
A. 4
B. 3
C. 2
D. 1
2-9. What is the full form of SQL?
A. Sophisticated Question List
B. Structured Question List
C. Structured Query Language
D. Small Query Length
2-10. Which data type is better to use for storing phone
number in the following format “977-1-1234567”?
A. Text
B. AutoNumber
C. Number
D. Currency

Answers
1 – A / 2 – B / 3 – C / 4 – C / 5 – D / 6 – B / 7 – D / 8 – B / 9 – C / 10 – A

1. An organized collection of logically related data is known

as
A. Data
B. Meta data
C. Database
D. Information
1-2. In databases, Locking level is also called as
A. Granularity
B. S lock
C. X lock
D. Dead lock
1-3. Which of the following is not a database application?
A. dBase
B. Flash
C. FoxPro
D. Access
1-4. HSAM stands for ________
A. Hierarchic Sequential Access Method
B. Hierarchic Standard Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
1-5. Which of the following is not a logical database
structure?
A. Chain
B. Network
C. Tree
D. Relational
1-6. In a datasheet, what does each column represent?
A. Record
B. Field
C. Database
D. Table
1-7. In a datasheet, what does each row represent?
A. Record
B. Field
C. Database
D. Table
1-8. A ________ is a unit of information in a ________
A. record, field
B. field, record
C. data source, field
D. record, data source
1-9. What do you call a primary key field included in another
table?
A. Foreign key
B. Parent key
C. Child key
D. Index
1-10. Which type of field is incremented automatically?
A. Auto Elevate
B. AutoNumber
C. Auto Increment
D. Auto Value

Answers
1 – C / 2 – A / 3 – B / 4 – A / 5 – A / 6 – B / 7 – A / 8 – B / 9 – A / 10 – B
1 Which of the following Language that Computer can
Understand & Execute?
A. Machine Language
B. C Programming Language
C. Java Programming Language
D. None of the Above
9-2 Who is credited for using punch cards to control
patterns of a weaving machine?
A. Blaise Pascal
B. Herman Hollerith
C. Jacquard
D. Charles Babbage
9-3 Dedicated Computer means
A. Doesn’t have OS
B. Used by single person
C. Assigned to one and only one task
D. All of Above
9-4 Computer Keyboard can be classified as __________
Device?
A. Memory
B. Input
C. Output
D. Storage
9-5 Physical connection between Microprocessor Memory
and other parts is called _________
A. Path
B. Hub
C. Address bus
D. None of the above
9-6 Shortcut Notation for groups of four Binary Digits is
called ____________ Number System.
A. Unicode
B. Decimal
C. Binary
D. Hexadecimal
9-7 What is the full form of AT in the IBM PC-AT?
A. Applied Technology
B. Advance Technology
C. Additional Technology
D. None of the Above
9-8 ____________ has the shortest access times.
A. Cache Memory
B. Virtual Memory
C. Secondary Memory
D. All of the Above
9-9 In Computer terminology ‘CAD’ is stands for
A. Computer And Design
B. Computer Algorithm in Design
C. Computer Aided Design
D. None of the above
9-10 Which of the following is not an Input Device?
A. Touch Screen
B. Optical Scanners
C. Touch Pad
D. Mouse Pad

Answers
1 – A / 2 – C / 3 – C / 4 – B / 5 – C / 6 – D / 7 – B / 8 – A / 9 – C / 10 – D

-1. MICR stands for

A. Magnetic Ink Character Reader
B. Magnetic Ink Code Reader
C. Magnetic Ink Case Reader
D. None of the above
8-2. Which access method is used to access cassette tape?
A. Direct
B. Sequential
C. Both of the above
D. None of the above
8-3. EEPROM stands for
A. Electrically Erasable Programmable Read Only Memory
B. Electronic Erasable Programmable Read Only Memory
C. Easily Erasable Programmable Read Only Memory
D. Easily Erasable Programmable Read Only Memory
8-4. Which of the following memories need refresh?
A. SRAM
B. DRAM
C. ROM
D. All of the above
8-5. ASCII stands for
A. American Standard Code for Information Interchange
B. American Scientific Code for International Interchange
C. American Standard Code for Intelligence Interchange
D. American Scientific Code for Information Interchange
8-6. The output quality of a printer is measured by
A. Dot per sq. inch
B. Dot per inch
C. Dots printed per unit time
D. All of the above
8-7. Main storage is also called
A. Accumulator
B. Control Unit
C. Register Unit
D. Memory
8-8. Which is valid statement
A. 1 KB = 1024 Bytes
B. 1 MB = 1024 Bytes
C. 1 KB = 1000 Bytes
D. 1 MB = 1000 Bytes
8-9. After copying the content how many times can you
paste?
A. 1
B. 16
C. 32
D. Many
8-10. 1 nibble equals to
A. 1 bits
B. 2 bits
C. 4 bits
D. 8 bits

Answers
1 – A / 2 – B / 3 – A / 4 – B / 5 – A / 6 – B / 7 – D / 8 – A / 9 – D / 10 – C

-1. The Second Generation Computer was based on ________.

A. Vacuum Tube
B. Silicon Chips
C. Transistor
D. Bio Chips
7-2. The Third Generation Computer was made with ________.
A. Vacuum Tube
B. Discrete Components
C. IC
D. Bio Chips
7-3. The BIOS is the abbreviation of ________.
A. Basic Input Output System
B. Best Input Output System
C. Basic Input Output Symbol
D. Base Input Output System
7-4. What do you call a single point on a computer screen?
A. Cell
B. Element
C. Pixel
D. Bit
7-5. RJ45 UTP cable has ________ Cables.
A. 2 pair
B. 3 pair
C. 4 pair
D. 5 pair
7-6. Basic is ________ language.
A. a procedural
B. an object oriented
C. both A and B
D. none of the above
7-7. In ________ mode, the communication channel is used in
both directions at the same time?
A. Full-duplex
B. Simplex
C. Half-duplex
D. None of the above
7-8. How was the generation of computer classified?
A. by the device used in memory & processor
B. by the speed of computer
C. by the model of the computer
D. by the accuracy of computer
7-9. Who invented Analytical engine?
A. Blaise Pascal
B. George Bool
C. Charles Babbage
D. Dr. Herman Hollerith
7-10. Through which device the main components of the
computer communicate with each other?
A. Keyboard
B. System Bus
C. Monitor
D. Memory

Answers
1 – C / 2 – C / 3 – A / 4 – C / 5 – C / 6 – A / 7 – A / 8 – A / 9 – C / 10 – B
1. What do you call the programs that are used to find out
possible faults and their causes?
A. Operating system extensions
B. Cookies
C. Diagnostic software
D. Boot diskettes
6-2. Which programming languages are classified as low
level languages?
A. Basic, COBOL, FORTRAN
B. Prolog 2, Expert Systems
C. Knowledge based Systems
D. Assembly Languages
6-3. Which of the following is not anti-viruses software?
A. NAV
B. F-Prot
C. Oracle
D. McAfee
6-4. Which device is required for the Internet connection?
A. Joystick
B. Modem
C. CD Drive
D. NIC Card
6-5. What does DMA stand for?
A. Distinct Memory Access
B. Direct Memory Access
C. Direct Module Access
D. Direct Memory Allocation
6-6. Which of the following is a storage device?
A. Tape
B. Hard Disk
C. Floppy Disk
D. All of the above
6-7. When did John Napier develop logarithm?
A. 1416
B. 1614
C. 1641
D. 1804
6-8. A normal CD-ROM usually can store up to __________data?
A. 680 KB
B. 680 Bytes
C. 680 MB
D. 680 GB
6-9. MIS is designed to provide information needed for
effective decision making by?
A. Consumers
B. Workers
C. Foremen
D. Managers
6-10. What is a light pen?
A. Mechanical Input device
B. Optical input device
C. Electronic input device
D. Optical output device
.

Answers
1 – C / 2 – D / 3 – C / 4 – B / 5 – B / 6 – D / 7 – B / 8 – C / 9 – D / 10 – B

1. Punched cards were first introduced by

A. Powers
B. Pascal
C. Jacquard
D. Herman Hollerith
5-2. Computers built before the First Generation of
computers were:
A. Mechanical
B. Electro-mechanical
C. Electrical
D. None of these
5-3. Word length of a Personal Computer is ___
A. 4 bits
B. 8 bits
C. 16 bits
D. 64 bits
5-4. Size of the primary memory of a PC ranges between
A. 2KB to 8KB
B. 64KB & 256KB
C. 256KB & 640KB
D. None of these
5-5. CPU speed of a personal computer is
A. 32 KIPS
B. 100 KIPS
C. 1 MIPS
D. None of these
5-6. Programs are executed on the basis of a priority
number in a
A. Batch processing system
B. Multiprogramming
C. Time sharing
D. None of these
5-7. Cursor is a ____
A. Pixel
B. Thin blinking line
C. Pointing device
D. None of these
5-8. Operating system, editors, and debuggers comes
under?
A. System Software
B. Application Software
C. Utilities
D. None of the above
5-9. What is the first stage in software development?
A. Specification and design
B. Testing
C. System Analysis
D. Maintenance
5-10. What is System Analysis?
A. The design of the screen the user will see and use to enter or
display data
B. System analysis defines the format and type of data the program
will use
C. System Analysis involves creating formal model of the problem to
be solved
D. None of the above
=============================
Answers :
1 – D / 2 – B / 3 – B / 4 – C / 5 – B / 6 – B / 7 – B / 8 – A / 9 – C / 10 – C
=============================
1. Primary memory stores
A. Data alone
B. Programs alone
C. Results alone
D. All of these
4-2. EPROM can be used for
A. Erasing the contents of ROM
B. Reconstructing the contents of ROM
C. Erasing and reconstructing the contents of ROM
D. Duplicating ROM
4-3. Which device can understand difference between data &
programs?
A. Input device
B. Output device
C. Memory
D. Microprocessor
4-4. The contents of information are stored in
A. Memory data register
B. Memory address register
C. Memory arithmetic registers
D. Memory access register
4-5. Memory unit is one part of
A. Input device
B. Control unit
C. Output device
D. Central Processing Unit
4-6. Algorithm and Flow chart help us to
A. Know the memory capacity
B. Identify the base of a number system
C. Direct the output to a printer
D. Specify the problem completely and clearly
4-7. Which of the following is not a valid size of a Floppy
Disk?
A. 8″
B. 5 1/4″
C. 3 1/2″
D. 5 1/2″
4-8. The basic operations performed by a computer are
A. Arithmetic operation
B. Logical operation
C. Storage and relative
D. All the above
4-9. The earliest calculating devices are
A. Abacus
B. Clock
C. Difference Engine
D. None of these
4-10. Who built the first Mechanical Calculator
A. Joseph Marie Jacquard
B. John Mauchly
C. Blaise Pascal
D. Howard Aiken
=============================
Answers :
1 – D / 2 – C / 3 – D / 4 – A / 5 – D / 6 – D / 7 – D / 8 – D / 9 – A / 10 – C
=============================

1. Primary memory stores

A. Data alone
B. Programs alone
C. Results alone
D. All of these
4-2. EPROM can be used for
A. Erasing the contents of ROM
B. Reconstructing the contents of ROM
C. Erasing and reconstructing the contents of ROM
D. Duplicating ROM
4-3. Which device can understand difference between data &
programs?
A. Input device
B. Output device
C. Memory
D. Microprocessor
4-4. The contents of information are stored in
A. Memory data register
B. Memory address register
C. Memory arithmetic registers
D. Memory access register
4-5. Memory unit is one part of
A. Input device
B. Control unit
C. Output device
D. Central Processing Unit
4-6. Algorithm and Flow chart help us to
A. Know the memory capacity
B. Identify the base of a number system
C. Direct the output to a printer
D. Specify the problem completely and clearly
4-7. Which of the following is not a valid size of a Floppy
Disk?
A. 8″
B. 5 1/4″
C. 3 1/2″
D. 5 1/2″
4-8. The basic operations performed by a computer are
A. Arithmetic operation
B. Logical operation
C. Storage and relative
D. All the above
4-9. The earliest calculating devices are
A. Abacus
B. Clock
C. Difference Engine
D. None of these
4-10. Who built the first Mechanical Calculator
A. Joseph Marie Jacquard
B. John Mauchly
C. Blaise Pascal
D. Howard Aiken
=============================
Answers :
1 – D / 2 – C / 3 – D / 4 – A / 5 – D / 6 – D / 7 – D / 8 – D / 9 – A / 10 – C

1. Which device is used as the standard pointing device in a

Graphical User Environment?
A. Keyboard
B. Mouse
C. Joystick
D. Track ball
3-2. Which number system is usually followed in a typical
32-bit computer?
A. 2
B. 10
C. 16
D. 32
3-3. Which number system is usually followed in a typical
32-bit computer?
A. Binary
B. Decimal
C. Hexadecimal
D. Octal
3-4. Which of the following is not an output device?
A. Scanner
B. Printer
C. Flat Screen
D. Touch Screen
3-5. Which of the following devices have a limitation that we
can only store information to it but cannot erase or modify
it?
A. Floppy Disk
B. Hard Disk
C. Tape Drive
D. CDROM
3-6. Which technology is used in Compact disks?
A. Mechanical
B. Electrical
C. Electro Magnetic
D. Laser
3-7. Which of the following storage devices can store
maximum amount of data?
A. Floppy Disk
B. Hard Disk
C. Compact Disk
D. Magneto Optic Disk
3-8. Which of the following is the largest manufacturer of
Hard Disk Drives?
A. IBM
B. Seagate
C. Microsoft
D. 3M
3-9. The programs which are as permanent as hardware and
stored in ROM is known as
A. Hardware
B. Software
C. Firmware
D. ROM ware
3-10. Memory is made up of
A. Set of wires
B. Set of circuits
C. Large number of cells
D. All of these
=============================
Answers
1 – B / 2 – A / 3 – A / 4 – A / 5 – D / 6 – D / 7 – B / 8 – B / 9 – C / 10 – C
1. Which device is used as the standard pointing device in a
Graphical User Environment?
A. Keyboard
B. Mouse
C. Joystick
D. Track ball
3-2. Which number system is usually followed in a typical
32-bit computer?
A. 2
B. 10
C. 16
D. 32
3-3. Which number system is usually followed in a typical
32-bit computer?
A. Binary
B. Decimal
C. Hexadecimal
D. Octal
3-4. Which of the following is not an output device?
A. Scanner
B. Printer
C. Flat Screen
D. Touch Screen
3-5. Which of the following devices have a limitation that we
can only store information to it but cannot erase or modify
it?
A. Floppy Disk
B. Hard Disk
C. Tape Drive
D. CDROM
3-6. Which technology is used in Compact disks?
A. Mechanical
B. Electrical
C. Electro Magnetic
D. Laser
3-7. Which of the following storage devices can store
maximum amount of data?
A. Floppy Disk
B. Hard Disk
C. Compact Disk
D. Magneto Optic Disk
3-8. Which of the following is the largest manufacturer of
Hard Disk Drives?
A. IBM
B. Seagate
C. Microsoft
D. 3M
3-9. The programs which are as permanent as hardware and
stored in ROM is known as
A. Hardware
B. Software
C. Firmware
D. ROM ware
3-10. Memory is made up of
A. Set of wires
B. Set of circuits
C. Large number of cells
D. All of these
=============================
Answers
1 – B / 2 – A / 3 – A / 4 – A / 5 – D / 6 – D / 7 – B / 8 – B / 9 – C / 10 – C

1. FORTRAN programming language is more suitable for ……

A. Business Applications
B. Marketing Applications
C. Scientific Applications
D. None of the above
1-2. Mostly which of the following device is used to carry
user files?
A. Floppy Disk
B. Hard Disk
C. RAM
D. CDROM
1-3. Which device is used to backup the data?
A. Floppy Disk
B. Tape
C. Network Drive
D. All of the above
1-4. In order to play and hear sound on a computer, one
needs:
A. a sound card and speakers
B. a microphone
C. all of them required
D. none of them required
1-5. Which of the following are the cheapest memory
devices in terms of Cost/Bit?
A. Semiconductor memories
B. Magnetic Disks
C. Compact Disks
D. Magnetic Tapes
1-6. In a computer _____ is capable to store single binary bit.
A. Capacitor
B. Flip flop
C. Register
D. Inductor
1-7. A set of flip flops integrated together is called ____
A. Counter
B. Adder
C. Register
D. None of the above
1-8. Which of the following are the best units of data on an
external storage device?
A. Bits
B. Bytes
C. Hertz
D. Clock cycles
1-9. A register organized to allow to move left or right
operations is called a ____
A. Counter
B. Loader
C. Adder
D. Shift register
1-10. Which of the following have the fastest access time?
A. Semiconductor Memories
B. Magnetic Disks
C. Magnetic Tapes
D. Compact Disks
=============================
Answers
1 – C / 2 – A / 3 – D / 4 – A / 5 – C / 6 – B / 7 – C / 8 – B / 9 – D / 10 – A
=============================