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 9 of 60
Question #161
In MS Access, which object is used to enter, edit, or display data from a table or query in a user-friendly format?
A. Form
B. Report
C. Table
D. Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms provide a graphical interface for users to view, enter, and edit data. Tables store data, queries retrieve data, reports present data for printing.
This question belongs to: Computer Microsoft Office
Question #162
What is the shortcut key to apply italic formatting in MS Office?
A. Ctrl + T
B. Ctrl + Shift + I
C. Alt + I
D. Ctrl + I
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + I toggles italic formatting. The others are not standard for italic.
This question belongs to: Computer Microsoft Office
Question #163
In Excel, which function returns the number of characters in a text string?
A. TEXT
B. CHAR
C. LENGTH
D. LEN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The LEN function returns the number of characters in a text string. LENGTH is not a function, CHAR returns a character based on code, TEXT formats a value.
This question belongs to: Computer Microsoft Office
Question #164
Which view in MS PowerPoint shows the presentation in a window with thumbnails of slides and a notes section below?
A. Notes Page View
B. Slide Sorter View
C. Normal View
D. Outline View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Normal View is the default editing view with three panes: Slide pane, Thumbnails pane, and Notes pane. Outline View shows only text outline, Slide Sorter shows thumbnails only, Notes Page shows notes with slide.
This question belongs to: Computer Microsoft Office
Question #165
In MS Word, which tab contains the option to insert a table of contents?
A. Insert
B. References
C. Review
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Table of Contents command is located in the References tab, in the Table of Contents group.
This question belongs to: Computer Microsoft Office
Question #166
What is the default orientation of slides in MS PowerPoint?
A. Portrait
B. Landscape
C. Widescreen
D. Square
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The default slide orientation is Landscape (wider than tall). Portrait is available but not default.
This question belongs to: Computer Microsoft Office
Question #167
In Excel, what does the 'IF' function do?
A. Sums cells based on a condition
B. Tests a condition and returns one value if true, another if false
C. Counts cells based on a condition
D. Looks up a value in a table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.
This question belongs to: Computer Microsoft Office
Question #168
Which of the following is NOT a type of animation in MS PowerPoint?
A. Exit
B. Emphasis
C. Transition
D. Entrance
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Animations in PowerPoint are categorized as Entrance, Exit, Emphasis, and Motion Paths. Transitions are effects applied between slides, not within a slide.
This question belongs to: Computer Microsoft Office
Question #169
In MS Access, the 'Design View' is used to:
A. Run queries
B. Print reports
C. Create and modify the structure of tables, queries, forms, and reports
D. Enter data into tables
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Design View allows the user to define or modify the underlying structure of database objects, such as field properties, query criteria, form layout, etc. Datasheet View is for data entry.
This question belongs to: Computer Microsoft Office
Question #170
What is the shortcut key to open the 'Spelling and Grammar' check in MS Word?
A. F5
B. Shift + F7
C. F7
D. F9
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F7 launches the Spelling and Grammar checker. F5 opens Find and Replace, F9 updates fields, Shift+F7 opens the Thesaurus.
This question belongs to: Computer Microsoft Office
Question #171
In Excel, how do you select an entire row?
A. Press Ctrl + Spacebar
B. Click the row number
C. Both A and B
D. Press Shift + Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Clicking the row number selects the entire row, and Shift + Spacebar is the keyboard shortcut. Ctrl + Spacebar selects the entire column.
This question belongs to: Computer Microsoft Office
Question #172
Which of the following is used to create a duplicate of a slide in MS PowerPoint?
A. Ctrl + C and Ctrl + V
B. Right-click and select Duplicate Slide
C. All of the above
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All listed methods can duplicate a slide: Ctrl+D duplicates directly, Copy+Paste works, and right-click has Duplicate Slide option.
This question belongs to: Computer Microsoft Office
Question #173
In MS Word, the 'Format Painter' tool is found on which tab?
A. Insert
B. Layout
C. Design
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format Painter is located in the Clipboard group on the Home tab. It copies formatting from one selection and applies it to another.
This question belongs to: Computer Microsoft Office
Question #174
What is the function of the '$' sign in Excel formulas?
A. It denotes a currency format
B. It is used for concatenation
C. It creates an absolute reference
D. It indicates a named range
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The dollar sign ($) is used to create absolute references (e.g., $A$1) that do not change when the formula is copied. It can also be used for currency formatting when applied as a number format, but in formulas it's for absolute references.
This question belongs to: Computer Microsoft Office
Question #175
In MS Access, which relationship type is most commonly used?
A. Self-referencing
B. One-to-Many
C. One-to-One
D. Many-to-Many
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
One-to-Many is the most common relationship, where a record in one table can relate to many records in another table.
This question belongs to: Computer Microsoft Office
Question #176
What is the shortcut key to start a slideshow from the beginning in MS PowerPoint?
A. Ctrl + F5
B. Shift + F5
C. Alt + F5
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F5 starts the slideshow from the first slide. Shift + F5 starts from the current slide. Ctrl+F5 is not standard.
This question belongs to: Computer Microsoft Office
Question #177
In Excel, which of the following is a valid function to find the average of numbers?
A. AVERAGEIF
B. AVG
C. MEAN
D. AVERAGE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The AVERAGE function calculates the arithmetic mean. AVG is not a function, MEAN is not, AVERAGEIF averages based on a condition.
This question belongs to: Computer Microsoft Office
Question #178
Which tab in MS Word contains the 'Page Borders' option?
A. Home
B. Design
C. Layout
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Page Borders is found under the Design tab (formerly Page Layout) in the Page Background group. In newer versions it's under Design.
This question belongs to: Computer Microsoft Office
Question #179
In MS PowerPoint, which object allows you to add reusable content like a company logo to every slide?
A. Handout Master
B. Slide Master
C. Notes Master
D. Header & Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Master controls the overall layout and design of all slides in a presentation; adding a logo to the Slide Master will place it on all slides. Header & Footer is for page numbers, date, etc. Notes Master and Handout Master are for notes and handouts.
This question belongs to: Computer Microsoft Office
Question #180
What is the maximum number of worksheets that can be included in a single Excel workbook (by default)?
A. 16384
B. Unlimited, limited by memory
C. 3
D. 255
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
There is no fixed limit on the number of worksheets; it is limited by available memory. However, the default number of worksheets when creating a new workbook is 1 (in newer versions) or 3 (older). So the answer is unlimited, limited by memory.
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?'