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 46 of 60
Question #901
In MS Access, which data type should you choose to store a web address?
A. Text
B. Memo
C. Attachment
D. Hyperlink
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Hyperlink data type stores URLs.
This question belongs to: Computer Microsoft Office
Question #902
What is the keyboard shortcut to open the 'Font' dialog box in MS Word?
A. Ctrl + Shift + F
B. Ctrl + F
C. Both A and B
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+D opens Font dialog. Ctrl+Shift+F also opens Font dialog with Font tab selected.
This question belongs to: Computer Microsoft Office
Question #903
In Excel, the 'Paste Special' dialog can be opened with:
A. Ctrl + Shift + V
B. Alt + E, S
C. Ctrl + Alt + V
D. Both A and C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+V opens Paste Special. Alt+E,S also opens it (legacy).
This question belongs to: Computer Microsoft Office
Question #904
In PowerPoint, what is the extension of a PowerPoint template?
A. .pptm
B. .potx
C. .ppsx
D. .pptx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.potx is template.
This question belongs to: Computer Microsoft Office
Question #905
In MS Access, which type of query makes a new table?
A. Update query
B. Make-Table query
C. Select query
D. Append query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Make-Table creates new table from query results.
This question belongs to: Computer Microsoft Office
Question #906
Which shortcut key is used to center align text in MS Word?
A. Ctrl + R
B. Ctrl + E
C. Ctrl + J
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+E centres, Ctrl+L left, Ctrl+R right, Ctrl+J justify.
This question belongs to: Computer Microsoft Office
Question #907
In Excel, which function returns the number of days in a month?
A. DAYSINMONTH()
B. EOMONTH() with DAY()
C. EDATE()
D. MONTH()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
There is no direct function; you can use =DAY(EOMONTH(date,0)).
This question belongs to: Computer Microsoft Office
Question #908
In PowerPoint, to hide the slide thumbnails pane, you can:
A. Go to View -> Slide Thumbnails
B. Click the X at the top right of the pane or drag the splitter
C. Press Ctrl + F1
D. Right-click slide and Hide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Close or resize the thumbnails pane.
This question belongs to: Computer Microsoft Office
Question #909
In MS Access, which property defines the pattern for data entry (like phone number)?
A. Input Mask
B. Format
C. Default Value
D. Validation Rule
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Input Mask controls entry format.
This question belongs to: Computer Microsoft Office
Question #910
To create a hanging indent in MS Word, press:
A. Ctrl + M
B. Ctrl + T
C. Tab
D. Ctrl + Shift + T
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.
This question belongs to: Computer Microsoft Office
Question #911
In Excel, what does the formula =SUMIF(A1:A10, ">5") do?
A. Counts cells greater than 5
B. Sums values in A1:A10 that are greater than 5
C. Returns error
D. Sums all values and adds 5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SUMIF with criteria ">5" sums cells >5 in the range.
This question belongs to: Computer Microsoft Office
Question #912
In PowerPoint, 'Embed fonts' option is available under:
A. Design -> Fonts
B. View -> Slide Master
C. Insert -> Text -> Font
D. File -> Options -> Save
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Embed fonts is in PowerPoint Options, Save section.
This question belongs to: Computer Microsoft Office
Question #913
In MS Access, the 'Expression Builder' helps to:
A. Generate reports
B. Build SQL queries graphically
C. Design forms visually
D. Create calculated fields, validation rules, and query criteria
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Expression Builder assists in writing expressions.
This question belongs to: Computer Microsoft Office
Question #914
What is the default file extension of a macro-enabled PowerPoint presentation?
A. .pptx
B. .potm
C. .ppsm
D. .pptm
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.pptm is macro-enabled presentation. .ppsm macro-enabled show.
This question belongs to: Computer Microsoft Office
Question #915
In MS Word, the 'Equation' tool is used to insert:
A. Mathematical equations and formulas
B. Statistical charts
C. SmartArt graphics
D. Chemical equations only
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Equation under Insert tab allows mathematical notation.
This question belongs to: Computer Microsoft Office
Question #916
In Excel, the keyboard shortcut to edit a cell comment (note) is:
A. Ctrl + F2
B. F2
C. Alt + F2
D. Shift + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F2 inserts or edits comment.
This question belongs to: Computer Microsoft Office
Question #917
Which of the following is a 'view' available for slides in PowerPoint?
A. Slide Sorter
B. All of these
C. Normal
D. Outline
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All are views.
This question belongs to: Computer Microsoft Office
Question #918
In MS Access, what is the maximum number of fields in a table?
A. 256
B. 255
C. 64
D. 1,000
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An Access table can have up to 255 fields.
This question belongs to: Computer Microsoft Office
Question #919
To quickly find the sum of selected cells in Excel, look at:
A. Name box
B. Status bar
C. Formula bar
D. Title bar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When you select numeric cells, the status bar displays Sum, Average, Count.
This question belongs to: Computer Microsoft Office
Question #920
In MS Word, 'Shrink One Page' command attempts to:
A. Delete the last page
B. Zoom out
C. Reduce the document by one page by adjusting font size and spacing
D. Print the document on one page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shrink One Page (Print Preview) reduces content to fit one less page.
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: