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. COUNTA()
B. ISBLANK()
C. COUNTIF()
D. COUNTBLANK()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. D
B. Ctrl + P (to activate Pen)
C. W
D. P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Creates a backup
B. Splits the database into front-end and back-end
C. Reduces file size and fixes corruption
D. Encrypts the database
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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

Correct Answer: Option A

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. Low
B. High
C. Error
D. Medium
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Legal
C. Executive
D. A4
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. Right-click slide -> Background -> Picture
B. Design -> Format Background -> Picture or texture fill
C. Insert -> Picture -> Set as Background
D. View -> Slide Master -> Insert Picture
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. 1 GB
B. 2 GB
C. 256 MB
D. Limited by database size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Tight
B. Square
C. Circular
D. Behind Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. View tab -> Lock
B. Review tab -> Protect Sheet
C. Home tab -> Format -> Protect
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. Two Content
B. Section Header
C. All of these
D. Comparison
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Database Tools -> Relationships
B. External Data -> Link Tables
C. Design -> Relationships
D. Create -> Table Relationships
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. F2
D. Ctrl + I
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. All of these
B. + (plus sign)
C. @ (at sign)
D. = (equal sign)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Review
B. Insert
C. Layout
D. References
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Transitions -> Sound
B. Insert -> Audio -> Record Audio
C. Slide Show -> Record Slide Show -> Start Recording from Current Slide
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Split Form
B. Datasheet
C. Single Form
D. Continuous Forms
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option B

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. Logical
B. Financial
C. Text
D. Graphing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Create a chart
B. Adjust paragraph indents
C. Divide text into newspaper-style columns
D. Insert table columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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