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 35 of 60
Question #681
In PowerPoint, to apply a design template to all slides, you should use:
A. Animations tab -> Design
B. Design tab -> Themes
C. View tab -> Slide Master
D. Insert tab -> Themes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Themes (design templates) are applied from the Design tab.
This question belongs to: Computer Microsoft Office
Question #682
In MS Access, the 'Required' field property set to 'Yes' means:
A. The field is indexed with duplicates allowed
B. The field cannot be left blank; it must contain a value
C. The field will auto-increment
D. The field must be the primary key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Required enforces that the field is not null.
This question belongs to: Computer Microsoft Office
Question #683
To quickly remove paragraph formatting in MS Word, press:
A. Ctrl + Q
B. Ctrl + Space
C. Ctrl + 0
D. Ctrl + Shift + N
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Q resets paragraph formatting. Ctrl+Space removes character formatting. Ctrl+Shift+N applies Normal style.
This question belongs to: Computer Microsoft Office
Question #684
In Excel, which function calculates the number of cells that contain numbers in a range?
A. COUNTA()
B. COUNT()
C. SUM()
D. COUNTIF()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNT counts numeric cells. COUNTA counts non-empty cells of any type.
This question belongs to: Computer Microsoft Office
Question #685
Which feature in PowerPoint enables you to record narration for a presentation?
A. Slide Show tab -> Record Slide Show
B. Transitions tab -> Sound
C. Insert tab -> Audio -> Record Audio
D. Animations tab -> Audio
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Record Slide Show captures narration and slide timings.
This question belongs to: Computer Microsoft Office
Question #686
In MS Access, which clause of SQL is used to filter records based on a condition?
A. GROUP BY
B. ORDER BY
C. HAVING
D. WHERE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
WHERE filters rows before grouping. HAVING filters after grouping.
This question belongs to: Computer Microsoft Office
Question #687
What is the default orientation of a page in MS Word?
A. Landscape
B. A4
C. Letter
D. Portrait
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Default orientation is portrait. Landscape is wider.
This question belongs to: Computer Microsoft Office
Question #688
In Excel, to enter a new line within a cell, press:
A. Shift + Enter
B. Alt + Enter
C. Enter
D. Ctrl + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Enter starts a new line in the same cell.
This question belongs to: Computer Microsoft Office
Question #689
Which of the following is NOT a type of page break in MS Word?
A. Odd Page break
B. Even Page break
C. Next Page break
D. Continuous break
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Continuous is a section break type, not a page break. Page break types: Page (Next Page is a section break that also breaks page), but there is no 'Continuous page break'. So answer A.
This question belongs to: Computer Microsoft Office
Question #690
In PowerPoint, to quickly align objects, which tab provides alignment tools?
A. Format (Drawing Tools)
B. Design
C. Home
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
When an object is selected, the Format tab appears with Align options.
This question belongs to: Computer Microsoft Office
Question #691
In MS Access, what does an 'append query' do?
A. Adds records from one table to another
B. Updates existing records
C. Creates a backup of the table
D. Deletes records from a table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Append query inserts records into a target table.
This question belongs to: Computer Microsoft Office
Question #692
What does Ctrl + Shift + F do in MS Excel?
A. Applies the default font
B. Increases font size
C. Opens the Format Cells dialog with the Font tab selected
D. Opens the Find dialog
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+F opens Format Cells -> Font tab. Ctrl+1 opens Format Cells main dialog.
This question belongs to: Computer Microsoft Office
Question #693
In MS Word, to create a bulleted list quickly, type an asterisk (*) and press:
A. Enter
B. Ctrl + Enter
C. Shift + Enter
D. Spacebar or Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Typing * followed by Spacebar or Tab automatically starts a bulleted list (AutoFormat).
This question belongs to: Computer Microsoft Office
Question #694
In Excel, which function returns the current date only (no time)?
A. DAY()
B. TODAY()
C. NOW()
D. DATE()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TODAY() returns date. NOW() returns date and time.
This question belongs to: Computer Microsoft Office
Question #695
Which PowerPoint feature allows you to package the presentation with all linked files and fonts?
A. Create Video
B. Compress Media
C. Package for CD
D. Export as PDF
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Package for CD bundles the presentation and all external files for portability.
This question belongs to: Computer Microsoft Office
Question #696
In MS Access, what is a 'lookup field'?
A. A field with an input mask
B. A field that displays a list of values from a table or query for selection
C. A field used to search records quickly
D. A field that stores hyperlinks
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A lookup field provides a dropdown list of values from a row source.
This question belongs to: Computer Microsoft Office
Question #697
Which shortcut key is used to repeat the last find action in MS Word?
A. F4
B. F3
C. Ctrl + F
D. Shift + F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F4 repeats the last Find. F4 repeats the last action. F3 also can repeat find, but Shift+F4 is the documented repeat find shortcut.
This question belongs to: Computer Microsoft Office
Question #698
In Excel, which function joins text from multiple ranges with a delimiter? (Available in Excel 2019/365)
A. CONCAT()
B. CONCATENATE()
C. JOIN()
D. TEXTJOIN()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
TEXTJOIN combines text with a delimiter and can ignore empty cells. CONCATENATE and CONCAT do not have delimiter parameter.
This question belongs to: Computer Microsoft Office
Question #699
In MS Word, the 'Gutter' margin is used to:
A. Define the distance between columns
B. Set the top margin only
C. Add extra space for binding
D. Separate header from body text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Gutter margin provides extra space on the side that will be bound.
This question belongs to: Computer Microsoft Office
Question #700
Which of the following is a built-in Excel tool to perform what-if analysis by changing multiple inputs?
A. Scenario Manager
B. Data Table
C. Solver
D. Goal Seek
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Scenario Manager stores sets of input values. Goal Seek changes one variable to reach target, Solver optimizes, Data Table shows results of one or two variables.
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?'