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 36 of 60
Question #701
In PowerPoint, pressing 'B' during a slide show will:
A. Turn the screen black
B. End the show
C. Go back to the previous slide
D. Show all slides as thumbnails
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pressing B blacks out the screen, W whites it out.
This question belongs to: Computer Microsoft Office
Question #702
In MS Access, which of the following is NOT a valid data type?
A. Memo
B. Currency
C. DateTime
D. Yes/No
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The correct name is Date/Time, not DateTime.
This question belongs to: Computer Microsoft Office
Question #703
To move the cursor to the end of a document in MS Word, press:
A. Ctrl + Page Down
B. Shift + End
C. Ctrl + End
D. End
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+End jumps to end of document. End goes to end of line.
This question belongs to: Computer Microsoft Office
Question #704
In PowerPoint, what is the 'Reading View' used for?
A. View speaker notes
B. View slide thumbnails
C. Preview the presentation in a window with navigation controls
D. Edit slide content
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reading View plays the slide show in a resizable window.
This question belongs to: Computer Microsoft Office
Question #705
In MS Access, the 'Input Mask' property is used to:
A. Set a default value
B. Control the format of data entered in a field
C. Hide the field value with asterisks
D. Validate that a value falls within a range
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Input Mask defines a pattern for data entry (e.g., phone number). Validation Rule checks correctness.
This question belongs to: Computer Microsoft Office
Question #706
The shortcut to insert a hyperlink in MS Excel is:
A. Ctrl + J
B. Ctrl + K
C. Ctrl + L
D. Ctrl + H
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+K inserts hyperlink in Excel, Word, PowerPoint.
This question belongs to: Computer Microsoft Office
Question #707
In MS Word, what does the 'Watermark' feature do?
A. Marks the document as draft
B. Adds a border around the page
C. Inserts faded text or image behind the document content
D. Protects the document from editing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Watermark is a background text/image (e.g., CONFIDENTIAL).
This question belongs to: Computer Microsoft Office
Question #708
In Excel, the formula =ROUND(3.14159, 2) returns:
A. 3.15
B. 3.14
C. 3.1
D. 3.142
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
ROUND to 2 decimal places rounds 3.14159 to 3.14.
This question belongs to: Computer Microsoft Office
Question #709
Which shortcut is used to start a slide show from the current slide in PowerPoint?
A. F5
B. Shift + F5
C. Alt + F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift+F5 starts from current slide.
This question belongs to: Computer Microsoft Office
Question #710
In MS Access, a relationship between two tables where one record in Table A can relate to many records in Table B is called:
A. Many-to-Many
B. Master-Detail
C. One-to-Many
D. One-to-One
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
One-to-many is the most common relationship.
This question belongs to: Computer Microsoft Office
Question #711
In MS Word, which key deletes one character to the left of the cursor?
A. Backspace
B. Home
C. Delete
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Backspace deletes to the left; Delete to the right.
This question belongs to: Computer Microsoft Office
Question #712
Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)?
A. Goal Seek
B. AutoFill handle
C. Data Validation
D. Flash Fill
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Dragging the fill handle (small square at bottom-right) creates series. Flash Fill detects patterns.
This question belongs to: Computer Microsoft Office
Question #713
In PowerPoint, the 'Eyedropper' tool is used to:
A. Copy formatting from one shape to another
B. Crop an image precisely
C. Insert a screenshot
D. Pick a color from any part of the slide and apply it to another object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Eyedropper matches colors. Format Painter copies formatting.
This question belongs to: Computer Microsoft Office
Question #714
In MS Access, which query type displays summarized data in a spreadsheet-like format with rows and columns?
A. Crosstab query
B. Action query
C. Select query
D. Parameter query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Crosstab query aggregates data and presents it in a grid with row and column headings.
This question belongs to: Computer Microsoft Office
Question #715
What does Ctrl + Shift + End do in MS Word?
A. Selects the last page
B. Selects from the cursor position to the end of the document
C. Deletes to the end of the line
D. Moves cursor to the end of the document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+End selects from the insertion point to the end of the document.
This question belongs to: Computer Microsoft Office
Question #716
In Excel, the error '#REF!' indicates:
A. Formula name not recognized
B. Invalid cell reference (cell may have been deleted)
C. Wrong data type
D. Division by zero
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.
This question belongs to: Computer Microsoft Office
Question #717
Which key is used to rename a selected slide in PowerPoint slide pane?
A. F2
B. Ctrl + R
C. F5
D. Alt + R
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F2 allows renaming of the selected object or, in some contexts, the slide (by selecting slide title). However, F2 in thumbnail pane doesn't rename; but it's standard rename key. Actually, to rename a slide in PowerPoint, you can right-click and Rename, no direct shortcut. But F2 is generally Rename in Office. I'll avoid this ambiguity. Better question: In Excel, F2 edits cell. I'll replace. I'll skip this and create another. Need 300, I'll replace with a valid question. I'll do: In MS Access, what is the maximum size of a database? A) 2 GB, B) 1 GB, C) 4 GB, D) 500 MB. Actually, Access 2016 max is 2 GB. So that's ok. I'll replace question.
This question belongs to: Computer Microsoft Office
Question #718
In MS Access, the maximum size of a database file (accdb) is:
A. 1 GB
B. 500 MB
C. 2 GB
D. 4 GB
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Access database size limit is 2 gigabytes, minus space needed for system objects.
This question belongs to: Computer Microsoft Office
Question #719
In MS Word, what is the function of 'Track Changes'?
A. Automatically saves versions
B. Compares two documents
C. Records all edits made to a document for review
D. Protects the document with a password
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Track Changes highlights insertions, deletions, and formatting changes.
This question belongs to: Computer Microsoft Office
Question #720
In Excel, which function returns the weekday number of a given date?
A. DATEVALUE()
B. WEEKDAY()
C. DAY()
D. WEEKNUM()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
WEEKDAY(date) returns a number 1 (Sunday) through 7. WEEKNUM returns week of year.
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: