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 41 of 60
Question #801
What is the shortcut to open the 'Spelling & Grammar' dialog in MS PowerPoint?
A. Alt + F7
B. Shift + F7
C. Ctrl + F7
D. F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F7 works in PowerPoint for spelling check.
This question belongs to: Computer Microsoft Office
Question #802
In MS Word, what does a green wavy underline indicate?
A. Spelling mistake
B. Contextual spelling error
C. Formatting inconsistency
D. Possible grammatical error
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Green wavy underline flags grammar issues. Red wavy underline is spelling, blue for contextual spelling.
This question belongs to: Computer Microsoft Office
Question #803
In Excel, to enter the same data into multiple selected cells at once, type the data and press:
A. Enter
B. Alt + Enter
C. Ctrl + Enter
D. Shift + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Enter fills all selected cells with the entered data.
This question belongs to: Computer Microsoft Office
Question #804
Which of the following is a valid layout for a chart in Excel?
A. All of these are elements, not layouts
B. Chart Title above chart
C. Legend at bottom
D. Data labels inside end
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Chart layouts are combinations of chart elements. These are individual elements, but layouts include them. However, the question asks valid layout, but options are elements. I'll reframe: 'Which of the following is a chart element that can be added or removed?' and answer D 'All of these'. I'll adjust.
This question belongs to: Computer Microsoft Office
Question #805
Which of the following is a chart element in Excel that can be added or removed?
A. All of these
B. Legend
C. Data Labels
D. Chart Title
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Chart Title, Legend, Data Labels, Axis Titles, etc., are all chart elements.
This question belongs to: Computer Microsoft Office
Question #806
In PowerPoint, to compress all images in a presentation to reduce file size, use:
A. View -> Slide Master
B. Design -> Compress Media
C. File -> Compress Pictures (under Save As Tools) or Picture Format -> Compress Pictures
D. Insert -> Picture -> Compress
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compress Pictures option is available in Picture Format tab or via File > Save As > Tools.
This question belongs to: Computer Microsoft Office
Question #807
In MS Access, the 'Allow Zero Length' property is used for:
A. Text fields to permit an empty string ('')
B. Yes/No fields to allow unchecked
C. Number fields to allow zero
D. Date fields to allow null
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Allow Zero Length, when set to Yes, allows a text field to contain an empty string distinct from Null.
This question belongs to: Computer Microsoft Office
Question #808
To go to the previous page in a Word document, press:
A. Ctrl + Page Up
B. Page Up
C. Ctrl + Up Arrow
D. Alt + Page Up
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.
This question belongs to: Computer Microsoft Office
Question #809
In Excel, which of the following is a valid way to refer to an entire column A?
A. A
B. A:A
C. A1:A1048576
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A:A refers to entire column. A1:A1048576 also covers entire column (max rows).
This question belongs to: Computer Microsoft Office
Question #810
In MS Word, the 'Compare' feature is used to:
A. Measure reading level
B. Compare document with a template
C. Compare two versions of a document and show differences
D. Check grammar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compare (Review tab) merges and highlights changes between two documents.
This question belongs to: Computer Microsoft Office
Question #811
In PowerPoint, which key can be used to white out the screen during a presentation?
A. P
B. Esc
C. W
D. B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
W displays a white screen; B black screen.
This question belongs to: Computer Microsoft Office
Question #812
In MS Access, the data type that can store files like Word documents or images within a record is:
A. OLE Object
B. Memo
C. Hyperlink
D. Attachment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Attachment is the modern data type for storing multiple files. OLE Object is older but also stores objects; but Attachment is more versatile.
This question belongs to: Computer Microsoft Office
Question #813
Which shortcut key toggles the display of non-printing characters (¶) in MS Word?
A. F8
B. Ctrl + Alt + *
C. Ctrl + *
D. Ctrl + Shift + *
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+* (i.e., Ctrl+Shift+8) shows/hides formatting marks.
This question belongs to: Computer Microsoft Office
Question #814
In PowerPoint, what does the 'Animation Painter' do?
A. Creates a sequence of animations
B. Copies animation effects from one object to another
C. Applies animation to all slides
D. Copies slide layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Animation Painter (similar to Format Painter) copies animation settings.
This question belongs to: Computer Microsoft Office
Question #815
In MS Access, which of the following is NOT an action query?
A. Update query
B. Delete query
C. Select query
D. Append query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Select queries retrieve data; they do not modify data. Action queries modify data.
This question belongs to: Computer Microsoft Office
Question #816
What is the maximum number of columns in a table in MS Word?
A. 256
B. 63
C. No limit
D. 10
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Word table can have up to 63 columns.
This question belongs to: Computer Microsoft Office
Question #817
In Excel, which function converts a text string to proper case (first letter capitalized)?
A. SENTENCE()
B. PROPER()
C. UPPER()
D. LOWER()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
PROPER capitalizes the first letter of each word.
This question belongs to: Computer Microsoft Office
Question #818
In PowerPoint, which option under File menu saves the presentation as a PDF?
A. Both A and B
B. Export -> Create PDF/XPS Document
C. Print to PDF
D. Save As and choose PDF from type
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both Export and Save As allow saving as PDF.
This question belongs to: Computer Microsoft Office
Question #819
In MS Access, the 'Cascade Update Related Fields' option will:
A. Copy the primary key to child table
B. Delete related records when the primary record is deleted
C. Automatically update the foreign key in related records when the primary key is changed
D. Prevent deletion of records that have related records
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Cascade Update updates foreign keys. Cascade Delete deletes related records.
This question belongs to: Computer Microsoft Office
Question #820
To move to the next pane in a split worksheet in Excel, press:
A. F6
B. Ctrl + Tab
C. Tab
D. Alt + F6
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F6 moves between panes in a split worksheet.
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?'