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. Shift + ?
C. F1
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Create macros for reporting
B. Create a report quickly by selecting fields, grouping, and layout
C. Write SQL for a report
D. Design a table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. .xlsx
B. .docx
C. .pdf
D. .txt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. C2
B. C1
C. A2
D. B2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Professional layouts and design options for slides
C. Slide master edits
D. Animation effects
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Type an expression in a blank column of the query design grid
B. Use the Expression Builder in the Field row
C. Use the Append query
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Alt + Enter
B. F4
C. F2
D. Ctrl + 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Divides a document into columns
B. Separates a paragraph
C. Splits a table into two
D. Divides the document window into two panes for viewing different parts of the same document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. DAY()
B. YEARFRAC()
C. MONTH()
D. YEAR()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
YEAR(serial_number) returns year.
This question belongs to: Computer Microsoft Office
Question #930
In PowerPoint, to insert a chart, go to:
A. Design -> Chart
B. Transitions -> 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. Navigation Pane
C. Page Header
D. Detail
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Alt + Tab
B. Ctrl + Tab
C. Ctrl + F6
D. Both A and C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Design -> Page Background
C. Layout -> Breaks
D. References -> Index
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 + Space
C. Shift + Arrow key
D. Ctrl + Shift + Arrow key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Insert -> Zoom
B. View -> Zoom
C. Slide Show -> Zoom
D. Design -> Zoom
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Continuous Forms
B. Datasheet
C. Single Form
D. Split Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Value not available
D. Name not recognized
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. Morph
C. Fade
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Creates a backup
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. Divides a table into two
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
Programming Languages 0 Operating Systems 510 Cyber Security 269 Memory and Storage Devices 438 CPU (Central Processing Unit) 327
Explore Subjects
Science 4430 Accountancy and Statistics 3179 Maths 5575 History GK 3374 Static General Knowledge 6362
Practice Mix
The Treaty of Chittorgarh was signed between:
Which of the following regions in India receives less than 50 cm of annual rainfall?
_____ you are prepared, you can face the interview.
Not only the teacher but also the students ________ present.
I need ___ one-way ticket.