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. Show all slides as thumbnails
B. End the show
C. Go back to the previous slide
D. Turn the screen black
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. DateTime
B. Yes/No
C. Memo
D. Currency
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. End
D. Ctrl + End
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Edit slide content
B. View speaker notes
C. Preview the presentation in a window with navigation controls
D. View slide thumbnails
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. Hide the field value with asterisks
C. Validate that a value falls within a range
D. Control the format of data entered in a field
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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 + H
B. Ctrl + J
C. Ctrl + K
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Protects the document from editing
C. Adds a border around the page
D. Inserts faded text or image behind the document content
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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.142
C. 3.1
D. 3.14
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Shift + F5
B. Ctrl + F5
C. Alt + F5
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Master-Detail
B. One-to-One
C. One-to-Many
D. Many-to-Many
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. Delete
B. Home
C. Backspace
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. AutoFill handle
B. Flash Fill
C. Data Validation
D. Goal Seek
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Select query
C. Parameter query
D. Action 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 from the cursor position to the end of the document
B. Deletes to the end of the line
C. Moves cursor to the end of the document
D. Selects the last page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Division by zero
D. Wrong data type
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. F5
B. F2
C. Alt + R
D. Ctrl + R
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. 4 GB
B. 2 GB
C. 500 MB
D. 1 GB
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Compares two documents
B. Records all edits made to a document for review
C. Automatically saves versions
D. Protects the document with a password
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. DAY()
B. DATEVALUE()
C. WEEKDAY()
D. WEEKNUM()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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