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 48 of 60
Question #941
Which of the following key combinations is used to move the cursor to the beginning of the previous word in MS Word?
A. Alt + Left Arrow
B. Ctrl + Right Arrow
C. Ctrl + Left Arrow
D. Shift + Left Arrow
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Left moves to previous word.
This question belongs to: Computer Microsoft Office
Question #942
In Excel, which function returns the largest number in a range that meets a condition?
A. MAXIFS()
B. LARGEIF()
C. MAXIF()
D. DMAX()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MAXIFS (Excel 2019+) returns maximum based on criteria.
This question belongs to: Computer Microsoft Office
Question #943
In MS Word, which option is used to insert a list of figures?
A. Insert -> Table
B. Review -> Table of Figures
C. Layout -> Figures
D. References -> Insert Table of Figures
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Table of Figures is under References.
This question belongs to: Computer Microsoft Office
Question #944
In PowerPoint, to make a presentation run automatically without manual advance, set:
A. Animations -> Duration
B. Both A and B
C. Transitions -> Advance Slide -> After (enter seconds)
D. Slide Show -> Set Up Show -> Browsed at a kiosk
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Set slide advance timing and optionally set kiosk mode for unattended playback.
This question belongs to: Computer Microsoft Office
Question #945
In MS Access, to import data from another Access database, use:
A. File -> Open
B. Database Tools -> Import
C. Create -> Import Table
D. External Data -> Access
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
External Data tab has import from Access.
This question belongs to: Computer Microsoft Office
Question #946
What does the 'Ctrl + 0' (zero) shortcut do in MS Word?
A. Adds or removes one line space before a paragraph
B. Sets font size to 0
C. Clears formatting
D. Hides the selected text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+0 toggles 12-point space before a paragraph.
This question belongs to: Computer Microsoft Office
Question #947
In PowerPoint, 'Slide Master' is used to:
A. Insert media
B. Make universal style changes to all slides
C. Apply transitions
D. Create a new slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Master controls the look of all slides.
This question belongs to: Computer Microsoft Office
Question #948
In MS Access, a 'Select query' retrieves data based on criteria and:
A. Displays the results in a datasheet
B. Creates a new table
C. Deletes matching records
D. Updates records
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Select query shows a dynaset of records.
This question belongs to: Computer Microsoft Office
Question #949
Which of the following is the file extension for a Microsoft Excel template?
A. .xlsx
B. .xls
C. .xlsm
D. .xltx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.xltx is Excel template.
This question belongs to: Computer Microsoft Office
Question #950
In MS Word, to remove a hyperlink but keep the text, right-click and select:
A. Edit Hyperlink -> Remove
B. Remove Hyperlink
C. Delete Link
D. Ctrl + Shift + F9
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Right-click the hyperlink and choose Remove Hyperlink. Ctrl+Shift+F9 also removes hyperlink field codes.
This question belongs to: Computer Microsoft Office
Question #951
In Excel, which function is used to perform a vertical lookup with approximate match?
A. XLOOKUP
B. INDEX MATCH
C. HLOOKUP
D. VLOOKUP(lookup_value, table_array, col_index, TRUE)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
VLOOKUP with TRUE (or omitted) performs approximate match.
This question belongs to: Computer Microsoft Office
Question #952
In PowerPoint, to insert a 3D model, go to:
A. View -> 3D
B. Insert -> 3D Models
C. Design -> 3D
D. Animations -> 3D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
3D Models are inserted from Insert tab (if supported).
This question belongs to: Computer Microsoft Office
Question #953
In MS Access, the 'AutoExec' macro:
A. Creates an executable file
B. Runs automatically when the database is opened
C. Executes a series of queries
D. Is a reserved name for export
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A macro named AutoExec runs on database open.
This question belongs to: Computer Microsoft Office
Question #954
What is the shortcut to save as in MS Office?
A. F12
B. Shift + F12
C. Both A and C
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F12 opens Save As. Shift+F12 saves (same as Ctrl+S). So only F12.
This question belongs to: Computer Microsoft Office
Question #955
In MS Word, what is the default paragraph alignment?
A. Centre
B. Justify
C. Left
D. Right
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Default alignment is left.
This question belongs to: Computer Microsoft Office
Question #956
In Excel, the 'PMT' function calculates:
A. Future value
B. Present value
C. Loan payment amount
D. Interest rate
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
PMT returns periodic payment.
This question belongs to: Computer Microsoft Office
Question #957
In PowerPoint, which of the following shortcuts opens the 'Slide Show' tab?
A. Alt + S
B. Alt + W
C. Ctrl + S
D. Alt + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+S opens the Slide Show tab (Key Tip).
This question belongs to: Computer Microsoft Office
Question #958
In MS Access, to create a button that opens a form, you would use:
A. Macro
B. Module
C. Command Button Wizard in form design
D. Hyperlink
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Command Button wizard can open forms, run macros, etc.
This question belongs to: Computer Microsoft Office
Question #959
To select a sentence in MS Word, hold Ctrl and click:
A. Anywhere in the sentence
B. Double-click the first word
C. At the start of the sentence
D. Triple-click
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+click selects the entire sentence.
This question belongs to: Computer Microsoft Office
Question #960
In Excel, the 'Name Box' displays:
A. The cell reference or name of the active cell
B. The file name
C. The worksheet name
D. The formula in the cell
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Name Box shows active cell address.
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: