The Chennai School Of banking

COMPUTER KNOWLEDGE Microsoft Office

Question No : 1

Microsoft office was developed by ______ in ______
(1) Microsoft Inc, 1970s
(2) Microsoft Inc, 1980s
(3) Sun Microsoft, 1980s
(4) Sun Microsoft Inc, 1970s
(5) None of these

Question No : 2

Which of the following is a basic software of MS Office?
(1) MS-Word
(2) MS-PowerPoint
(3) MS Excel
(4) MS Access
(5) All of these

Question No : 3

MS Word is a
(1) word processing software
(2) tabular data formatting software
(3) presentation software
(4) database management system
(5) E-mail client

Question No : 4

E-mail client is the feature of
(1) MS Word
(2) MS Excel
(3) MS Access
(4) MS Outlook
(5) MS PowerPoint

Question No : 5

The first bar of MS Word is
(1) menu bar
(2) status bar
(3) title bar
(4) formatting toolbar
(5) standard toolbar

Question No : 6

Shortcut for displaying the full page as they are printed.
(1) Ctrl + F1
(2) Ctrl + F2
(3) Shift + F1
(4) Shift + F2
(5) Alt + F2

Question No : 7

The letter and number of the intersecting column and row is the
(1) cell location
(2) cell position
(3) cell address
(4) cell coordinates     
(5) cell contents

Question No : 8

By default on which page the header or footer is printed?
(1) On first page
(2) On alternative page
(3) On every page
(4) All of the above
(5) None of the above

Question No : 9

Which bar is usually located below title bar that provides categorized options?
(1) Menu bar
(2) Status bar
(3) Tool bar
(4) Scroll bar
(5) None of these

Question No : 10

Which is the shortcut key to display open dialog box?
(1) F12
(2) Shift + F12
(3) Alt + F12
(4) Ctrl + F12
(5) None of these

Question No : 11

Which of the following will you use as an option for saving a file?
(1) Save option from file menu
(2) Save button on standard toolbar
(3) Pressing Ctrl + S
(4) All of the above
(5) None of these
 

Question No : 12

Where you can find the horizontal split bar on MS Word screen?
(1) On the left of horizontal scroll bar
(2) On the right of horizontal scroll bar
(3) On the top of vertical scroll bar
(4) On the bottom of vertical scroll bar
(5) None of the above

Question No : 13

Alignment buttons are available on which toolbar?
(1) Status
(2) Standard
(3) Formatting
(4) All of these
(5) None of these

Question No : 14

How many ways you can save a document?
(1) 3    
(2) 4    
(3) 5    
(4) 6    
(5) 8

Question No : 15

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
 

Question No : 16

 Which extension is given to word document by default?
(1) .exe
(2) .com          
(3) .doc           
(4) All of these
(5) None of these
 

Question No : 17

Header is
(1) any text printed at the top of every page
(2) any graphics printed at the top of every page
(3) any text or graphics printed at the top of a particular page
(4) any text or graphics printed at the top of every page
(5) None of the above

Question No : 18

You can start Microsoft Word by using which button?
(1) New
(2) Start
(3) Program
(4) All of these
(5) None of these

Question No : 19

Which of the following is not an option of edit menu?
(1) Cut
(2) Copy
(3) Paste
(4) Page setup
(5) None of these

Question No : 20

When you start MS Word, the opening document has the name as
(1) DOC 1
(2) Document 1
(3) Document
(4) Workbook
(5) Task book

Question No : 21

After selecting the ‘Replace’ option from the Edit menu, the following dialog box appears.
(1) replace
(2) find and replace
(3) find
(4) edit
(5) None of these

Question No : 22

Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides?
(1) Slide sorter
(2) Slide show
(3) Slide master
(4) Notes page
(5) Slide design

Question No : 23

Blinking point which shows your position in the text is called?
(1) cursor
(2) blinker
(3) position
(4) states
(5) place

Question No : 24

In word, you can force a page break
(1) by positioning your cursor at the appropriate place and pressing the F1 key
(2) by positioning your cursor at the appropriate place and pressing the Ctrl + Enter
(3) by using the insert/section break
(4) by changing the font size of your document
(5) None of the above
 

Question No : 25

When cutting and pasting the item cut is temporarily stored in
(1) ROM
(2) hard drive
(3) diskette
(4) dashboard
(5) clipboard
 

Question No : 26

