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 29 of 60
Question #561
What does the VLOOKUP function do in Excel?
A. Returns the current date and time
B. Searches for a value in the first column of a table and returns a value in the same row from a specified column
C. Counts the number of cells that meet a condition
D. Rounds a number to a specified number of digits
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
VLOOKUP looks up a value vertically. It searches down the first column and returns a value from another column in that row.
This question belongs to: Computer Microsoft Office
Question #562
In MS Word, which key is used to delete text to the right of the insertion point?
A. End
B. Delete
C. Insert
D. Backspace
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Delete key removes the character to the right. Backspace deletes to the left.
This question belongs to: Computer Microsoft Office
Question #563
Which feature in Excel restricts the type of data that can be entered into a cell?
A. Protect Sheet
B. Data Validation
C. Conditional Formatting
D. Goal Seek
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Data Validation controls allowed inputs (e.g., whole numbers, lists). Conditional Formatting changes appearance, Goal Seek performs what-if analysis, Protect Sheet restricts editing.
This question belongs to: Computer Microsoft Office
Question #564
In PowerPoint, what is the purpose of Slide Master?
A. Controls the overall design and layout of all slides
B. Adds transitions between slides
C. Runs a spelling check for the entire presentation
D. Inserts animations on an object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Master defines global formatting, placeholders, and layouts that apply to the entire presentation.
This question belongs to: Computer Microsoft Office
Question #565
Which Access data type would be most suitable for storing lengthy descriptive text up to about 1 GB?
A. Long Text (Memo)
B. Hyperlink
C. OLE Object
D. Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Long Text (formerly Memo) stores large amounts of text. Text holds up to 255 characters. OLE Object stores binary objects.
This question belongs to: Computer Microsoft Office
Question #566
To quickly summon the 'Save As' dialog box in MS Office, press:
A. Alt + F2
B. Shift + F12
C. F12
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F12 opens Save As. Ctrl + S saves the file (or Save As if never saved). Shift + F12 also saves (same as Ctrl+S). Alt+F2 opens Save As in some versions, but F12 is standard.
This question belongs to: Computer Microsoft Office
Question #567
What is the function of the CONCATENATE function in Excel?
A. Joins two or more text strings into one string
B. Extracts a specific number of characters from the left of a string
C. Converts text to uppercase
D. Removes extra spaces from text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
CONCATENATE combines text strings. UPPER converts to uppercase, TRIM removes extra spaces, LEFT extracts left characters.
This question belongs to: Computer Microsoft Office
Question #568
In MS Access, which field property ensures that each record has a unique identifier?
A. Required
B. Indexed
C. Primary Key
D. Validation Rule
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Primary Key uniquely identifies each record and does not allow nulls. Indexed improves search, Required forces data entry, Validation Rule checks input.
This question belongs to: Computer Microsoft Office
Question #569
What is the shortcut to align selected text to the right margin in MS Word?
A. Ctrl + R
B. Ctrl + J
C. Ctrl + L
D. Ctrl + E
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + R aligns right. Ctrl + L left, Ctrl + E centre, Ctrl + J justify.
This question belongs to: Computer Microsoft Office
Question #570
In Excel, a cell reference that changes when a formula is copied to another cell is called:
A. Circular reference
B. Absolute reference
C. Mixed reference
D. Relative reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Relative references (e.g., A1) adjust based on position. Absolute references ($A$1) stay fixed. Mixed references ($A1 or A$1) are partly fixed.
This question belongs to: Computer Microsoft Office
Question #571
To end a running slide show in PowerPoint, press:
A. End
B. Break
C. Spacebar
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Pressing Esc exits a slide show. End key moves to last slide but does not exit. Spacebar advances slides.
This question belongs to: Computer Microsoft Office
Question #572
Which of the following is the extension of a PowerPoint template file?
A. .ppsx
B. .ppt
C. .potx
D. .pptx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
.potx is a PowerPoint template. .pptx is a normal presentation, .ppsx is a show, .ppt is older format.
This question belongs to: Computer Microsoft Office
Question #573
What does the COUNTIF function do in Excel?
A. Sums cells that meet a condition
B. Counts all non-empty cells
C. Counts the number of cells within a range that meet a single condition
D. Counts all cells containing numbers
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COUNTIF counts based on one criterion. SUMIF sums with a condition. COUNT counts only numbers, COUNTA counts non-empty cells.
This question belongs to: Computer Microsoft Office
Question #574
In MS Word, which feature allows you to send personalized letters to many recipients using a template and a data source?
A. Mail Merge
B. Macros
C. Track Changes
D. Quick Parts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mail Merge combines a main document with a recipient list to create multiple custom documents. Macros automate tasks, Track Changes records edits.
This question belongs to: Computer Microsoft Office
Question #575
In MS Access, which type of relationship prevents orphan records by ensuring that related records exist?
A. One-to-Many
B. Composite Key
C. Referential Integrity
D. Cascade Delete
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Referential Integrity ensures that a record in a related table must have a matching key in the primary table. Cascade delete removes related records automatically.
This question belongs to: Computer Microsoft Office
Question #576
Which shortcut key opens the 'Find' dialog box in MS Word?
A. Ctrl + G
B. Ctrl + H
C. F3
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + F opens Find. Ctrl + H opens Replace, Ctrl + G opens Go To, F3 repeats last find.
This question belongs to: Computer Microsoft Office
Question #577
In Excel, what does the function =IF(A1>70, "Pass", "Fail") return if A1 contains 85?
A. 85
B. Pass
C. Fail
D. TRUE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The condition A1>70 is true (85>70), so IF returns the value_if_true "Pass".
This question belongs to: Computer Microsoft Office
Question #578
To quickly move to the beginning of a document in MS Word, press:
A. Shift + Home
B. Ctrl + Page Up
C. Ctrl + Home
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Home moves cursor to the start of the document. Home goes to start of the line.
This question belongs to: Computer Microsoft Office
Question #579
Which of the following is NOT a valid view in MS PowerPoint?
A. Draft view
B. Slide Sorter view
C. Normal view
D. Reading view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PowerPoint does not have Draft view; that is a Word view. Normal, Slide Sorter, and Reading views exist.
This question belongs to: Computer Microsoft Office
Question #580
What is the shortcut key to apply or remove bold formatting in MS Word?
A. Ctrl + U
B. Ctrl + B
C. Ctrl + Shift + B
D. Ctrl + I
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + B toggles bold. Ctrl + I italic, Ctrl + U underline, Ctrl + Shift + B opens bookmark list in Word.
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?'