Ms Office Mcq Question Part 1

Ms Office Mcq Include All topic which is Ms Word, Ms Excel, and Ms Powerpoint. These all question related to your Ms Office Exam, CCC Exam, Computer Basic Exam, Interview Preparation.

QUIZ START

Results

Congratulation!!! You have score….

Good Job!! but Try Again.

HD Quiz powered by harmonic design

#1. Page Orientation can be portrait or ______________________.

Straight

Landscape

#2. In MS-Excel , "Insert Sheet Rows" option is available in __________________tab.

Home

View

Formulas

#3. In MS-PowerPoint , "Transition Sound" option is available in__________________ tab.

Home

Insert

Animations

#4. In MS-Excel , "Page Layout View" option is available in __________________tab.

Home

Insert

View

#5. In MS-PowerPoint , "Slide Sorter" option is available in __________________tab.

View

Animations

Insert

#6. By default work book contains _______________.

3 worksheets Or 1 Sheets

16 Worksheets

18 worksheets

#7. MS-Word allows creation of _______________type of documents by default .

Txt

Wpf .

Docx.

#8. In MS-Excel , "Sort Z to A" option is available in __________________ tab.

Data

Home

Insert

#9. In MS-Excel , "Get External Data from Web" option is available in__________________ tab.

Insert

Home

Data

#10. ROM, CPU and RAM are installed on _______________ .

Main board

Hard disk

Chip guard

#11. Select Step for Create New Folder on Desktop.

All Programs -> Accessories -> New Folder

All These given Option

Right Click on Desktop -> New -> Folder

File -> New -> New Folder

#12. In MS-Excel , "Allow Users to Edit Ranges" option is available in__________________ tab.

Insert

Review

Home

#13. Spreadsheets should be best used for ___________________.

Calculation

Writing Letters

Presentation

#14. In MS-PowerPoint , "Slide Orientation" option is available in__________________ tab.

Insert

Animations

Design

#15. In MS-Excel , "Name Manager" option is available in __________________tab.

Insert

Formulas

Home

#16. In MS-Excel , "Previous Comment” option is available in __________________tab.

Review

Home

Insert

#17. To create Simple Text Document _______________Program is used

Wordpad

Notepad

Paint

#18. DVD-Drive can store approximately ___________________ of information.

4.7 GB

1.44 MB

700 MB

#19. Extension of WordPad File is _______________. .

Doc/Rtf .

.Xls

Bmp

#20. The short cut key for freeze columns is ______________.

Alt +C

Alt +Fe

Alt +OZ

#21. In MS-Excel , "Align Text Bottom" option is available in __________________tab.

Home

Formulas

View

#22. In MS-PowerPoint , "Record Narration" option is available in__________________ tab.

Insert

Slide Show

Animations

#23. In Excel, Rows are labelled as ______

A1, A2, etc

1,2,3 etc

A, B, C, etc

a-1, b-1, etc

#24. In MS-Excel , "Zoom 100%" option is available in __________________ tab.

View

Insert

Home

#25. In MS-Excel , "Percent Style" option is available in __________________ tab.

Home

View

Formulas

#26. _______________is an output device

Mouse

Compact disk

Monitor

#27. What are the steps to insert slide numbers?

Insert a text box and select Insert >> Page Number

insert a new text box and select Insert >> slide Number

Design -> Insert a textbox and select Insert >> Number >> Page Number

Choose Insert >> Slide Number

#28. I.T. can be used in _______________.

Business Outdoor

Game

Bathing

#29. Full form of DOS ____________________,Type in the following text box.

enter answer here

#30. In MS-PowerPoint , "Themes Effects" option is available in__________________ tab.

Insert

Animations

Design

#31. When you create a file using paint it will be saved with _______________ extension .

TXT .

JPG

.BMP

#32. _______________ key is used to draw Straight Line.

Caps Lock

Tab

Shift

#33. To change wallpaper on the desktop, we have to select ____________option from control panel display.

Screen Saver

Appearance

Desktop

#34. Mouse has _______________ buttons

both a & b

#35. Founder of Google ___________

Larry Page, Sergey Brin

Steve Jobs, Steve Wozniak

Bill Gates, Paul Allen

#36. In MS-Word, the feature that recognizes common typing mistakes and automatically substitutes the correct spelling is _______________.

Auto Text

Auto Correct

Auto Format

#37. In MS-Excel , "Insert Pie Chart" option is available in __________________tab.

Home

Insert

Page Layout

#38. Power point program is available in _______________.

Main

Accessories

MS-Office

#39. All Formulas must start with a ____________ sign.

#40. In MS-Excel , "Evaluate Formula" option is available in __________________tab.

Insert

Home

Formulas

#41. In MS-Excel , "Data Validation" option is available in __________________tab.

Home

Insert

Data

#42. In MS-Excel , "Data Range Properties" option is available in __________________ tab.

Data

Home

Insert

#43. In MS-Excel , "Middle Align" option is available in __________________ tab.

View

Formulas

Home

#44. To delete a slide from the presentation _______________ option is used.

Delete

Remove

Cancel

#45. By Default the Column Width is _______________.

12.35

9.53

8.43 (64Pixels)

#46. Extension of Power point presentation file is _______________. .

BMP

PPTX

PRN .

#47. Text that you want to appear at the Top or Bottom of all Pages must be given in _______________.

Header & Footer

Book Mark

Footnote

#48. 1 Byte= _______________ Bits

1024

1000

#49. In MS-Excel , "Pivot Table" option is available in __________________ tab.

Home

Page Layout

Insert

#50. To find a particular text in the current document _______________ key is used

Shift +Ctrl +F

Ctrl + F

Alt +F

#51. In MS-PowerPoint , "Slide Show from Current Slide" option is available in________________tab.

Animations

Slide Show

Insert

#52. In MS-Excel , "Full Screen View" option is available in __________________tab.

Insert

View

Home

#53. In MS-Excel , "Insert Sheet" option is available in __________________ tab.

Formulas

View

Home

#54. In MS-PowerPoint , "Pure Black & White" option is available in__________________ tab.

Insert

Animations

View

#55. 1 GB = _______________ bytes

1024 mega bytes

1042 mega Bytes

1240 mega bytes

#56. ____________________ is not a unit of Computer Memory.

Nibble

Byte

Decimal

#57. Which one is Correct Website Name?

www.sanskartutorials.in

sanskartutorials@gmail.com

@sanskartutorials

#58. How We can save any file on desktop?

All These given Option

File -> Save -> Select location Desktop -> press save

File -> save -> name it

File -> Save -> C Drive -> press Save

#59. Backups protect us against _______________.

Save of data & Information

Copy of data & Information

Loss of data & Information

#60. How we can put a Chart in the presentation using PowerPoint?

Insert -> Pictures -> Chart

Edit -> Chart

Insert -> Chart

View -> Chart

#61. In MS-Excel , "Format as Table" option is available in __________________tab.

Home

Formulas

View

#62. Father of Indian Super Computer ______________

APJ Kalam

Vijay Pandurang Bhatkar

Ajay Bhatt

#63. The by default the Row Height is _______________.

15.22

8.43

15.00 (20 Pixels)

#64. How we remove duplicate data?

Select text -> Press Delete

All These given Option

Data-> Remove duplicates

Home -> Format -> Delete Cells

#65. In MS-PowerPoint , "On Mouse Click" option is available in__________________ tab.

View

Slide Show

Animations

#66. In MS-Excel , "Freeze Panes” option is available in __________________ tab.

Home

View

Insert

#67. Which feature is used to make selected sentence to All Capital Letters or All Small Letters?

Change Word

Change Letter

Change Case

Change Sentence

#68. Father of Computer____________

Chales Babbage

Paul Allen

Steve Jobs

#69. Full form of SSD ____________________, Type in the following text box.

enter answer here

#70. RAM is ___________________ Memory.

Permanent

Temporary

Static

#71. Set Page Border for page which step you uses:

View - Macro- Record Macro

Home - Font - border

Design - border

#72. Select correct email id ______

sanskar@sanskar.com

sanskar@123

www.sanskartutorials.in

#73. In MS-PowerPoint , "Shape Fill” option is available in __________________tab.

Home

Animations

Insert

#74. In MS-Excel , "Create from Selection" option is available in__________________ tab.

Insert

Home

Formulas

#75. Founder of Facebook ________________

Mark Zuckerberg

Larry Page

Bill Gates

#76. How we insert picture in shapes?

Insert Shapes - Shape fill - Picture

All These given Option

Insert - Picture

Select Picture - Copy - Paste

#77. In MS-Excel , "Rename Sheet" option is available in __________________tab.

Home

View

Formulas

#78. In Excel, Columns are labelled as______

A-1, A-2, etc

1,2,3 etc

A, B, C, etc

A1, A2, etc

#79. In MS-PowerPoint , "Resolution" option is available in __________________tab.

Slide Show

Animations

Insert

#80. Word Processor is best Program for ______________.

Calculation

Presentation

Performing Mail Merge

#81. From these _______________ function is used in MS-Excel.

Sum

Subtract

Add

#82. You can start power point application with following step...

All of above

Type ppoint.exe in run and press enter

Going to Start -> Run -> type "powerpnt" and press enter

Go to Start -> Programs -> All Programs ->

#83. In MS-Excel , "Autosum" option is available in __________________ tab.

Insert

Formulas

Home

#84. _______________ of the following are valid Min. & Max. zoom sizes in MS-Office.

10, 500

20, 250

10, 100

#85. Short Cut Key for Replace ___________

Ctrl + G

Ctrl + H

Ctrl + R

#86. In MS-PowerPoint , "Slide Transition" option is available in__________________ tab.

Animations

View

Slide Sho

#87. First Cell in Range is separated from Last Cell with a _______________ symbol.

$ (Dollar)

(Equal)=

(Colon)

#88. _______________ was the first computer programmer.

Babbage

Pascal

John Naipier

#89. In MS-Excel , "Advanced Filter" option is available in __________________tab.

Home

Data

Insert

#90. In MS-Excel , "Clear Formatting" option is available in __________________tab.

View

Home

Formulas

#91. Full form of USB ____________________, Type in the following text box.

enter answer here

#92. In MS-Excel , "Row Height" option is available in __________________ tab.

Formulas

View

Home

#93. All the cell references are prefixed by _______________sign.

# (Hash)

= (Equal)

%( Percentage)

#94. In MS-PowerPoint , "Slide Layout" option is available in __________________tab.

Insert

Animations

Home

#95. In MS-Excel , "Autofit Column Width" option is available in__________________ tab.

Formulas

Home

View

#96. The options Portrait and Landscape comes under ________

Paper Size

Page Rotation

Page Layout

Page Orientation

#97. To move a files across the internet from a remote computer to your computer is called _______________.

Irc

FTP

#98. In MS-Excel , "Format Cells" option is available in __________________ tab.

View

Home

Formulas

#99. In MS-Excel , "View Side by Side two Worksheet" option is available in________________ tab.

Insert

Home

View

#100. Windows is a program that provides _______________.

GUE

Mouse

GUI

Finish