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 40 of 60
Question #781
In MS Access, the default value of the 'Required' property for a field is:
A. Null
B. No
C. Yes
D. Maybe
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
By default, fields are not required; Required = No.
This question belongs to: Computer Microsoft Office
Question #782
To select all the text in a document, press:
A. Ctrl + S
B. Ctrl + Shift + A
C. Ctrl + Alt + A
D. Ctrl + A
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+A selects all.
This question belongs to: Computer Microsoft Office
Question #783
In Excel, which function returns the number of days between two dates?
A. DATEDIF()
B. DAYS()
C. Both A and C
D. NETWORKDAYS()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DAYS(end, start) returns days. DATEDIF(start, end, "d") also returns days. NETWORKDAYS returns workdays.
This question belongs to: Computer Microsoft Office
Question #784
Which of the following is NOT a valid file format to save a PowerPoint presentation?
A. .pptx
B. .ppsx
C. .pdf
D. .xps
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.xps is XML Paper Specification, not a PowerPoint save format (though you can export as XPS). But typical save-as formats: pptx, ppt, pdf, ppsx. However, you can save as XPS from Office. I'll avoid ambiguous. I'll change: .wav is not a presentation format. I'll ask: Which is not a presentation file format? Options: .pptx, .ppsx, .potx, .wav. Answer D. So I'll adjust.
This question belongs to: Computer Microsoft Office
Question #785
Which of the following file extensions is NOT associated with MS PowerPoint?
A. .potx
B. .pptx
C. .ppsx
D. .wav
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.wav is an audio file, not a PowerPoint file.
This question belongs to: Computer Microsoft Office
Question #786
In MS Access, to enforce that a child record cannot be added unless a parent record exists, you set:
A. Indexed (No Duplicates)
B. Primary Key
C. Cascade Update
D. Enforce Referential Integrity
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Referential Integrity ensures related records exist before allowing entry.
This question belongs to: Computer Microsoft Office
Question #787
What is the shortcut to copy selected text to the clipboard?
A. Ctrl + D
B. Ctrl + V
C. Ctrl + C
D. Ctrl + X
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+C copies. Ctrl+X cuts, Ctrl+V pastes.
This question belongs to: Computer Microsoft Office
Question #788
In Excel, what is the result of the expression =3^2?
A. Error
B. 6
C. 8
D. 9
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Caret (^) is the exponentiation operator; 3^2 = 9.
This question belongs to: Computer Microsoft Office
Question #789
In MS Word, which option is used to add a bibliography?
A. Insert tab -> Citation
B. Layout tab -> References
C. References tab -> Bibliography
D. Review tab -> Sources
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Bibliography is inserted from the References tab after inserting citations.
This question belongs to: Computer Microsoft Office
Question #790
In PowerPoint, how can you hide the slide thumbnails pane?
A. Drag the splitter bar to the left or click the X on the pane
B. Press Ctrl + Shift + H
C. Design tab -> Layout
D. View tab -> Slide Thumbnails
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can resize or close the thumbnail pane by dragging or clicking the close button.
This question belongs to: Computer Microsoft Office
Question #791
In MS Access, the expression to calculate current date plus 30 days in a query is:
A. CurrentDate() + 30
B. Date() + 30
C. Today() + 30
D. Now() + 30
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Date() returns current date. Adding 30 gives date 30 days ahead.
This question belongs to: Computer Microsoft Office
Question #792
To close an active workbook in Excel, you can use:
A. Ctrl + F4
B. Alt + F4
C. Both A and B
D. Ctrl + W
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+W and Ctrl+F4 close the workbook window. Alt+F4 exits Excel.
This question belongs to: Computer Microsoft Office
Question #793
In MS Word, the shortcut to apply double underline is:
A. Ctrl + U
B. Ctrl + Alt + D
C. Ctrl + Shift + D
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+D applies double underline. Ctrl+U single underline.
This question belongs to: Computer Microsoft Office
Question #794
In Excel, which function returns the serial number of a specific date given year, month, day?
A. DATE()
B. NOW()
C. TODAY()
D. DATEVALUE()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DATE(year, month, day) constructs a date.
This question belongs to: Computer Microsoft Office
Question #795
Which of the following is NOT a type of animation effect in PowerPoint?
A. Entrance
B. Transition
C. Exit
D. Emphasis
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Transition is a slide change effect, not an object animation. The four animation types: Entrance, Emphasis, Exit, Motion Paths.
This question belongs to: Computer Microsoft Office
Question #796
In MS Access, to permanently remove a table and all its data, you should:
A. Delete the table object
B. Use a Make-Table query
C. Use a Delete query
D. Clear all records
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Deleting the table object removes structure and data. Delete query only removes records.
This question belongs to: Computer Microsoft Office
Question #797
In MS Word, how can you quickly increase indent of a paragraph?
A. Press Ctrl + T
B. Press Ctrl + M
C. Press Tab at the beginning of the paragraph
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+M increases left indent; Tab at start of paragraph increases first-line indent (if allowed). But both increase indentation. So C.
This question belongs to: Computer Microsoft Office
Question #798
In Excel, which function would you use to find the position of 'at' in the text 'Education'?
A. MATCH("at", "Education")
B. Both A and B
C. FIND("at", "Education")
D. SEARCH("at", "Education")
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both SEARCH and FIND return the starting position. SEARCH is case-insensitive, FIND is case-sensitive.
This question belongs to: Computer Microsoft Office
Question #799
In PowerPoint, what is the purpose of the 'Format Background' option?
A. Applies a theme to all slides
B. Formats text and shapes
C. Allows you to change the background fill of the slide
D. Adds a background music
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Format Background changes slide background color, gradient, picture, etc.
This question belongs to: Computer Microsoft Office
Question #800
In MS Access, which view is used to modify the design of a form (add controls)?
A. Design View
B. Datasheet View
C. Form View
D. Layout View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Design View allows adding and positioning controls. Layout View also allows some changes but Design View is primary.
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?'