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 30 of 60
Question #581
In Excel, which function returns the current date and time?
A. TODAY()
B. NOW()
C. DATE()
D. TIME()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
NOW() returns serial number of current date and time. TODAY() returns date only. DATE(year,month,day) constructs a date.
This question belongs to: Computer Microsoft Office
Question #582
To duplicate a selected slide in PowerPoint, press:
A. Ctrl + M
B. Ctrl + C then Ctrl + V
C. Ctrl + Shift + D
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + D duplicates selected slide. Ctrl + M inserts new slide. Ctrl+C/V copies/pastes, but requires two steps. Ctrl+Shift+D is not a default shortcut.
This question belongs to: Computer Microsoft Office
Question #583
In MS Access, what is a form used for?
A. Storing raw data
B. Summarizing data for printing
C. User-friendly interface for data entry and viewing records
D. Executing SQL commands
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms provide a graphical interface for data input and display. Reports are for printing summaries, tables store data.
This question belongs to: Computer Microsoft Office
Question #584
Which key combination cuts the selected content in MS Office?
A. Ctrl + C
B. Ctrl + V
C. Ctrl + D
D. Ctrl + X
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + X cuts (removes to clipboard). Ctrl + C copies, Ctrl + V pastes.
This question belongs to: Computer Microsoft Office
Question #585
In Excel, which function finds the smallest number in a range?
A. MIN()
B. MAX()
C. SMALL()
D. LOWER()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MIN returns the smallest numeric value. SMALL returns the k-th smallest. LOWER converts text to lowercase.
This question belongs to: Computer Microsoft Office
Question #586
What is the default file extension of MS Word 2016 document?
A. .docx
B. .doc
C. .dotx
D. .rtf
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.docx is the default Word 2007+ document format. .doc is older, .dotx template, .rtf rich text format.
This question belongs to: Computer Microsoft Office
Question #587
In MS Word, what is the function of Ctrl + E?
A. Centre aligns the selected paragraph
B. Exits the program
C. Applies double underline
D. Opens the thesaurus
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + E centres text. Shift + F7 opens thesaurus.
This question belongs to: Computer Microsoft Office
Question #588
Which chart type is best suited to display trends over time in Excel?
A. Line chart
B. Pie chart
C. Bar chart
D. Doughnut chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Line charts are ideal for showing trends across a continuous period. Pie charts show parts of a whole.
This question belongs to: Computer Microsoft Office
Question #589
What is the purpose of the HLOOKUP function in Excel?
A. Performs a case-sensitive search
B. Looks up a value in the top row of a table and returns a value from a specified row below it
C. Looks up a value in the leftmost column and returns from a column to the right
D. Searches horizontally for the maximum value
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
HLOOKUP searches for a value in the first row and returns from a specified row. VLOOKUP searches in first column.
This question belongs to: Computer Microsoft Office
Question #590
In PowerPoint, which tab is used to set slide transitions?
A. Transitions
B. Design
C. Slide Show
D. Animations
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Transitions tab controls how slides change. Animations tab controls object movement.
This question belongs to: Computer Microsoft Office
Question #591
In MS Access, which object stores data in a structured format of rows and columns?
A. Report
B. Query
C. Table
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Tables hold the raw data. Queries extract data, forms display it, reports present it.
This question belongs to: Computer Microsoft Office
Question #592
What is the shortcut to print a document in MS Office?
A. F5
B. Ctrl + Shift + P
C. Ctrl + Alt + P
D. Ctrl + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + P opens the Print dialog.
This question belongs to: Computer Microsoft Office
Question #593
In Excel, to freeze the top row so it remains visible while scrolling, go to:
A. Page Layout -> Print Titles
B. Review tab -> Protect Sheet
C. View tab -> Freeze Panes -> Freeze Top Row
D. Insert tab -> Header & Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Freeze Panes under View tab can freeze rows/columns. Protect Sheet restricts editing.
This question belongs to: Computer Microsoft Office
Question #594
Which of the following is NOT a text alignment option in MS Word?
A. Justify
B. Distributed
C. Left
D. Right
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Distributed is not a standard paragraph alignment; available alignments: Left, Center, Right, Justify. (Distributed is in some table cell settings but not as primary alignment.)
This question belongs to: Computer Microsoft Office
Question #595
In PowerPoint, which view allows you to see the presenter's notes while the audience sees only slides?
A. Normal view
B. Notes Page view
C. Slide Show view
D. Presenter View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Presenter View (available with dual monitors) shows notes and next slide. Notes Page view is for editing notes.
This question belongs to: Computer Microsoft Office
Question #596
What does the F4 key do in MS Excel after applying a format?
A. Repeats the last action (e.g., formatting)
B. Opens the Format Cells dialog
C. Toggles between absolute and relative reference in a formula
D. Closes the current workbook
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F4 repeats the last command or action. In a formula editing mode, F4 cycles reference types.
This question belongs to: Computer Microsoft Office
Question #597
In MS Access, which data type automatically generates a unique number for each new record?
A. Currency
B. Number
C. Yes/No
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoNumber is used for sequential unique IDs. Number stores numeric values, Currency for monetary data, Yes/No for boolean.
This question belongs to: Computer Microsoft Office
Question #598
Which shortcut key opens the 'Go To' dialog in MS Word?
A. Ctrl + H
B. Ctrl + K
C. Ctrl + F
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + G opens Go To. F5 also opens Go To. Ctrl+F is Find, Ctrl+H Replace.
This question belongs to: Computer Microsoft Office
Question #599
In Excel, which function returns the remainder after division?
A. MOD()
B. ROUND()
C. QUOTIENT()
D. INT()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MOD(number, divisor) returns remainder. QUOTIENT returns integer portion of division, INT rounds down, ROUND rounds to digits.
This question belongs to: Computer Microsoft Office
Question #600
How do you insert a comment in MS Word?
A. Right-click and choose 'Insert Note'
B. Select text, go to Review tab -> New Comment
C. Use Insert tab -> Comment
D. Press Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Review tab contains New Comment. Ctrl + M increases indent.
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?'