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 33 of 60
Question #641
In Excel, which error value indicates that a formula contains invalid numeric values?
A. #VALUE!
B. #REF!
C. #DIV/0!
D. #NAME?
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
#VALUE! appears when wrong data type is used. #REF! invalid reference, #DIV/0! division by zero, #NAME? unrecognized text.
This question belongs to: Computer Microsoft Office
Question #642
Which of the following is used to apply animations to individual objects in PowerPoint?
A. View tab
B. Transitions tab
C. Design tab
D. Animations tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Animations tab adds movement to objects. Transitions are for slides.
This question belongs to: Computer Microsoft Office
Question #643
In MS Access, what does SQL stand for?
A. Standard Query Logic
B. Simple Query Language
C. Structured Query Language
D. Sequential Query Language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SQL = Structured Query Language, used to manage relational databases.
This question belongs to: Computer Microsoft Office
Question #644
Which keyboard shortcut is used to select all content in a document?
A. Ctrl + Alt + A
B. Ctrl + A
C. Ctrl + S
D. Ctrl + Shift + A
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + A selects all. Ctrl + S saves, Ctrl + Shift + A toggles all caps.
This question belongs to: Computer Microsoft Office
Question #645
In Excel, what is the intersection of a row and a column called?
A. Range
B. Field
C. Record
D. Cell
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A cell is the intersection point. Range is a group of cells.
This question belongs to: Computer Microsoft Office
Question #646
In MS Word, which feature allows you to quickly apply a set of formatting choices consistently?
A. Templates
B. Designs
C. Styles
D. Themes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Styles (e.g., Heading 1) are sets of formatting. Themes apply colors and fonts, Templates are pre-designed documents.
This question belongs to: Computer Microsoft Office
Question #647
To add a chart in Excel, which tab do you use?
A. Formulas
B. View
C. Insert
D. Data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Charts are inserted from the Insert tab.
This question belongs to: Computer Microsoft Office
Question #648
In PowerPoint, which view is best for editing the content of individual slides in detail?
A. Normal view
B. Reading view
C. Slide Sorter view
D. Outline view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Normal view allows editing slide content, notes, and thumbnails.
This question belongs to: Computer Microsoft Office
Question #649
Which Access object is used to automate repetitive tasks without writing code?
A. Report
B. Module
C. Macro
D. Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Macros automate tasks via a simplified interface. Modules contain VBA code.
This question belongs to: Computer Microsoft Office
Question #650
To increase the indent level of a paragraph in MS Word, press:
A. Ctrl + Shift + M
B. Tab
C. Ctrl + T
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M increases left indent. Tab indents first line only (if ruler set). Ctrl+T increases hanging indent. Ctrl+Shift+M decreases indent.
This question belongs to: Computer Microsoft Office
Question #651
In Excel, which of the following functions rounds a number up, away from zero?
A. ROUND()
B. CEILING()
C. ROUNDDOWN()
D. ROUNDUP()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ROUNDUP rounds up. CEILING also rounds up but to a specified multiple. ROUND rounds to nearest digit.
This question belongs to: Computer Microsoft Office
Question #652
In MS Word, what does the shortcut Ctrl + ] do?
A. Increases indent
B. Increases font size by 1 point
C. Toggles bold
D. Applies superscript
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + ] increases font size by 1 point; Ctrl + [ decreases.
This question belongs to: Computer Microsoft Office
Question #653
What is the maximum length of a field name in MS Access?
A. 64 characters
B. 255 characters
C. 32 characters
D. 128 characters
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Access field names can be up to 64 characters.
This question belongs to: Computer Microsoft Office
Question #654
In PowerPoint, to insert a hyperlink, use the shortcut:
A. Ctrl + K
B. Ctrl + L
C. Ctrl + Shift + K
D. Ctrl + H
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + K opens Insert Hyperlink dialog.
This question belongs to: Computer Microsoft Office
Question #655
Which of the following is NOT a valid Excel number format category?
A. Scientific
B. General
C. Phone Number
D. Fraction
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.
This question belongs to: Computer Microsoft Office
Question #656
In MS Word, the 'Navigation Pane' can be opened by pressing:
A. Ctrl + N
B. Ctrl + Shift + N
C. Alt + F
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Pressing Ctrl + F opens the Navigation pane for searching and document outline.
This question belongs to: Computer Microsoft Office
Question #657
Which Excel feature allows you to view two separate parts of a worksheet at the same time?
A. Freeze Panes
B. New Window
C. Split
D. Arrange All
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Split divides the window into resizable panes. Freeze Panes locks rows/columns, Arrange All arranges open workbooks.
This question belongs to: Computer Microsoft Office
Question #658
In PowerPoint, which presentation view shows only the text of slides in a structured manner?
A. Notes Page
B. Normal view
C. Slide Sorter view
D. Outline view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Outline view displays slide text in a hierarchical list. In newer PowerPoint, it's a pane in Normal view.
This question belongs to: Computer Microsoft Office
Question #659
Which Access data type is used to store monetary values and prevents rounding errors?
A. AutoNumber
B. Decimal
C. Currency
D. Number
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Currency has fixed decimal places and avoids rounding errors. Number can also store money but may have rounding.
This question belongs to: Computer Microsoft Office
Question #660
What is the function of the 'F2' key in MS Excel?
A. Opens the Print dialog
B. Selects the entire column
C. Saves the workbook
D. Edits the active cell, placing cursor at the end
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F2 allows editing directly in a cell. Ctrl+Space selects column.
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?'