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 14 of 60
Question #261
In Access, which of the following is used to enforce referential integrity?
A. Relationships
B. Input Masks
C. Validation Rules
D. Default Values
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Referential integrity is enforced through relationships between tables, ensuring that foreign key values match primary key values. Validation rules are for field-level validation.
This question belongs to: Computer Microsoft Office
Question #262
What is the shortcut key to open the 'Print' dialog box in MS Office?
A. Ctrl + F12
B. Alt + P
C. Ctrl + Shift + P
D. Ctrl + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + P opens the Print dialog or the Print backstage. Ctrl+Shift+P changes font size in Word? Actually it opens the Change Font Size box? Not standard. Alt+P is not Print. Ctrl+F12 opens Open dialog.
This question belongs to: Computer Microsoft Office
Question #263
In Excel, which function is used to count the number of cells that contain numbers in a range?
A. COUNTIF
B. COUNTBLANK
C. COUNTA
D. COUNT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNT counts only numeric cells. COUNTA counts non-empty, COUNTIF conditional, COUNTBLANK empty.
This question belongs to: Computer Microsoft Office
Question #264
In MS PowerPoint, which view allows you to see the presentation as it will appear in a web browser?
A. Slide Show View
B. Web Layout View
C. Normal View
D. Reading View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reading View in PowerPoint displays slides in a window with navigation controls, similar to a web browser. Slide Show is full screen, Normal is editing. There is no Web Layout View in PowerPoint.
This question belongs to: Computer Microsoft Office
Question #265
In MS Word, which of the following is used to create a dynamic cross-reference to a heading, footnote, or caption?
A. Hyperlink
B. Cross-reference
C. Bookmark
D. Comment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Cross-reference creates a link to an item like a heading, figure, or footnote, updating the reference number when the target changes. Hyperlink is a web link, Bookmark marks a location, Comment adds notes.
This question belongs to: Computer Microsoft Office
Question #266
In Excel, what does the 'HLOOKUP' function stand for?
A. Height Lookup
B. Hierarchical Lookup
C. Horizontal Lookup
D. High Lookup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
HLOOKUP stands for Horizontal Lookup, used to search for a value in the top row of a table and return a value from a specified row.
This question belongs to: Computer Microsoft Office
Question #267
In MS PowerPoint, which option is used to add a video to a slide?
A. Insert > Video
B. Insert > Object
C. Insert > Media
D. Insert > Movie
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Video command is under the Insert tab, in the Media group. In older versions it may be 'Movie', but current is Video.
This question belongs to: Computer Microsoft Office
Question #268
In MS Word, which of the following is not a type of tab stop?
A. Left
B. Right
C. Justify
D. Center
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Word tab stops include Left, Center, Right, Decimal, and Bar. Justify is a text alignment option, not a tab stop.
This question belongs to: Computer Microsoft Office
Question #269
In Access, what is the purpose of the 'AutoNumber' data type?
A. To auto-increment a field based on a formula
B. To store random numbers
C. To copy numbers from another table
D. To automatically generate a unique number for each record
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoNumber is a data type that automatically generates a unique sequential number when a record is added, often used as a primary key.
This question belongs to: Computer Microsoft Office
Question #270
What is the shortcut key to paste special in MS Office?
A. Ctrl + Shift + V
B. Both A and C
C. Ctrl + Alt + V
D. Alt + E, S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In many Office apps, Ctrl+Alt+V opens Paste Special, and Alt+E,S is the old menu shortcut. So both are valid.
This question belongs to: Computer Microsoft Office
Question #271
In Excel, which function is used to calculate the sum of a range with criteria?
A. SUMIFS
B. SUMPRODUCT
C. All of the above
D. SUMIF
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SUMIF, SUMIFS, and SUMPRODUCT can all perform conditional sums (SUMPRODUCT can do multiple criteria). So all are valid.
This question belongs to: Computer Microsoft Office
Question #272
In MS PowerPoint, which of the following is a type of slide transition effect?
A. Fade
B. Push
C. Wipe
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Fade, Wipe, and Push are all transition effects available in PowerPoint.
This question belongs to: Computer Microsoft Office
Question #273
In MS Word, which feature allows you to see the document's structure using headings?
A. Document Map (older)
B. Outline View
C. All of the above
D. Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Navigation Pane (with 'Headings' tab), Outline View, and the old Document Map all show the document's heading hierarchy.
This question belongs to: Computer Microsoft Office
Question #274
In Excel, what does the 'ROUND' function do?
A. Rounds a number to a specified number of digits
B. Rounds down to the nearest integer
C. Rounds up to the nearest integer
D. Rounds to the nearest multiple
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ROUND rounds a number to a specified number of decimal places. ROUNDUP rounds up, ROUNDDOWN rounds down, MROUND rounds to a multiple.
This question belongs to: Computer Microsoft Office
Question #275
In MS Access, which object is used to create a formatted printout of data?
A. Query
B. Form
C. Table
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reports are designed for printing data in a formatted layout. Forms are for data entry, queries for retrieval, tables for storage.
This question belongs to: Computer Microsoft Office
Question #276
What is the shortcut key to move between open workbooks in Excel?
A. Both A and B
B. Ctrl + F6
C. Ctrl + Tab
D. Alt + Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In Excel, Ctrl+Tab and Ctrl+F6 both cycle through open workbooks. Alt+Tab switches between all open applications.
This question belongs to: Computer Microsoft Office
Question #277
In MS PowerPoint, which option is used to insert a table?
A. Insert > Table
B. Insert > Table > Insert Table
C. Home > Table
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can insert a table via Insert > Table, then choose a grid or Insert Table dialog. Both are valid.
This question belongs to: Computer Microsoft Office
Question #278
In MS Word, which of the following is not a type of paragraph alignment?
A. Left
B. Center
C. Right
D. Distribute
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Word has Left, Center, Right, and Justify (also called Justified). 'Distribute' is not a standard paragraph alignment, though there is 'Distribute' for spacing in some contexts.
This question belongs to: Computer Microsoft Office
Question #279
In Excel, which function is used to calculate the exponential growth?
A. GROWTH
B. LOG
C. TREND
D. EXP
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
GROWTH calculates exponential growth based on existing data. EXP returns e raised to a power, LOG is logarithm, TREND for linear trend.
This question belongs to: Computer Microsoft Office
Question #280
In MS Access, which of the following is a valid relationship type?
A. Many-to-Many
B. One-to-Many
C. All of the above
D. One-to-One
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Access supports all three types of relationships: one-to-one, one-to-many, and many-to-many (via a junction table).
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?'