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. Create reports
B. Automate a series of actions without writing VBA code
C. Store data
D. Import external data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Both A and B
B. Ctrl + Shift + T
C. Ctrl + Alt + T
D. Alt + 0153
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. JOIN()
B. TEXTJOIN()
C. CONCAT()
D. CONCATENATE()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Both A and B
B. Ctrl + Y
C. F4
D. Ctrl + R
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Description
B. Status Bar Text
C. Caption
D. Default Value
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Ctrl + Alt + F5
B. F5
C. Alt + F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. If B1 is zero
B. Only if #DIV/0!
C. A1/B1 results in any error value
D. If A1 is blank
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. .potx
B. .ppsx
C. .jpg (via Save As type)
D. .pptx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Prompts for input
B. Aggregates data and displays it with row and column headings (like a pivot)
C. Creates a new table
D. Deletes records based on criteria
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Alt + H
B. F2
C. Ctrl + H
D. F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. View -> Split
B. Both A and B
C. Window -> New Window
D. Review -> Compare
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Prevent any entry
C. Convert numbers to text, but formulas can still calculate
D. Display the entered data exactly as typed, not as a number/date
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option C

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. Cascade Delete Related Records
B. Allow Nulls
C. Enforce Referential Integrity
D. Cascade Update Related Fields
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. F2
B. Ctrl + Alt + M
C. Shift + F2
D. Ctrl + Shift + M
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. Select range, type name in Name Box and press Enter
B. Both A and B
C. Insert -> Name
D. Formulas -> Define Name
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Apply zoom animation
D. Zoom in on object during presentation
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. In the detail section
B. Only once at the very top of the printout
C. At the top of every page
D. At the top of the form, often used for title or logo
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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
Internet and Web Technologies 461 Computer Hardware 430 Microsoft Office 1199 Computer Abbreviations 369 Operating Systems 510
Explore Subjects
Static General Knowledge 6362 Reasoning 2064 Current Affairs 575 Science 4430 English 15164
Practice Mix
Which of the following is a major source of tax revenue for the Central Government?
Two numbers are in the ratio 11:5 and their sum is 789. Find the numbers.
Which of the following is a characteristic of the 'Lodi' style of architecture?
In a class of 50 students, 60% are boys. Number of girls is:
Select the most appropriate meaning of the idiom: 'In the doldrums'.