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. DATEVALUE
B. VALUE
C. DATE
D. NOW
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Slide Show > Set Up Show
D. Sound dropdown in Transitions tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. First line indent
B. Hanging indent
C. Right indent
D. Left indent
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Create > Table Design
B. Database Tools > Table
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. Alt + P, S, P
B. F5
C. Ctrl + P
D. Ctrl + Shift + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. .pptx
B. .jpg
C. .pdf
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. PEARSON
B. COVARIANCE
C. All of the above
D. CORREL
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Review > Bookmark
B. Insert > Bookmark
C. View > Bookmark
D. References > Bookmark
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. All of the above
B. Group
C. Align
D. Distribute
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Home > Drop Cap
B. Insert > Text > Drop Cap
C. Format > Drop Cap
D. Insert > Drop Cap
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. MODE
B. MEDIAN
C. AVERAGEA
D. AVERAGE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Single
B. Long Integer
C. All of the above
D. Integer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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

Correct Answer: Option C

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. Print Preview
B. Normal View
C. Slide Sorter View
D. Handout Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Insert > Table > Insert Table
B. All of the above
C. Draw Table
D. Quick Tables
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. MINA
B. MINIFS
C. SMALL
D. MIN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 Design
B. Both A and B
C. Create > Form Wizard
D. Create > Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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

Correct Answer: Option A

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. NPV
C. IRR
D. FV
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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?'