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 38 of 60
Question #741
In MS Access, which data type can store up to 1 GB of data for attachments?
A. Memo
B. Hyperlink
C. Attachment
D. OLE Object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Attachment data type stores multiple files up to 2 GB total, but each file can be up to 256 MB, overall database limit. OLE Object also stores objects but is older.
This question belongs to: Computer Microsoft Office
Question #742
In MS Word, what does the 'Ctrl + Shift + K' shortcut do?
A. Changes the font to Symbol
B. Inserts a hyperlink
C. Applies small caps formatting
D. Starts a new line without breaking paragraph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+K toggles small caps.
This question belongs to: Computer Microsoft Office
Question #743
In Excel, which chart type shows the proportion of each data series relative to the total using nested rings?
A. Doughnut
B. Treemap
C. Sunburst
D. Pie
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Doughnut chart is like a pie with a hole, can show multiple series. Sunburst shows hierarchical rings.
This question belongs to: Computer Microsoft Office
Question #744
Which view in PowerPoint is used to add speaker notes that are not visible to the audience?
A. Reading view
B. Notes Page view
C. Outline view
D. Normal view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Notes Page view allows editing speaker notes beneath each slide.
This question belongs to: Computer Microsoft Office
Question #745
In MS Access, to create a form that displays data from a query, use:
A. Report Wizard
B. Table Analyzer
C. Form Wizard or Form Design based on the query
D. Macro Builder
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms can be bound to tables or queries.
This question belongs to: Computer Microsoft Office
Question #746
In Excel, the formula =$A1 is an example of:
A. Mixed reference (column absolute, row relative)
B. Relative reference
C. Absolute reference
D. Circular reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
$A locks column A, row remains relative.
This question belongs to: Computer Microsoft Office
Question #747
In PowerPoint, the 'Morph' transition is available in which version?
A. All versions
B. PowerPoint 2010
C. Office 365 / PowerPoint 2019 and later
D. PowerPoint 2007
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Morph was introduced in PowerPoint 2016 (Office 365) and later versions.
This question belongs to: Computer Microsoft Office
Question #748
In MS Access, SQL View is used to:
A. Write or edit SQL statements for a query
B. Run a macro
C. Design the table structure
D. View the output of a query in a datasheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SQL View shows the query's SQL code.
This question belongs to: Computer Microsoft Office
Question #749
What is the shortcut to insert a comment in MS Excel?
A. Ctrl + F2
B. Alt + F2
C. F2
D. Shift + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F2 inserts or edits a comment in Excel. (In newer versions, Right-click > New Note.)
This question belongs to: Computer Microsoft Office
Question #750
In MS Word, which option allows you to insert frequently used content like headers, footers, and page numbers quickly?
A. SmartArt
B. WordArt
C. Quick Parts
D. AutoText
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Quick Parts (Insert tab) includes AutoText, Document Property, etc.
This question belongs to: Computer Microsoft Office
Question #751
In Excel, to insert a chart sheet (chart on a separate sheet), press:
A. F11
B. Shift + F11
C. Alt + F1
D. Ctrl + F11
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F11 creates a chart on a new chart sheet. Alt+F1 embeds chart in the same sheet.
This question belongs to: Computer Microsoft Office
Question #752
In PowerPoint, which button allows you to present online to remote viewers?
A. Broadcast Slide Show
B. Share via OneDrive
C. Skype Meeting
D. Present Online (or Office Presentation Service)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Present Online (Office Presentation Service) lets others view in a browser. In newer versions, it's 'Present Online' or 'Share'. Broadcast Slide Show was older term.
This question belongs to: Computer Microsoft Office
Question #753
In MS Access, the 'Record Source' property of a form specifies:
A. The filter applied to the form
B. The event to trigger on record change
C. The sort order of records
D. The table or query that provides the data for the form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Record Source binds a form to a data source.
This question belongs to: Computer Microsoft Office
Question #754
To select an entire paragraph in MS Word, you can:
A. Ctrl + Click
B. Double-click the paragraph
C. Triple-click anywhere in the paragraph
D. Shift + Click
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Triple-click selects the whole paragraph.
This question belongs to: Computer Microsoft Office
Question #755
In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:
A. Descending order
B. Closest match
C. Approximate match
D. Exact match
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
FALSE requires an exact match. TRUE or omitted allows approximate match.
This question belongs to: Computer Microsoft Office
Question #756
Which option in PowerPoint is used to set the slide size (e.g., Standard 4:3 or Widescreen 16:9)?
A. Home tab -> Layout
B. Design tab -> Slide Size
C. Insert tab -> Slide Size
D. View tab -> Zoom
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Size is in Design tab, Customize group.
This question belongs to: Computer Microsoft Office
Question #757
In MS Access, a field that stores hyperlinks (URLs) has data type:
A. Attachment
B. OLE Object
C. Hyperlink
D. Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Hyperlink data type stores clickable URLs.
This question belongs to: Computer Microsoft Office
Question #758
What is the function of the 'Ctrl + Shift + End' key combination in Excel?
A. Selects all cells from the current position to the last used cell in the worksheet
B. Saves and closes the workbook
C. Moves the active cell to the last cell
D. Deletes all data to the right
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+End extends the selection to the bottom-right used cell.
This question belongs to: Computer Microsoft Office
Question #759
In MS Word, the 'Drop Cap' feature is found under which tab?
A. Insert
B. Layout
C. Design
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Drop Cap is in the Insert tab, Text group.
This question belongs to: Computer Microsoft Office
Question #760
In Excel, what does the COUNTA function count?
A. Only text cells
B. All non-empty cells
C. Only numeric cells
D. Only blank cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNTA counts cells containing any type of data (numbers, text, errors, etc.), excluding empty cells.
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: