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 18 of 60
Question #341
In Excel, which function is used to convert a date to a serial number?
A. NOW
B. DATE
C. DATEVALUE
D. VALUE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DATEVALUE converts a date in text format to a serial number. VALUE converts text to number generally.
This question belongs to: Computer Microsoft Office
Question #342
In MS PowerPoint, which option is used to add a sound effect to a transition?
A. Insert > Audio
B. Animation pane
C. Sound dropdown in Transitions tab
D. Slide Show > Set Up Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In the Transitions tab, there is a Sound dropdown to select a sound for the transition.
This question belongs to: Computer Microsoft Office
Question #343
In MS Word, which of the following is not a type of indent?
A. Hanging indent
B. Right indent
C. Left indent
D. First line indent
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Word indents include Left, First line, Hanging, and Right indent is also a type. Actually Right indent exists. So all are types. I'll change to a different question.
This question belongs to: Computer Microsoft Office
Question #344
In Access, which of the following is used to create a new table?
A. Database Tools > Table
B. Create > Table Design
C. Both A and B
D. Create > Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can create a table via Create > Table (Datasheet view) or Create > Table Design.
This question belongs to: Computer Microsoft Office
Question #345
What is the shortcut key to open the 'Page Setup' dialog in MS Excel?
A. Ctrl + P
B. F5
C. Ctrl + Shift + P
D. Alt + P, S, P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+P,S,P opens Page Setup in Excel. Ctrl+Shift+P is not standard. Ctrl+P is Print. F5 is Go To.
This question belongs to: Computer Microsoft Office
Question #346
In MS PowerPoint, which of the following is a valid file format for saving a presentation for easy sharing?
A. All of the above
B. .jpg
C. .pdf
D. .pptx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can save as .pptx (editable), .pdf (for sharing), and .jpg (as images). So all are valid.
This question belongs to: Computer Microsoft Office
Question #347
In Excel, which function is used to calculate the correlation between two data sets?
A. CORREL
B. All of the above
C. PEARSON
D. COVARIANCE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CORREL and PEARSON compute correlation coefficient, and COVARIANCE computes covariance. All are related.
This question belongs to: Computer Microsoft Office
Question #348
In MS Word, which of the following is used to create a bookmark?
A. Insert > Bookmark
B. View > Bookmark
C. Review > Bookmark
D. References > Bookmark
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Bookmark is under the Insert tab, in the Links group.
This question belongs to: Computer Microsoft Office
Question #349
In Access, which of the following is a valid way to set a primary key?
A. Set in Datasheet View
B. Both A and B
C. Right-click the field in Design View and select Primary Key
D. Use the Primary Key button in Design View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can set primary key by right-clicking or clicking the Primary Key button in Design View.
This question belongs to: Computer Microsoft Office
Question #350
In MS PowerPoint, which option is used to align objects relative to each other?
A. Distribute
B. Align
C. All of the above
D. Group
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Align options (Align Left, Align Center, etc.) are used to align selected objects. Distribute spaces them evenly, Group combines them.
This question belongs to: Computer Microsoft Office
Question #351
In Word, which of the following is used to insert a drop cap?
A. Format > Drop Cap
B. Insert > Drop Cap
C. Home > Drop Cap
D. Insert > Text > Drop Cap
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Drop Cap is under the Insert tab, in the Text group.
This question belongs to: Computer Microsoft Office
Question #352
In Excel, which function is used to calculate the arithmetic mean of a set of numbers?
A. AVERAGE
B. MEDIAN
C. MODE
D. AVERAGEA
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AVERAGE is the arithmetic mean. AVERAGEA includes logical values, MEDIAN is middle value, MODE is most frequent.
This question belongs to: Computer Microsoft Office
Question #353
In Access, which of the following is a valid field size for a Number data type?
A. Integer
B. All of the above
C. Single
D. Long Integer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Number field sizes include Byte, Integer, Long Integer, Single, Double, Decimal, etc. So all are valid.
This question belongs to: Computer Microsoft Office
Question #354
What is the shortcut key to save a document in MS Office?
A. Both A and C
B. F12
C. Ctrl + Shift + S
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+S saves (or Save As if new), F12 opens Save As directly.
This question belongs to: Computer Microsoft Office
Question #355
In MS PowerPoint, which view is used to print handouts with multiple slides per page?
A. Slide Sorter View
B. Print Preview
C. Handout Master
D. Normal View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Handout Master is used to edit the layout for printed handouts. However, to print handouts, you go to File > Print and choose handouts layout. But the question asks which view, so Handout Master is the correct answer.
This question belongs to: Computer Microsoft Office
Question #356
In Word, which of the following is used to create a simple table?
A. Quick Tables
B. Insert > Table > Insert Table
C. Draw Table
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are methods to create a table in Word.
This question belongs to: Computer Microsoft Office
Question #357
In Excel, which function is used to return the smallest value that meets a condition?
A. MINIFS
B. MINA
C. SMALL
D. MIN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.
This question belongs to: Computer Microsoft Office
Question #358
In Access, which of the following is used to create a form based on a table or query?
A. Create > Form
B. Create > Form Design
C. Create > Form Wizard
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can create a form using Form (auto), Form Design, or Form Wizard. So both A and B are valid.
This question belongs to: Computer Microsoft Office
Question #359
What is the shortcut key to insert a special character like © in MS Word?
A. Ctrl + Alt + C
B. Both A and B
C. Insert > Symbol
D. Alt + Ctrl + C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Ctrl+C inserts the copyright symbol. Insert > Symbol is another way, but shortcut is Alt+Ctrl+C.
This question belongs to: Computer Microsoft Office
Question #360
In Excel, which function is used to calculate the net present value?
A. PV
B. IRR
C. NPV
D. FV
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NPV calculates net present value.
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 Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: