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. Attachment
B. Hyperlink
C. OLE Object
D. Memo
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Starts a new line without breaking paragraph
B. Inserts a hyperlink
C. Changes the font to Symbol
D. Applies small caps formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Pie
B. Doughnut
C. Treemap
D. Sunburst
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Normal view
B. Outline view
C. Notes Page view
D. Reading view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Macro Builder
B. Report Wizard
C. Table Analyzer
D. Form Wizard or Form Design based on the query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Relative reference
B. Circular reference
C. Absolute reference
D. Mixed reference (column absolute, row relative)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. PowerPoint 2007
B. All versions
C. Office 365 / PowerPoint 2019 and later
D. PowerPoint 2010
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. Run a macro
B. View the output of a query in a datasheet
C. Design the table structure
D. Write or edit SQL statements for a query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option B

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. AutoText
B. Quick Parts
C. WordArt
D. SmartArt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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

Correct Answer: Option B

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. Share via OneDrive
B. Skype Meeting
C. Broadcast Slide Show
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 sort order of records
B. The table or query that provides the data for the form
C. The event to trigger on record change
D. The filter applied to the form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Shift + Click
C. Double-click the paragraph
D. Triple-click anywhere in the paragraph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Approximate match
B. Exact match
C. Closest match
D. Descending order
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Design tab -> Slide Size
B. Home tab -> Layout
C. View tab -> Zoom
D. Insert tab -> Slide Size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. OLE Object
B. Text
C. Hyperlink
D. Attachment
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. Moves the active cell to the last cell
C. Saves and closes the workbook
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. Layout
B. Insert
C. Design
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. All non-empty cells
B. Only text cells
C. Only numeric cells
D. Only blank cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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