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 37 of 60
Question #721
Which of the following is NOT a slide layout in PowerPoint?
A. Comparison
B. Blank
C. Chart Slide
D. Two Content
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Standard layouts include Title Slide, Title and Content, Section Header, Two Content, Comparison, Title Only, Blank, Content with Caption, Picture with Caption, etc. 'Chart Slide' is not a layout.
This question belongs to: Computer Microsoft Office
Question #722
In MS Access, the property 'Default Value' is used to:
A. Set the maximum length of a field
B. Automatically enter a value when a new record is created
C. Format the display of data
D. Restrict the type of data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Default Value populates a field when a new record is added, unless overridden.
This question belongs to: Computer Microsoft Office
Question #723
To select a whole word in MS Word with a single mouse action:
A. Ctrl + Click
B. Double-click the word
C. Triple-click the word
D. Single-click the word
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Double-click selects a word; triple-click selects a paragraph.
This question belongs to: Computer Microsoft Office
Question #724
In Excel, what is the purpose of the 'Freeze Panes' feature?
A. Keeps selected rows or columns visible while scrolling
B. Splits the window into multiple panes that can scroll independently
C. Prevents any changes to the worksheet
D. Locks cell formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Freeze Panes locks rows/columns. Split creates independent scrollable panes but doesn't lock.
This question belongs to: Computer Microsoft Office
Question #725
In PowerPoint, which key can be pressed to pause or resume a slide show?
A. Esc
B. P
C. S
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Pressing S pauses the slide show (stops automatic advance). Pressing S again resumes. Spacebar advances.
This question belongs to: Computer Microsoft Office
Question #726
In MS Access, which object is used to present data in a printed format with headers, footers, and grouping?
A. Form
B. Table
C. Query
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reports are designed for printing and often include grouping and summaries.
This question belongs to: Computer Microsoft Office
Question #727
Which of the following is the correct shortcut to open the 'Go To' dialog in Excel?
A. F5
B. Both A and B
C. Ctrl + F
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both F5 and Ctrl+G open the Go To dialog in Excel.
This question belongs to: Computer Microsoft Office
Question #728
In MS Word, what is a 'Style Set'?
A. A group of templates
B. A macro that formats text
C. A predefined set of keyboard shortcuts
D. A collection of styles with coordinated fonts and colors that can be applied to a document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Style Sets change the look of the whole document by applying a group of styles.
This question belongs to: Computer Microsoft Office
Question #729
In Excel, to quickly copy a formula down to adjacent cells, double-click:
A. The column header
B. The cell border
C. The fill handle of the cell
D. The formula bar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Double-clicking the fill handle copies the formula down as far as contiguous data in the adjacent column.
This question belongs to: Computer Microsoft Office
Question #730
Which of the following is a valid file extension for an Excel macro-enabled workbook?
A. .xlsb
B. .xlsm
C. .xlsx
D. .xltm
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.xlsm is macro-enabled workbook. .xlsb is binary workbook, .xltm macro-enabled template.
This question belongs to: Computer Microsoft Office
Question #731
In PowerPoint, what is a 'trigger' in animations?
A. An object that starts an animation when clicked
B. A sound that plays on slide advance
C. A hyperlink to another slide
D. An automatic timer for transition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Trigger sets an animation to begin on the click of a specified object.
This question belongs to: Computer Microsoft Office
Question #732
In MS Access, the 'Validation Rule' property is used to:
A. Define the input mask pattern
B. Specify a condition that data must satisfy to be entered
C. Set a default value
D. Require that a value be entered
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Validation Rule checks data against an expression (e.g., >=0). Validation Text provides message.
This question belongs to: Computer Microsoft Office
Question #733
What is the shortcut to open the 'Help' pane in MS Office?
A. Ctrl + H
B. F1
C. Alt + H
D. F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F1 opens Help in most Office applications.
This question belongs to: Computer Microsoft Office
Question #734
In MS Word, which type of break starts a new section on the same page?
A. Even Page section break
B. Next Page section break
C. Continuous section break
D. Odd Page section break
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Continuous break starts a new section without a page break.
This question belongs to: Computer Microsoft Office
Question #735
In PowerPoint, to embed a video from a file, go to:
A. Animations -> Insert Video
B. Insert -> Video -> Video on My PC
C. Design -> Media
D. Transitions -> Video
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Insert tab contains the Video option.
This question belongs to: Computer Microsoft Office
Question #736
In MS Access, a query that modifies data in a table (like increasing price by 10%) is called:
A. Append query
B. Update query
C. Select query
D. Crosstab query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Update query changes existing field values.
This question belongs to: Computer Microsoft Office
Question #737
To select the entire row in Excel, press:
A. Ctrl + Spacebar
B. Shift + Spacebar
C. Alt + Spacebar
D. Ctrl + Shift + Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift+Spacebar selects the entire row. Ctrl+Spacebar selects entire column.
This question belongs to: Computer Microsoft Office
Question #738
In MS Word, what is the maximum zoom level?
A. 200%
B. 1000%
C. 400%
D. 500%
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Maximum zoom in Word is 500%.
This question belongs to: Computer Microsoft Office
Question #739
Which function in Excel returns the average of cells that meet a given condition?
A. AVERAGE()
B. SUMIF()
C. COUNTIF()
D. AVERAGEIF()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AVERAGEIF averages based on a criterion. AVERAGEIFS for multiple criteria.
This question belongs to: Computer Microsoft Office
Question #740
In PowerPoint, to hide the Ribbon, you can press:
A. Alt + F1
B. Ctrl + F1
C. Ctrl + Shift + F1
D. F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F1 collapses/expands the Ribbon.
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?'