Which of the following can be used to select the entire document?
(1) Ctrl + A
(2) Alt + F5
(3) Shift + A
(4) Ctrl + K
(5) Ctrl + H
 

Question No : 27

The ______ defines the appearance and shape of letters, numbers and special characters.
(1) font
(2) font size
(3) point
(4) paragraph formatting
(5) None of the above
 

Question No : 28

Microsoft office word is a (n)
(1) area in the computer’s main memory in which Microsoft office text files are stored temporarily
(2) program included with Windows 2000 that can be used only to create or edit text files, smaller than 64k, that do not required formatting
(3) classified password that prevents unauthorized users from accessing a protected Microsoft office item or document
(4) full featured word processing program that can be used to create and revise professional looking documents easily
(5) None of the above
 

Question No : 29

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
 

Question No : 30

In MS-Word, the default alignment for paragraph is
(1) left aligned
(2) centered
(3) right aligned
(4) justified
(5) None of these
 

Question No : 31

Which of the following is not available on the ruler of MS Word screen?
(1) Left indent
(2) Right indent
(3) Centre indent
(4) All of these
(5) None of these
 

Question No : 32

To save an existing document with a different file name, click
(1) save button on the standard toolbar
(2) save on the file menu
(3) save as button on the standard toolbar
(4) save as on the file menu
(5) None of the above

Question No : 33

 Insert date, format page number and insert auto text are buttons on the ____ toolbar.
(1) formatting
(2) header and footer
(3) standard
(4) edit
(5) None of these
 

Question No : 34

To increase the line spacing, use the ______ shortcut keys.
(1) Ctrl  + L
(2) Ctrl + E
(3) Ctrl + I
(4) Ctrl + M
(5) None of these
 

Question No : 35

Word has a list of predefined typing, spelling, capitalization and grammar errors that ____ can detect and correct.
(1) auto entry
(2) auto correct
(3) auto add
(4) auto spell
(5) auto word
 

Question No : 36

Borders can be applied to
(1) cells
(2) paragraph
(3) text
(4) All of these
(5) None of these
 

Question No : 37

Which of the following characteristics is used to compute dynamically the results from Excel data?
(1) Go to
(2) Table
(3) Chart
(4) Diagram
(5) Formula and function
 

Question No : 38

What is the default left margin in word document?
(1) 1.0
(2) 1.15
(3) 1.5
(4) 2.0
(5) 2.5
 

Question No : 39

In this chart, only one data series can be plotted
(1) pie
(2) line
(3) bar
(4) column
(5) None of these
 

Question No : 40

This chart shows the relationship of parts to a whole
(1) pie
(2) line
(3) stacked bar
(4) embedded
(5) None of these
 

Question No : 41

Which of the following is not a font style?
(1) Bold
(2) Italics
(3) Regular
(4) Super script
(5) Bold-Italics
 

Question No : 42

It is a software tool that lets one enter, calculate, manipulate set of numbers
(1) MS-Word
(2) spreadsheet
(3) slide sheet
(4) All of the these
(5) None of these
 

Question No : 43

It is a grid of cells made up of horizontal and vertical columns
(1) worksheet
(2) sheet
(3) excel sheet
(4) page
(5) work book
 

Question No : 44

Group of worksheets is known by
(1) folder
(2) document
(3) workbook
(4) books
(5) files
 

Question No : 45

Which one is the example of spreadsheet package?
(1) VisiCalc
(2) Unity
(3) Ada
(4) Snowball
(5) None of these
 

Question No : 46

Portrait and landscape are
(1) page orientation                      
(2) paper size                                   
(3) page layout           
(4) page margin                     
(5) page gap
 

Question No : 47

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
 

Question No : 48

To select the current column press
(1) Ctrl + Spacebar
(2) Ctrl + B
(3) Shift + Enter
(4) Ctrl + Enter
(5) Ctrl + Shift
 

Question No : 49

Scatter chart is also known as
(1) XX chart
(2) YX chart
(3) XY chart
(4) YY chart
(5) XZ chart
 

Question No : 50

The extension of saved file in MS-Excel is
(1) .XIS
(2) .XAS
(3) .XLSX
(4) .XLL
(5) .LXS
 

Question No : 51

 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

 

Question No : 52

In Microsoft PowerPoint two kinds of sound effect files 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 above

Question No : 53

A chart placed in a worksheet is called
(1) formatting chart
(2) embedded chart
(3) aligning chart
(4) hanging chart
(5) None of the above

 

Question No : 54

Which file format can be added to a PowerPoint show?
(1) .jpg
(2) .gif
(3) .wav
(4) All of these
(5) None of the above

Question No : 55

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
 

Question No : 56

The cell having bold boundary is called
(1) relative
(2) active
(3) absolute
(4) mixed
(5) passive
 

Question No : 57

Cell address A4 in a formula means it is an
(1) mixed cell reference
(2) absolute cell reference
(3) relative cell reference
(4) All of the above
(5) None of the above

 

Question No : 58

Which of the following is an active cell in excel?
(1) Current cell
(2) Formula
(3) Range
(4) Cell address
(5) None of these
 

Question No : 59

In Excel, an active can be represented by
(1) 4A
(2) A4
(3) A$4
(4) $A$4
(5) $A4
 

Question No : 60

Which option will we use to give heading in the form?
(1) Label
(2) Text box
(3) Option group
(4) Insert
(5) None of these
 

Question No : 61

The maximum zoom percentage in MS Power Point is
(1) 100%
(2) 200%
(3) 400%
(4) 500%
(5) None of these
 

Question No : 62

 In the context of animations, what is a trigger?
(1) An action button that advances to the next slide
(2) An item on the slide that performs an action when clicked
(3) The name of a motion path
(4) All of the above
(5) None of the above

 

Question No : 63

How are the data organized in a spreadsheet?
(1) Lines and spaces
(2) Layers and planes
(3) Height and width
(4) Rows and columns
(5) None of these

 

Question No : 64

Which of the following views is the best view to use when setting transition effects for all slides in presentation?
(1) Slide sorter view
(2) Notes pages view
(3) Slide view
(4) Outline view
(5) None of the above

 

Question No : 65

In order to include picture data type must be
(1) OLE
(2) hyperlink
(3) Yes/No
(4) picture
(5) None of these
 

Question No : 66

Which command brings you to the first slide in your presentation?
(1) Next slide button
(2) Page up
(3) Ctrl + Home
(4) Ctrl + End
(5) None of these

 

Question No : 67

 In Excel, charts are created using which option?
(1) Pivot table
(2) Chart wizard
(3) Pie chart
(4) Bar chart
(5) None of these

Question No : 68

Which of the following allow you to select more than one slide in a presentation?
(1) Alt + click each slide
(2) Shift + drag each slide
(3) Shift + click each slide
(4) Ctrl + click each slide
(5) None of the above
 

Question No : 69

The basic unit of a worksheet into which you enter data in excel is called a
(1) tab
(2) cell
(3) box
(4) range
(5) None of these
 

Question No : 70

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 documents
(4) All of the above
(5) None of the above

Question No : 71

 In Excel, this is a prerecorded formula that provides a shortcut for complex calculations
(1) value
(2) data series
(3) function
(4) field
(5) None of these
 

Question No : 72

 Which of the following should be used to move a paragraph from one place to another in a word document?
(1) Copy and paste
(2) Cut and paste
(3) Delete and retype
(4) Find and replace
(5) None of these

Question No : 73

In PowerPoint, the Header and Footer button can be found on the insert tab in what group?
(1) Illustrations group
(2) Object group
(3) Insert group
(4) Tables group
(5) None of these

Question No : 74

A _______ is an additional set of commands that the computer displays after you make a select from the main menu.
(1) dialog box
(2) sub menu
(3) menu selection
(4) All of these
(5) None of these

Question No : 75

In Excel, _____ allows users to bring together copies of workbooks that other users gave worked on independently
(1) copying
(2) merging
(3) pasting
(4) compiling
(5) None of these

Question No : 76

Pressing Ctrl + F9 in Excel
(1) prints 9 worksheets
(2) insert 9 cells at the current location
(3) prints a sheet
(4) prints 9 followed by spaces
(5) None of these
 

Question No : 77

Which of the following justification align the text on both the sides left and right of margin?
(1) Right
(2) Justify
(3) Both sides
(4) Balanced
(5) None of these
 

Question No : 78

Cell 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
 

Question No : 79

Pie charts are typically created by using which of the following?
(1) Browser software
(2) Word processing software
(3) Database software
(4) Desktop publishing software
(5) Spreadsheet software

Question No : 80

What is the default size of the data type in MS Access?
(1) 50
(2) 60
(3) 70
(4) 80
(5) None of these
 

Question No : 81

To move the text from its original position to another position without deleting it is called
(1) scrolling
(2) searching
(3) moving
(4) copying
(5) halting

Question No : 82

Attributes can be defined for
(1) entity
(2) switch board
(3) macro
(4) pages
(5) None of these

Question No : 83

MS Excel is used for
(1) letter writing
(2) spreadsheet calculation
(3) presentation
(4) painting
(5) None of the above
 

Question No : 84

= Sum (61 : 610) is an example of a
(1) function
(2) formula
(3) cell address
(4) value
(5) None of these
 

Question No : 85

 ____ shows how the contents on printed page will appear with margin, header and footer.
(1) Draft
(2) Full screen reading
(3) Outline
(4) Page layout
(5) None of these
 

Question No : 86

How many types of relationships are there in MS-Access?
(1) 3
(2) 4
(3) 5
(4) 6
(5) None of these
 

Question No : 87

A word processor would be used best to
(1) paint a picture
(2) draw a diagram
(3) type a story
(4) work out income and expenses
(5) None of the above

Question No : 88

In order to choose the font for a sentence in a word document
(1) select font in the format menu
(2) select font in the edit menu
(3) select font in the tools menu
(4) select font in the view menu
(5) None of the above
 

Question No : 89

The shortcut key to print documents is
(1) Ctrl + D
(2) Ctrl + A
(3) Ctrl + B
(4) Ctrl + C
(5) Ctrl + P

Question No : 90

What is the extension of PowerPoint in Microsoft Office 2007?
(1) .ppt
(2) .pptx
(3) .ppx
(4) .ptx
(5) .pt
 

Question No : 91

All of the following terms are related to spreadsheet software except
(1) worksheet
(2) cell
(3) formula
(4) virus detection
(5) None of these

Question No : 92

There are a total of ____ actions button in PowerPoint.
(1) 12
(2) 15
(3) 16
(4) 18
(5) None of these
 

Question No : 93

Which of the following is a DBMS software?
(1) Access
(2) Excel
(3) Word
(4) PowerPoint
(5) None of these
 

Question No : 94

Which of the following displays the buttons for changing text style, alignment and size?
(1) Standard toolbar
(2) Status bar
(3) Drawing toolbar
(4) Formatting toolbar
(5) None of the above
 

Question No : 95

Which of the following is not a term pertaining to word?
(1) Delete
(2) Edit
(3) Copy
(4) Slide show
(5) None of these
 

Question No : 96

Which key on the keyboard can be used to view slide show?
(1) F1
(2) F2
(3) F5
(4) F10
(5) None of these
 

Question No : 97

PowerPoint provides _____ number of layouts for use with blank presentation.
(1) 20
(2) 22
(3) 24
(4) 26
(5) None of these
 

Question No : 98

What is the shortcut key for centering the text selected by the user in word?
(1) Ctrl + A
(2) Ctrl + B
(3) Ctrl + C
(4) Ctrl + D
(5) Ctrl + E
 

Question No : 99

What does an electronic spreadsheet consist of?
(1) Rows
(2) Columns
(3) Cells
(4) All of these
(5) None of these
 

Question No : 100

A red wavy line under a word indicates that the word.
(1) Is too long for the line of text
(2) Is not in the dictionary file and therefore might be spelt incorrectly
(3) Is not appropriate for that particular sentence
(4) Is a verb
(5) None of these

Question No : 101

 In MS- Word WYSIWYG stands for?
(1) Preview
(2) What you see is what you get
(3) What you see is where you get
(4) Print
(5) None of these
 

Question No : 102

To reload a web page, press the button.
(1) Redo
(2) Reload
(3) Restore
(4) Ctrl
(5) Refresh
 

Question No : 103

What is the file extension of MS-Power point?
(1).exe
(2) .xls
(3).ppt
(4) .pst
(5) None of these
 

Question No : 104

Microsoft office Latest Version is _________
(1) 2013
(2) 2016
(3) 2014
(4) 2015
(5) None of these

Question No : 105

To move to the previous worksheet, we press:
(1) Alt + PgUp
(2) Ctrl + PgUP
(3) Ctrl + PgDn
(4) Shift + Tab
(5) None of these

Question No : 106

If you press _________, the cell accepts your typing as its contents.
(1) Enter
(2) Ctrl + Enter
(3) Tab
(4) Insert
(5) None of these