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 58 of 60
Question #1141
In MS Access, a 'Make-Table' query is an example of:
A. Action query
B. Select query
C. Parameter query
D. Crosstab query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Action queries modify data or structure.
This question belongs to: Computer Microsoft Office
Question #1142
Which of the following is NOT a valid slide transition in PowerPoint?
A. Wipe
B. Push
C. Fly In
D. Fade
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Fly In is an animation, not a transition.
This question belongs to: Computer Microsoft Office
Question #1143
In MS Word, to delete a word to the left of the cursor, press:
A. Ctrl + Backspace
B. Backspace
C. Delete
D. Ctrl + Delete
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Backspace deletes the previous word.
This question belongs to: Computer Microsoft Office
Question #1144
In Excel, to copy a formula without changing relative references, you can:
A. Use Ctrl + R
B. Paste exact formula by editing in formula bar, copy, or use absolute references
C. Use Ctrl + D
D. Use Ctrl + ' to copy formula from above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
To copy exact formula text, edit cell, select all text, copy. Or use absolute references.
This question belongs to: Computer Microsoft Office
Question #1145
In MS Word, the shortcut for 'Select All' is:
A. Ctrl + Alt + A
B. Ctrl + Shift + A
C. Ctrl + A
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+A selects all.
This question belongs to: Computer Microsoft Office
Question #1146
In PowerPoint, which shortcut key opens the 'Slide Show' tab?
A. Alt + H
B. Alt + D
C. Alt + S
D. Alt + W
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt+S for Slide Show tab.
This question belongs to: Computer Microsoft Office
Question #1147
In MS Access, the 'SQL View' of a query shows:
A. The macro code
B. The SQL statement defining the query
C. The query output
D. The query design grid
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SQL View displays SQL.
This question belongs to: Computer Microsoft Office
Question #1148
Which function key is used to go to the next pane in a split window in Excel?
A. F6
B. F7
C. F5
D. F8
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F6 moves to next pane.
This question belongs to: Computer Microsoft Office
Question #1149
In Excel, which function is used to return the number of whole workdays between two dates (excluding weekends and holidays)?
A. WORKDAY()
B. DATEDIF()
C. DAYS()
D. NETWORKDAYS()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NETWORKDAYS returns workdays. WORKDAY returns a date after number of workdays.
This question belongs to: Computer Microsoft Office
Question #1150
In PowerPoint, what is the 'Presenter View'?
A. A normal editing view
B. A view for slide sorter
C. A view that shows the current slide, next slide, notes, and timer on the presenter's screen
D. A view for the audience
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Presenter View aids speaker.
This question belongs to: Computer Microsoft Office
Question #1151
In MS Access, which data type would you use to store a web address?
A. Hyperlink
B. Short Text
C. URL
D. Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Hyperlink stores URLs.
This question belongs to: Computer Microsoft Office
Question #1152
What is the shortcut to open the 'Find and Replace' dialog with Go To tab in Word?
A. Ctrl + G
B. Ctrl + F
C. Both A and B
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+G or F5 opens Go To.
This question belongs to: Computer Microsoft Office
Question #1153
In MS Word, the 'Ctrl + D' shortcut opens:
A. Date picker
B. Font dialog
C. Paragraph dialog
D. Document properties
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+D opens Font dialog.
This question belongs to: Computer Microsoft Office
Question #1154
In Excel, the function =COLUMN() in cell D5 returns:
A. 4
B. Error
C. D
D. 5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Column D is 4th column.
This question belongs to: Computer Microsoft Office
Question #1155
In PowerPoint, to add a table, go to:
A. View -> Table
B. Insert -> Table
C. Design -> Table
D. Home -> Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Insert tab -> Table.
This question belongs to: Computer Microsoft Office
Question #1156
In MS Access, what is the primary purpose of a 'form'?
A. To provide a user-friendly interface for data entry and editing
B. To search data only
C. To print data
D. To store data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms are for data interaction.
This question belongs to: Computer Microsoft Office
Question #1157
Which shortcut key is used to switch between open programs in Windows?
A. Ctrl + Tab
B. Windows + Tab
C. Shift + Tab
D. Alt + Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+Tab switches between open applications.
This question belongs to: Computer Microsoft Office
Question #1158
In MS Word, to insert the current time, press:
A. Alt + T
B. Alt + Shift + T
C. Ctrl + T
D. Ctrl + Shift + ;
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Shift+T inserts a TIME field.
This question belongs to: Computer Microsoft Office
Question #1159
In Excel, the 'Status Bar' can display:
A. Formula
B. Sum, Average, Count of selected cells
C. Cell reference
D. Ribbon commands
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Status bar shows quick calculations.
This question belongs to: Computer Microsoft Office
Question #1160
In PowerPoint, to apply a design theme, go to:
A. View -> Themes
B. Home -> Themes
C. Insert -> Themes
D. Design -> Themes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Themes under Design tab.
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: