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 47 of 60
Question #921
In PowerPoint, to display the on-screen keyboard shortcuts during a presentation, press:
A. Ctrl + /
B. F1
C. Esc
D. Shift + ?
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F1 during slide show shows a list of keyboard shortcuts.
This question belongs to: Computer Microsoft Office
Question #922
In MS Access, the 'Report Wizard' allows you to:
A. Design a table
B. Write SQL for a report
C. Create macros for reporting
D. Create a report quickly by selecting fields, grouping, and layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Report Wizard steps through report creation.
This question belongs to: Computer Microsoft Office
Question #923
In MS Word, which of the following is not a valid file format to save a document?
A. .pdf
B. .docx
C. .txt
D. .xlsx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.xlsx is Excel format; Word cannot save as .xlsx directly.
This question belongs to: Computer Microsoft Office
Question #924
In Excel, the function =OFFSET(A1,1,2) returns the value of cell:
A. C1
B. A2
C. B2
D. C2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
OFFSET(A1,1 row down, 2 columns right) gives C2.
This question belongs to: Computer Microsoft Office
Question #925
In PowerPoint, the 'Design Ideas' feature suggests:
A. Transition timings
B. Animation effects
C. Slide master edits
D. Professional layouts and design options for slides
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Design Ideas (Office 365) provides automatic design suggestions.
This question belongs to: Computer Microsoft Office
Question #926
In MS Access, to add a calculated field in a query, you:
A. Use the Append query
B. Type an expression in a blank column of the query design grid
C. Both A and B
D. Use the Expression Builder in the Field row
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can type directly or use Expression Builder.
This question belongs to: Computer Microsoft Office
Question #927
What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel?
A. F2
B. Ctrl + 1
C. F4
D. Alt + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F4 cycles through reference types in formula edit mode.
This question belongs to: Computer Microsoft Office
Question #928
In MS Word, what does the 'Split' feature do?
A. Separates a paragraph
B. Divides the document window into two panes for viewing different parts of the same document
C. Splits a table into two
D. Divides a document into columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Split (View tab) creates two independent scrolling panes.
This question belongs to: Computer Microsoft Office
Question #929
In Excel, which function returns the year from a date?
A. YEAR()
B. YEARFRAC()
C. DAY()
D. MONTH()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
YEAR(serial_number) returns year.
This question belongs to: Computer Microsoft Office
Question #930
In PowerPoint, to insert a chart, go to:
A. Transitions -> Chart
B. Design -> Chart
C. Animations -> Chart
D. Insert -> Chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Charts are inserted from the Insert tab.
This question belongs to: Computer Microsoft Office
Question #931
In MS Access, which of the following is NOT a valid section in a report?
A. Report Footer
B. Page Header
C. Detail
D. Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Navigation Pane is an interface element, not a report section. Sections include Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer.
This question belongs to: Computer Microsoft Office
Question #932
The shortcut to switch between open workbooks in Excel is:
A. Both A and C
B. Alt + Tab
C. Ctrl + Tab
D. Ctrl + F6
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Tab and Ctrl+F6 switch between open Excel workbook windows.
This question belongs to: Computer Microsoft Office
Question #933
In MS Word, which feature allows you to insert a preformatted cover page?
A. Insert -> Cover Page
B. References -> Index
C. Layout -> Breaks
D. Design -> Page Background
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Cover Page is under Insert tab.
This question belongs to: Computer Microsoft Office
Question #934
In Excel, which keyboard shortcut extends the selection to the last non-blank cell in the same column or row?
A. Ctrl + Arrow key
B. Ctrl + Shift + Arrow key
C. Shift + Arrow key
D. Ctrl + Space
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+Arrow extends selection to the edge of data region.
This question belongs to: Computer Microsoft Office
Question #935
In PowerPoint, the 'Zoom' feature (Summary Zoom, Slide Zoom, Section Zoom) is found under:
A. Slide Show -> Zoom
B. Insert -> Zoom
C. View -> Zoom
D. Design -> Zoom
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Zoom is under Insert tab (available in newer versions).
This question belongs to: Computer Microsoft Office
Question #936
In MS Access, to create a form that looks like a datasheet, set the form's Default View to:
A. Datasheet
B. Single Form
C. Continuous Forms
D. Split Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Default View property can be set to Datasheet.
This question belongs to: Computer Microsoft Office
Question #937
What is the shortcut to open a new blank document in MS Word?
A. Ctrl + S
B. Ctrl + N
C. Ctrl + O
D. Ctrl + Alt + N
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+N new document.
This question belongs to: Computer Microsoft Office
Question #938
In Excel, the error '#DIV/0!' occurs when:
A. Invalid reference
B. A formula divides by zero or an empty cell
C. Name not recognized
D. Value not available
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
#DIV/0! division by zero.
This question belongs to: Computer Microsoft Office
Question #939
In PowerPoint, which of the following can be a slide transition effect?
A. Push
B. Fade
C. All of these
D. Morph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All are transition effects.
This question belongs to: Computer Microsoft Office
Question #940
In MS Access, what is the purpose of the 'Database Splitter'?
A. Divides a table into two
B. Splits a database into front-end (forms, reports) and back-end (tables) for multi-user environment
C. Splits a query into multiple parts
D. Creates a backup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Database Splitter separates objects to improve performance in shared environments.
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: