microsoft office related cpct objective question and answer

 Microsoft office related cpct objective question and answer

1) OpenOffice  Calc is an  Example of :
A) Spreadsheet
B) Word Processor
C) Presentation Software
D) Database
Ans:- A)  Spreadsheet

2) Which of the following features is generally used to create lables that span multiple columns?
A) Wrap Text
B) Merge & Center
C) Text Direction
D) Shrink to Fit
Ans:- B) Merge & Center

3) Assuming numeric values in the cells A1 and A2 as 10 and 15 respectively, the value of the excel expression =IF(A1-A2,”A” ,”B”)is:
A) 5
B) 5
C) A
D) B
Ans: C) A

4) Press ---------------Key to Cancel the value of a cell being edited.
A) Enter
B) Tab
C) Esc
D) Ctrl
Ans: C) Esc

5) The Display value of a cell containing the Excel expression =  10-10/2+8 is:
A) 0
B) 9
C) 10
D) 13
Ans:- D) 13

6) Total  number of layers in OSI Reference Model is:
A) 4
B) 5
C) 7
D) 9
Ans:-  C) 7

7) Which of the following is a web Search Engine Developed by Microsoft?
A) Yahoo!
B) Altavista
C) Bing
D) Google
Ans:  C)  Bing

8) Assuming the contents of the cells A1,B1, and C1 as 16, 8 and 2 respectively, the display value of the cell containing the formula = $A$1/$B$1/$C$1 is:
A) 1
B) 4
C) #DIV/0!
D) #VALUE!
Ans:- A)  1

9) For Sorting Excel data, which of the following is NOT a valid option for “Sort on” Field in the “Sort” Window?
A) Values
B) Cell Colour
C) Font Colour
D) Cell Width
Ans:- D) Cell Width

10) Which of the following Excel tools can be used if you know the result, but you are not sure what input values will be required in the formula to get that result?
A) Scenario Manager
B) Goal Seek
C) Data Table
D) Data Validation
Ans:-  B) Goal Seek

11) Which of the following is a link (or reference), which is used to access an item stored somewhere else in the computer system?
A) Bitmap
B) Image
C) Folder
D) Shortcut
Ans: D) Shortcut

12) Which of the following commands is used to launch Registry Editor?
A) Registry
B) RegEdit
C) RegistryEdit
D) RegistryEditor
Ans: B) RegEdit

13) Which of the following is a shortcut key for quick access to the Windows Task Manager?
A) Ctrl+Shift
B) Ctrl+Shift+Tab
C) Ctrl+Tab
D) Ctrl+Shift+Esc
Ans: D) Ctrl+Shift+Esc

14) Which of the following protects your computer from Viruses?
A) File Manager
B) Antivirus
C) Disk Cleaner
D) Disk Defragmenter
Ans: B) Antivirus

15) which of the following is NOT an Antivirus?
A) Symantec Norton
B) McAfee
C) FileZilla
D) Kaspersky
Ans:  C) FileZilla

16) Which of the following is NOT a Valid Option for Windows Power Saver Plan?

A) Dim the Display
B) Turn off the Display
C) Turn off the Computer
D) Put the Computer to sleep
Ans: C) Turn off the Computer

17) Which of the following can be used to open Command Prompt in Windows for executing text-based commands?
A) CMD
B) Commands
C) Execute
D) Run
Ans: A) CMD

18) Which of the following is used to change setting and customize the functionalities of your Computer?
A) Control Panel
B) Character Map
C) Resource Monitor
D) Task Scheduler
Ans: A) Control Panel

19) Which of the following helps to protect your Computer from hackers and malicious Software?
A) Backup and Restore
B) Windows Explorer
C) Windows Firewall
D) Snipping Tool
Ans:-D) Snipping Tool


20) Which of the Following file Options allows to save the current work to a different file than the original name?
A) New
B) Save
C) Save as
D) Print
Ans: C) Save as

21) A File name has two parts separated by a dot. The part preceding the dot is called ……….., whereas the part following the dot is called……………………….
A) Extension, Primary Name
B) Precedent, Extension
C) Primary Name, Extension
D) Primary Name, Antecedent
Ans:  Primary Name, Extension

22) Which of the following is an archive file formate that supports lossless data compression?
A) PDF
B) ZIP
C) PS
D) JPG
Ans: B) ZIP

23) In Windows Explorer, If there is no Plus Sign to the left of a folder icon, it mean that the folder does not have any?
A) SubFolders
B) Zip File
C) Doc File
D) PDF File
Ans: A) Sub Folders

24) Which of the following folder view is most suitable for the folders that contain pictures?
A) Thumbnail View
B) List View
C) Details View
D) Tiles View
Ans: A) Thumbnails View

25) which of the following is NOT a Word Processor?
A) OpenOffice Writer
B) MS-Word
C) OpenOffice Calc
D) NotePad
Ans: C) OpenOffice Calc

26) To Automatically move to the next line when one line is filled with text is called:
A) Drop Cap
B) Text Alignment
C) Word Wrap
D) Hyphenation
Ans:-  C) Word Wrap

27) -is used to Copy, Whereas …………….is used to cut the selected Texts.
A) Ctrl+C, Ctrl+X
B) Ctrl+C,  Alt+X
C) Alt+C,  Ctrl+X
D) Ctlr+C, Alt+Ctrl+X
Ans:- A) Ctrl+C, Ctrl+X

28) Which of the following is menu that is free-floating and usually appears next to the mouse point?
A) Scroll Bar
B) Dialog
C) Toolbar
D) Popup
Ans: D) Popup

29) Which of the following is NOT a Valid font Style in MS-Word?
A) Strong
B) Bold
C) Italic
D) Regular
Ans:- A) Strong

30) Which of the following is the default font size unit in MS-Word?
A) Point
B) Pica
C) Centimeter
D) Inch
Ans:A)  Point

31) Which of following is NOT a spreadsheet?
A) OpenOffice Cal
B) OpenOffice Impress
C) MS-Excel
D) Lotus 1-2-3
Ans: B)  OpenOffice Impress

32) The Address of the cell at the intersection of 31st Row and 20th Column is:
A) S31
B) 31S
C) 31T
D) T31
Ans: D) T31

34) Assuming numeric values in the cells A1 to A5 as 1, 2, 3, 4, and 5 respectively, The Value of the excel expression =Sum(A1:A3,A5) is:
A) 6
B) 11
C) 4
D) 15
Ans:- B) 11

35) The Display vlaue of the cell containing the Excel expression =55/0 is:
A ) #Div/0!
B) #Name?
C) #Infinity
D) 0
Ans:- A) #Div/0!

36) Assuming the contents of the cells A1 and B1 as 4 and 3 respectively, the display value of the cell containing the formula =A1^B1 is:
A) 12
B) 81
C) 64
D) 7
Ans: C) 64

37) After hiding the first row and first column of a worksheet, the address of th first visible cell (appearing at top-left position) will be:
B2
2B
A1
1A
Ans: A) B2


38) If cells A1,A2,A3,B1,B2,B3,C1,C2, and C3 contain the natural numbers 1 to 9 (in order), then the display value of the cell containing the formula = Sum(A1:B2,C3) is:
A) 15
B) 17
C) 21
D) 45
Ans:-  C) 21

39) Internet is one of the best known example of :
A) WAN
B) LAN
C) MAN
D) SAN
Ans:- A) WAN

40) Which of the following is NOT an alternate nam to HTTPS?
A) HTTP over TLS
B) HTTP Service
C) HTTP Secure
D) HTTP over SSL
Ans:- B) HTTP Service

41) With Respect to the World Wide Web, URL Stands for:
A) Uninterrupted Resource Locator
B) Unique Resource Replicator
C) Uniform Resource Locator
D) Uniform Router Location
Ans:- C) Uniform Resource Locator

42) In Which of the following network topologies, computers and other communication devices are connected in a continuous loop and each node serves as a repeater?
A) Star
B) Ring
C) Bus
D) Mesh
Ans:- B) Ring

43) Which of the following OSI Layers ensures the delivery of complete message?
A) Presentation Layer
B) Transport Layer
C) Network layer
D) Physical layer
Ans:- B) Transport Layer

44) Private owned local area network of an organization that uses TCP/IP and other Internet standard protocols is called:
A) Intranet
B) Internet
C) Extranet
D) VPN
Ans:- A) Intranet


45) Shortcut key to open a new document is:
A) Ctrl+N
B) Alt+N
C) Alt+Ctrl+F
D) Ctrl+F
Ans: A) Ctrl+N

46) Clicking Simultaneously three times in a paragraph will select:
A) The Whole paragraph
B) The First Word of the paragraph
C) The First Sentence of the paragraph
D) The Last Sentence of the paragraph
Ans: A)  The Whole paragraph