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 51 of 60
Question #1001
In MS Access, a 'Macro' is used to:
A. Import external data
B. Create reports
C. Automate a series of actions without writing VBA code
D. Store data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Macros provide a simplified automation tool.
This question belongs to: Computer Microsoft Office
Question #1002
The shortcut to insert a trademark symbol (â„¢) in MS Word is:
A. Ctrl + Alt + T
B. Both A and B
C. Alt + 0153
D. Ctrl + Shift + T
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Alt+T inserts TM symbol. Alt code 0153 also works.
This question belongs to: Computer Microsoft Office
Question #1003
In Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)?
A. TEXTJOIN()
B. JOIN()
C. CONCAT()
D. CONCATENATE()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TEXTJOIN has a delimiter argument. CONCAT does not have delimiter.
This question belongs to: Computer Microsoft Office
Question #1004
In MS Word, to repeat the last action, press:
A. Ctrl + R
B. Ctrl + Y
C. F4
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F4 repeats last action; Ctrl+Y redoes. Often they overlap.
This question belongs to: Computer Microsoft Office
Question #1005
In PowerPoint, the 'Arrange' group under the Home tab contains:
A. Bring Forward, Send Backward, Align, Group, Rotate
B. Slide layout
C. Animations and transitions
D. Font formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Arrange group is for object ordering.
This question belongs to: Computer Microsoft Office
Question #1006
In MS Access, which property specifies the text that appears in the status bar when a field is selected?
A. Default Value
B. Status Bar Text
C. Caption
D. Description
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Description property appears in the status bar.
This question belongs to: Computer Microsoft Office
Question #1007
What is the shortcut to refresh a PivotTable in Excel?
A. Alt + F5
B. F5
C. Ctrl + Alt + F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+F5 refreshes PivotTable. Also right-click -> Refresh.
This question belongs to: Computer Microsoft Office
Question #1008
In MS Word, what does the 'Ctrl + Shift + C' shortcut do?
A. Copy formatting
B. Copy text
C. Clear formatting
D. Change case
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+C copies format (Format Painter).
This question belongs to: Computer Microsoft Office
Question #1009
In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:
A. A1/B1 results in any error value
B. If A1 is blank
C. If B1 is zero
D. Only if #DIV/0!
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
IFERROR catches all error types and returns specified value.
This question belongs to: Computer Microsoft Office
Question #1010
In PowerPoint, which of the following file formats allows you to save each slide as an image?
A. .ppsx
B. .jpg (via Save As type)
C. .pptx
D. .potx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Save As can export slides as JPEG, PNG, etc.
This question belongs to: Computer Microsoft Office
Question #1011
In MS Access, what does a 'Crosstab query' do?
A. Aggregates data and displays it with row and column headings (like a pivot)
B. Prompts for input
C. Deletes records based on criteria
D. Creates a new table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Crosstab query cross-tabulates data.
This question belongs to: Computer Microsoft Office
Question #1012
Which key opens the 'Help' function in MS Office?
A. F1
B. Ctrl + H
C. Alt + H
D. F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F1 for Help.
This question belongs to: Computer Microsoft Office
Question #1013
In MS Word, to view two parts of a document simultaneously, use:
A. Review -> Compare
B. Window -> New Window
C. View -> Split
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Split divides one window into two panes; New Window opens a second window of same document.
This question belongs to: Computer Microsoft Office
Question #1014
In Excel, a cell formatted as 'Text' will:
A. Automatically align to the right
B. Display the entered data exactly as typed, not as a number/date
C. Convert numbers to text, but formulas can still calculate
D. Prevent any entry
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Text format treats input as literal text.
This question belongs to: Computer Microsoft Office
Question #1015
In PowerPoint, the 'Selection Pane' shows:
A. Transition settings
B. Slide thumbnails
C. Animation timeline
D. A list of all objects on the slide, allowing you to hide, rename, reorder them
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Selection Pane (Home -> Select -> Selection Pane) manages objects.
This question belongs to: Computer Microsoft Office
Question #1016
In MS Access, to set a relationship that automatically deletes related records when the primary record is deleted, enable:
A. Allow Nulls
B. Cascade Delete Related Records
C. Cascade Update Related Fields
D. Enforce Referential Integrity
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Cascade Delete removes child records.
This question belongs to: Computer Microsoft Office
Question #1017
What is the shortcut to insert a new comment in MS Word?
A. Ctrl + Shift + M
B. Ctrl + Alt + M
C. F2
D. Shift + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Alt+M inserts a new comment.
This question belongs to: Computer Microsoft Office
Question #1018
In Excel, to name a range, you can:
A. Both A and B
B. Select range, type name in Name Box and press Enter
C. Formulas -> Define Name
D. Insert -> Name
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both methods work.
This question belongs to: Computer Microsoft Office
Question #1019
In PowerPoint, the 'Zoom slider' in the status bar is used to:
A. Set slide transition speed
B. Adjust the magnification of the slide view
C. Zoom in on object during presentation
D. Apply zoom animation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Zoom slider changes view magnification.
This question belongs to: Computer Microsoft Office
Question #1020
In MS Access, the 'Form Header' section appears:
A. At the top of the form, often used for title or logo
B. In the detail section
C. Only once at the very top of the printout
D. At the top of every page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Form Header displays at the top of the form.
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: