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 43 of 60
Question #841
In Excel, which function counts the number of blank cells in a range?
A. COUNTBLANK()
B. COUNTIF()
C. ISBLANK()
D. COUNTA()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNTBLANK(range) returns count of empty cells.
This question belongs to: Computer Microsoft Office
Question #842
In PowerPoint, which key can be used to draw on slides during a presentation?
A. P
B. W
C. Ctrl + P (to activate Pen)
D. D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+P activates the pen tool during a slide show. Ctrl+E eraser, Ctrl+A arrow.
This question belongs to: Computer Microsoft Office
Question #843
In MS Access, what is the purpose of the 'Compact and Repair' database utility?
A. Encrypts the database
B. Creates a backup
C. Splits the database into front-end and back-end
D. Reduces file size and fixes corruption
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Compact and Repair reclaims unused space and repairs minor issues.
This question belongs to: Computer Microsoft Office
Question #844
To cut selected text in MS Word and place it on the clipboard, press:
A. Ctrl + V
B. Ctrl + Shift + X
C. Ctrl + X
D. Ctrl + C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+X cuts.
This question belongs to: Computer Microsoft Office
Question #845
In Excel, the formula =IF(A1>10, IF(A1>20, "High", "Medium"), "Low") will return what if A1=15?
A. High
B. Low
C. Medium
D. Error
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A1=15, first condition >10 true, then nested IF: A1>20 false, so "Medium".
This question belongs to: Computer Microsoft Office
Question #846
In MS Word, what is the default paper size?
A. Letter (8.5" x 11")
B. A4
C. Legal
D. Executive
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Default paper size in US English version is Letter. In many regions, it's A4, but for competitive exams, often Letter is the default. I'll go with A, but clarify in solution that it depends on regional settings. Many exams ask default paper size = Letter (8.5x11). So I'll set A.
This question belongs to: Computer Microsoft Office
Question #847
In PowerPoint, to set a picture as the background of a slide, use:
A. View -> Slide Master -> Insert Picture
B. Design -> Format Background -> Picture or texture fill
C. Right-click slide -> Background -> Picture
D. Insert -> Picture -> Set as Background
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Format Background from Design tab allows picture fill.
This question belongs to: Computer Microsoft Office
Question #848
In MS Access, what is the maximum size of an OLE Object field?
A. Limited by database size
B. 256 MB
C. 2 GB
D. 1 GB
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
OLE Object fields can store up to 1 GB of data.
This question belongs to: Computer Microsoft Office
Question #849
Which of the following is NOT a valid text wrapping option in MS Word?
A. Square
B. Behind Text
C. Tight
D. Circular
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Circular is not a wrapping style. Valid: In line with text, Square, Tight, Through, Top and Bottom, Behind Text, In Front of Text.
This question belongs to: Computer Microsoft Office
Question #850
In Excel, to protect a worksheet from being edited, you can:
A. Home tab -> Format -> Protect
B. Review tab -> Protect Sheet
C. View tab -> Lock
D. File -> Info -> Protect Workbook
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Protect Sheet is under Review tab.
This question belongs to: Computer Microsoft Office
Question #851
In PowerPoint, which of the following is a type of slide layout?
A. Comparison
B. All of these
C. Section Header
D. Two Content
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All are standard slide layouts.
This question belongs to: Computer Microsoft Office
Question #852
In MS Access, to create a relationship between two tables, you typically use:
A. Design -> Relationships
B. Database Tools -> Relationships
C. Create -> Table Relationships
D. External Data -> Link Tables
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Relationships are managed under Database Tools tab.
This question belongs to: Computer Microsoft Office
Question #853
The shortcut to toggle between insert and overwrite mode in MS Word is:
A. Insert key
B. Alt + Insert
C. Ctrl + I
D. F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pressing Insert toggles between Insert and Overtype mode.
This question belongs to: Computer Microsoft Office
Question #854
Which of the following is a valid way to start a formula in Excel?
A. + (plus sign)
B. = (equal sign)
C. @ (at sign)
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
While = is standard, you can also start with + or - and Excel will convert it to a formula. @ is used in table references but not to begin a formula. So only = is required. + also works in some cases (e.g., +A1+A2). Many exams consider = only. I'll stick with = only. I'll set answer A.
This question belongs to: Computer Microsoft Office
Question #855
In MS Word, 'Footnote' and 'Endnote' are inserted from which tab?
A. References
B. Layout
C. Review
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Footnotes and endnotes are under References tab.
This question belongs to: Computer Microsoft Office
Question #856
In PowerPoint, to record a voice narration for a single slide, use:
A. Slide Show -> Record Slide Show -> Start Recording from Current Slide
B. Insert -> Audio -> Record Audio
C. Both A and B
D. Transitions -> Sound
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both methods can record narration; Record Audio inserts an audio clip on the slide, Record Slide Show captures timing and narration.
This question belongs to: Computer Microsoft Office
Question #857
In MS Access, which view shows data in a continuous form layout for rapid data entry?
A. Continuous Forms
B. Datasheet
C. Split Form
D. Single Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Continuous Forms display multiple records at once in a form format.
This question belongs to: Computer Microsoft Office
Question #858
To launch the 'Slide Show' from the beginning in PowerPoint, press:
A. Ctrl + F5
B. Alt + F5
C. F5
D. Shift + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F5 from beginning.
This question belongs to: Computer Microsoft Office
Question #859
Which of the following is NOT a valid function category in Excel?
A. Financial
B. Text
C. Graphing
D. Logical
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Graphing is not a function category. Categories include Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, Statistical, etc.
This question belongs to: Computer Microsoft Office
Question #860
In MS Word, the 'Columns' feature allows you to:
A. Divide text into newspaper-style columns
B. Adjust paragraph indents
C. Create a chart
D. Insert table columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Columns feature under Layout tab formats text in multiple columns.
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
Cyber Security 269 Memory and Storage Devices 438 Computer Networking 325 Microsoft Office 1199 Programming Languages 0
Explore Subjects
Accountancy and Statistics 3179 Maths 5575 Geography GK 6121 Current Affairs 575 Reasoning 2064
Practice Mix
The 'First Phase of the Revolutionary Movement' in India is associated with:
India won the ICC Men's T20 World Cup 2026 for a record how many times?
A boat can row 15 km/h in still water. If the velocity index of the stream tracks at 3 km/h, find the time parameter taken by the boat to row 36 km upstream.
A man sells an article for Rs. 880, gaining 10%. What is the cost price?
Which is a predicative adjective?