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 28 of 60
Question #541
In MS Word, what does the 'Keep with Next' paragraph formatting option accomplish?
A. It forces two adjacent words to remain on the same line text string.
B. It locks column layout structures together.
C. It prevents a page break from splitting the selected paragraph from the paragraph immediately following it.
D. It links headers across consecutive section breaks.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Keep with Next' option prevents an automatic page break from separating the selected paragraph (such as a heading) from the following paragraph, keeping them together on the same page.
This question belongs to: Computer Microsoft Office
Question #542
In MS PowerPoint, what is the default shortcut key sequence used to close the active presentation file window without exiting the application shell?
A. Ctrl + Q
B. Alt + F4
C. Ctrl + W
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + W (or Ctrl + F4) closes the active presentation file window, while keeping the main parent PowerPoint application frame open.
This question belongs to: Computer Microsoft Office
Question #543
Which join type in an MS Access Query design view extracts only the rows where the linked key field values match exactly between both tables?
A. Inner Join
B. Full Cross Join
C. Right Outer Join
D. Left Outer Join
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An Inner Join is the default join type in MS Access. It extracts records from linked tables only when the values in the joined fields match exactly.
This question belongs to: Computer Microsoft Office
Question #544
What is the function of the keyboard shortcut Ctrl + Shift + Spacebar when editing text in MS Word?
A. Highlights the active table row structure
B. Clears all style configurations from the selection
C. Inserts a non-breaking space character
D. Inserts a hard page break layout marker
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Shift + Spacebar inserts a non-breaking space, which prevents an automatic line break from separating two adjacent words at the end of a line layout.
This question belongs to: Computer Microsoft Office
Question #545
Which of the following elements in MS PowerPoint allows you to see the speaker notes and slide layouts at the same time on a single printed sheet?
A. Notes Page View
B. Slide Sorter View
C. Outline view structure
D. Handout Master view layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Notes Page view displays each slide layout on a separate page with its associated speaker notes below it, showing exactly how the printed notes pages will look.
This question belongs to: Computer Microsoft Office
Question #546
In MS Word, which specific line spacing property option applies a rigid spacing dimension that Excel or Word cannot adjust automatically?
A. At least spacing metric
B. Double line spacing preset
C. Exactly
D. Multiple line layouts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Exactly' line spacing property fixes the line spacing to a specific point size that Word will not adjust automatically, even if font sizes within the line change.
This question belongs to: Computer Microsoft Office
Question #547
What type of macro recording language is natively embedded under the advanced automation layers of Microsoft Excel and Word?
A. C++ Backend Libraries
B. JavaScript Object Framework
C. Visual Basic for Applications (VBA)
D. Python Automation Scripts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VBA (Visual Basic for Applications) is the standard programming language used to write, record, and execute automation macros across MS Office applications.
This question belongs to: Computer Microsoft Office
Question #548
In MS PowerPoint, what feature allows presenters to use their mobile devices or mouse pointer to highlight slide assets in real-time during a show?
A. Cameo Video Stream integration
B. Laser Pointer
C. Animation Painter tool
D. SmartArt layout indicators
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Holding the Ctrl key and left-clicking during a live slide show turns the mouse cursor into a glowing Laser Pointer to help guide the audience's focus.
This question belongs to: Computer Microsoft Office
Question #549
Which shortcut key is used to create a new blank document in MS Word?
A. Ctrl + P
B. Ctrl + N
C. Ctrl + O
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + N opens a new blank document. Ctrl + O opens an existing document, Ctrl + S saves, Ctrl + P prints.
This question belongs to: Computer Microsoft Office
Question #550
In MS Excel, which function returns the largest value from a range of cells?
A. HIGH()
B. LARGE()
C. MAX()
D. MIN()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MAX() returns the maximum value. MIN() returns minimum. LARGE() returns the k-th largest value. HIGH() is not a valid Excel function.
This question belongs to: Computer Microsoft Office
Question #551
To start a slide show from the very first slide in MS PowerPoint, press:
A. Alt + F5
B. F5
C. Shift + F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F5 starts the slide show from the beginning. Shift + F5 starts from the current slide.
This question belongs to: Computer Microsoft Office
Question #552
Which of the following is the default file extension of MS Access 2016 database?
A. .accdb
B. .db
C. .mdb
D. .xlsx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MS Access 2007 and later use .accdb by default. Older versions used .mdb. .xlsx is Excel, .db is generic.
This question belongs to: Computer Microsoft Office
Question #553
What does Ctrl + B do in MS Office applications?
A. Applies bold formatting
B. Aligns text to both margins
C. Opens the bookmark dialog
D. Increases font size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + B makes selected text bold. In Word, Ctrl + Shift + B opens the bookmark dialog. Ctrl + Shift + > increases font size.
This question belongs to: Computer Microsoft Office
Question #554
Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?
A. Notes Page view
B. Reading view
C. Slide Sorter view
D. Normal view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Sorter view shows miniature slides, allowing reordering. Normal view is for editing, Reading view for presentation preview.
This question belongs to: Computer Microsoft Office
Question #555
In MS Access, a single piece of information in a table is stored in a:
A. Field
B. Record
C. Query
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A field represents a column (single data item). A record is a complete row of fields.
This question belongs to: Computer Microsoft Office
Question #556
Which shortcut key is used to undo the last action in MS Word?
A. Ctrl + C
B. Ctrl + Y
C. Ctrl + X
D. Ctrl + Z
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Z undoes the last action. Ctrl + Y redoes or repeats. Ctrl + X cuts, Ctrl + C copies.
This question belongs to: Computer Microsoft Office
Question #557
In Excel, what is the result of the formula =SUM(A1:A3, B1:B3) if A1=5, A2=3, A3=2, B1=1, B2=4, B3=2?
A. 12
B. 17
C. 19
D. 15
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SUM(A1:A3) = 5+3+2 = 10, SUM(B1:B3) = 1+4+2 = 7, total 17.
This question belongs to: Computer Microsoft Office
Question #558
To insert a new slide in PowerPoint, which shortcut is used?
A. Ctrl + I
B. Ctrl + N
C. Ctrl + D
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M inserts a new slide. Ctrl + N creates a new presentation, Ctrl + D duplicates the selected slide.
This question belongs to: Computer Microsoft Office
Question #559
In MS Access, which object is used to extract specific data from one or more tables based on criteria?
A. Report
B. Macro
C. Query
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A query retrieves and filters data. Forms are for data entry, reports for formatted output, macros automate tasks.
This question belongs to: Computer Microsoft Office
Question #560
Which of the following is NOT a valid MS Excel chart type?
A. PivotChart
B. Waterfall
C. Sunburst
D. Sparkline
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Sparkline is a mini chart inside a cell, not a full chart type like the others. Sunburst, Waterfall, and PivotChart are valid chart types.
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
Microsoft Office 1199 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'