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 54 of 60
Question #1061
In MS Access, a 'split form' combines:
A. Two different tables
B. Query and form
C. Form view and Datasheet view on one screen
D. Form and report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Split form shows a single form and a datasheet simultaneously.
This question belongs to: Computer Microsoft Office
Question #1062
To insert a row above the selected row in Excel, press:
A. Ctrl + Shift + + (plus)
B. Alt + I, R
C. Ctrl + +
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these shortcuts can insert a row when a row is selected.
This question belongs to: Computer Microsoft Office
Question #1063
In MS Word, the 'Format Painter' shortcut to paste formatting is:
A. Ctrl + Alt + V
B. F4
C. Ctrl + Shift + V
D. Ctrl + V
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+V pastes formatting only.
This question belongs to: Computer Microsoft Office
Question #1064
In Excel, which function returns the smallest number in a range that meets a condition?
A. DMIN()
B. MINIF()
C. MINIFS()
D. SMALLIF()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MINIFS returns minimum based on criteria.
This question belongs to: Computer Microsoft Office
Question #1065
In PowerPoint, the shortcut to open the 'Set Up Slide Show' dialog is:
A. Shift + F5
B. Alt + S, T (ribbon shortcut)
C. F5
D. Ctrl + Shift + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
No direct single key; Alt+S, T is the key tip sequence.
This question belongs to: Computer Microsoft Office
Question #1066
In MS Access, a 'Navigation form' is used to:
A. Create tables
B. Provide a menu system to open forms and reports
C. Enter data
D. Print reports
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Navigation form acts as a switchboard.
This question belongs to: Computer Microsoft Office
Question #1067
What is the shortcut to print a document in MS Word?
A. Ctrl + F2
B. Ctrl + P
C. Both A and B
D. Alt + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+P and Ctrl+F2 both open Print.
This question belongs to: Computer Microsoft Office
Question #1068
In Excel, which function rounds a number down to the nearest integer?
A. ROUNDDOWN()
B. INT()
C. All of these
D. FLOOR()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
INT rounds down to integer. ROUNDDOWN to number of digits. FLOOR rounds down to multiple. All round down.
This question belongs to: Computer Microsoft Office
Question #1069
In MS Word, the 'Research' feature can be accessed by:
A. Both A and B
B. Review -> Research
C. Alt + Click on a word
D. Shift + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+click or Review tab.
This question belongs to: Computer Microsoft Office
Question #1070
In PowerPoint, the 'Gridlines' option helps to:
A. Create a table
B. Draw shapes
C. Add a chart
D. Align objects precisely on the slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Gridlines are non-printing lines for alignment.
This question belongs to: Computer Microsoft Office
Question #1071
In MS Access, the 'Validation Text' property is used to:
A. Define the input mask
B. Format the field
C. Display a custom error message when the validation rule is violated
D. Set the default value
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Validation Text provides a message.
This question belongs to: Computer Microsoft Office
Question #1072
Which of the following is the correct key to exit a submenu or cancel an operation in MS Office?
A. Tab
B. Esc
C. Shift + Tab
D. Alt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Esc cancels.
This question belongs to: Computer Microsoft Office
Question #1073
In Excel, the formula =A1&B1 will result in:
A. Error
B. Concatenation of values in A1 and B1 without space
C. Sum of A1 and B1
D. Logical AND
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
& concatenates text.
This question belongs to: Computer Microsoft Office
Question #1074
In PowerPoint, which of the following is a standard slide show navigation key?
A. N for next slide
B. B for next slide
C. Both A and B
D. P for previous slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
N next, P previous, also arrow keys.
This question belongs to: Computer Microsoft Office
Question #1075
In MS Access, what is the purpose of the 'Database Documenter'?
A. Creates a report detailing the structure of selected database objects
B. Creates a user manual
C. Documents relationships
D. Writes documentation for VBA code
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Database Documenter prints object definitions.
This question belongs to: Computer Microsoft Office
Question #1076
To go to the next cell in a table in MS Word, press:
A. Shift + Tab
B. Arrow Right
C. Tab
D. Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Tab moves forward; Shift+Tab backward.
This question belongs to: Computer Microsoft Office
Question #1077
In Excel, the 'IF' function falls under which category?
A. Information
B. Logical
C. Statistical
D. Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
IF is a logical function.
This question belongs to: Computer Microsoft Office
Question #1078
In MS Word, the shortcut to apply normal style is:
A. Ctrl + Alt + N
B. Ctrl + Shift + N
C. Ctrl + N
D. Alt + Shift + N
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+N applies Normal style.
This question belongs to: Computer Microsoft Office
Question #1079
In PowerPoint, to create a photo album, go to:
A. Design -> Photo Album
B. Insert -> Photo Album
C. View -> Photo Album
D. Home -> Album
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Photo Album is an Insert option.
This question belongs to: Computer Microsoft Office
Question #1080
In MS Access, which object is used to define a custom task that runs automatically?
A. Query
B. Macro
C. Module
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Macros automate tasks.
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: