Microsoft Office MCQs

Computer

Microsoft Office MCQs

Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.

1199
Total Questions

Practice Questions

Page 55 of 60
Question #1081
What does 'Ctrl + F6' do in MS Word?
A. Switches between open document windows
B. Closes the document
C. Opens a new document
D. Increases font size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+F6 cycles through documents.
This question belongs to: Computer Microsoft Office
Question #1082
In Excel, the 'Transpose' paste option:
A. Copies only values
B. Pastes formatting only
C. Pastes as a link
D. Switches rows to columns and columns to rows
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Transpose changes data orientation.
This question belongs to: Computer Microsoft Office
Question #1083
In MS Word, which view is best for editing headers and footers?
A. Draft
B. Read Mode
C. Outline
D. Print Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Print Layout shows headers/footers; you can double-click to edit them.
This question belongs to: Computer Microsoft Office
Question #1084
In PowerPoint, the shortcut to insert a hyperlink is:
A. Ctrl + L
B. Ctrl + K
C. Alt + K
D. Ctrl + H
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+K hyperlink.
This question belongs to: Computer Microsoft Office
Question #1085
In MS Access, what is the default value for 'Allow Zero Length' property?
A. Null
B. No
C. True
D. Yes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
By default, zero-length strings are not allowed.
This question belongs to: Computer Microsoft Office
Question #1086
Which of the following is a valid paragraph spacing option in MS Word?
A. Multiple
B. At least
C. Exactly
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Line spacing options: Single, 1.5, Double, At least, Exactly, Multiple.
This question belongs to: Computer Microsoft Office
Question #1087
In Excel, the 'Solver' add-in is used for:
A. Solving equations
B. Goal seeking
C. Statistical analysis
D. Optimization and what-if analysis with multiple constraints
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Solver finds optimal value for a target cell by changing multiple variables.
This question belongs to: Computer Microsoft Office
Question #1088
In PowerPoint, which key stops a running slide show and returns to the previous view?
A. Ctrl + Break
B. Break
C. End
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Esc exits slide show.
This question belongs to: Computer Microsoft Office
Question #1089
In MS Access, the 'RunSQL' macro action is used to:
A. Run a query
B. Close a form
C. Execute an SQL statement
D. Open a report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
RunSQL executes action queries.
This question belongs to: Computer Microsoft Office
Question #1090
What is the shortcut to select all text in a document in MS Word?
A. Ctrl + A
B. Shift + Home
C. Ctrl + F5
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+A selects all.
This question belongs to: Computer Microsoft Office
Question #1091
In Excel, which function returns the largest value from a range that meets multiple criteria?
A. MAXIF()
B. LARGEIFS()
C. DMAX()
D. MAXIFS()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MAXIFS available in Excel 2019/365.
This question belongs to: Computer Microsoft Office
Question #1092
In MS Word, to add a border to a page, go to:
A. Layout -> Borders
B. Design -> Page Borders
C. Home -> Borders
D. Insert -> Borders
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Page Borders is under Design tab.
This question belongs to: Computer Microsoft Office
Question #1093
In PowerPoint, which option is used to set the slide show to loop continuously?
A. Slide Show -> Set Up Show -> Loop continuously until 'Esc'
B. Transitions -> Advance Slide -> After
C. Animations -> Repeat
D. Design -> Loop
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Loop setting in Set Up Show.
This question belongs to: Computer Microsoft Office
Question #1094
In MS Access, the 'Form Footer' section appears at:
A. Bottom of each page
B. Bottom of the form
C. Bottom of the screen
D. Bottom of the report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Form Footer is at the bottom of the form.
This question belongs to: Computer Microsoft Office
Question #1095
Which of the following is not a standard chart type in Excel?
A. Radar
B. Flowchart
C. Surface
D. Stock
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Flowchart is a SmartArt, not a chart type.
This question belongs to: Computer Microsoft Office
Question #1096
In MS Word, the 'Ctrl + Shift + G' shortcut opens:
A. Gridlines
B. Go To dialog
C. Grammar dialog
D. Word Count dialog
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+G shows word count statistics.
This question belongs to: Computer Microsoft Office
Question #1097
In Excel, to move to the next worksheet, press:
A. Alt + Page Down
B. Shift + Page Down
C. Ctrl + Page Down
D. Ctrl + Page Up
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Page Down next sheet, Ctrl+Page Up previous.
This question belongs to: Computer Microsoft Office
Question #1098
In PowerPoint, the 'Slide Master' view can be accessed from:
A. View tab -> Slide Master
B. Design tab -> Slide Master
C. Both A and B
D. Home tab -> Slide Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Master is on the View tab.
This question belongs to: Computer Microsoft Office
Question #1099
In MS Access, a 'query' object is used to:
A. Retrieve, filter, and perform calculations on data from tables
B. Print formatted output
C. Automate repetitive tasks
D. Store data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Queries manipulate data.
This question belongs to: Computer Microsoft Office
Question #1100
What is the default font and size in MS Word 2016?
A. Times New Roman, 12 pt
B. Calibri, 12 pt
C. Calibri, 11 pt
D. Arial, 10 pt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Default font is Calibri 11 pt since Word 2007.
This question belongs to: Computer Microsoft Office

More Computer Topics

Computer Abbreviations MCQs
Computer Fundamentals MCQs
Computer Hardware MCQs
Computer Networking MCQs
Computer Software MCQs
CPU (Central Processing Unit) MCQs
Cyber Security MCQs
Database Management System (DBMS) MCQs
Internet and Web Technologies MCQs
Memory and Storage Devices MCQs
Operating Systems MCQs
Programming Languages MCQs
Today's Top Topics
Computer Software 347 CPU (Central Processing Unit) 327 Memory and Storage Devices 438 Programming Languages 0 Cyber Security 269
Explore Subjects
Computer 5279 History GK 3374 Maths 5575 Accountancy and Statistics 3179 Current Affairs 575
Practice Mix
Find the word most OPPOSITE in meaning to 'OPAQUE'.
Which organization focuses on protecting global biological diversity?
Which of these is the most recently formed national park in India among the options provided?
A mixture of two immiscible liquids can be separated by:
The 'Gol Gumbaz' in Bijapur has a whispering gallery. This architectural feature is an example of: