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 8 of 60
Question #141
In MS Word, the 'Thesaurus' tool is available under which tab?
A. Home
B. Insert
C. References
D. Review
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Thesaurus is located in the Review tab, in the Proofing group. It provides synonyms and antonyms.
This question belongs to: Computer Microsoft Office
Question #142
Which of the following functions in Excel returns the current date and time?
A. =NOW()
B. =TIME()
C. =DATE()
D. =TODAY()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
=NOW() returns the current date and time. =TODAY() returns only current date. =DATE() creates a date from year, month, day. =TIME() creates time.
This question belongs to: Computer Microsoft Office
Question #143
In MS Access, what is the purpose of a 'Query'?
A. To store data
B. To create user interface forms
C. To retrieve and manipulate data from tables
D. To print reports
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Queries are used to retrieve, update, delete, or analyze data from tables based on specified criteria. They do not store data permanently (except make-table queries).
This question belongs to: Computer Microsoft Office
Question #144
Which shortcut key is used to apply bold formatting to selected text in all MS Office applications?
A. Ctrl + B
B. Alt + B
C. Ctrl + F2
D. Ctrl + Shift + B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + B toggles bold formatting. Ctrl + Shift + B is used in some apps for different function, Alt+B is not standard, Ctrl+F2 is print preview.
This question belongs to: Computer Microsoft Office
Question #145
In MS Excel, what does the 'Merge & Center' option do?
A. Merges selected cells into one and centers the content
B. Centers text without merging
C. Merges cells without centering
D. Splits merged cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Merge & Center combines the selected cells into a single cell and centers the text horizontally.
This question belongs to: Computer Microsoft Office
Question #146
Which view in MS PowerPoint is used to rehearse timings for a slideshow?
A. Slide Show View
B. Slide Sorter View
C. Presenter View
D. Reading View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Presenter View allows the presenter to see notes, preview next slides, and rehearse timings while the audience sees only the slide show. Slide Show View runs the presentation.
This question belongs to: Computer Microsoft Office
Question #147
What is the maximum number of characters that can be stored in a 'Text' field in MS Access (Short Text)?
A. 1 GB
B. 64,000
C. 255
D. 256
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Short Text field in Access can store up to 255 characters. Long Text can store up to 65,535 characters.
This question belongs to: Computer Microsoft Office
Question #148
In MS Word, which of the following is used to create a list of headings and their page numbers?
A. Table of Contents
B. Bibliography
C. Table of Figures
D. Index
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Contents generates a list of headings with their corresponding page numbers based on heading styles. Index lists keywords, Table of Figures lists captions, Bibliography lists sources.
This question belongs to: Computer Microsoft Office
Question #149
In MS PowerPoint, which option allows you to apply a consistent look to all slides, including fonts, colors, and effects?
A. Theme
B. Layout
C. Template
D. Style
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Theme is a set of design elements including colors, fonts, and effects that can be applied to all slides. Template is a file that includes layout and content, Layout is a slide arrangement, Style is formatting.
This question belongs to: Computer Microsoft Office
Question #150
What is the function of the 'Alt + Tab' shortcut in Windows OS while working with MS Office?
A. Close the current application
B. Switch between documents within the same application
C. Switch between open applications
D. Open Task Manager
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt + Tab is a Windows shortcut to switch between open applications. Ctrl + Tab switches between documents in the same app. Alt + F4 closes the current window. Ctrl + Shift + Esc opens Task Manager.
This question belongs to: Computer Microsoft Office
Question #151
In MS Excel, which chart type is best suited for showing trends over time?
A. Line Chart
B. Column Chart
C. Pie Chart
D. Bar Chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Line charts are ideal for displaying trends over time or categories. Pie charts show proportions, bar and column compare categories.
This question belongs to: Computer Microsoft Office
Question #152
Which of the following is not a valid way to start a new slide in MS PowerPoint?
A. Ctrl + N
B. Ctrl + M
C. Right-click in the slide pane and select New Slide
D. New Slide button on Home tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + N opens a new presentation, not a new slide. Ctrl + M inserts a new slide. The other options insert a new slide.
This question belongs to: Computer Microsoft Office
Question #153
In MS Access, what is a 'Primary Key'?
A. A field used for sorting
B. A field that uniquely identifies each record in a table
C. A field that stores external data
D. A field that allows duplicate values
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.
This question belongs to: Computer Microsoft Office
Question #154
What is the shortcut key to open the 'Font' dialog box in MS Word?
A. Ctrl + Shift + F
B. Alt + O, F
C. Ctrl + F
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + D opens the Font dialog box in Word. Ctrl + F opens Find, Ctrl+Shift+F opens the Font dialog as well (but less common), Alt+O,F is menu navigation. However, Ctrl+D is the standard shortcut.
This question belongs to: Computer Microsoft Office
Question #155
In Excel, which function calculates the total of a range but ignores error values?
A. SUMIF
B. AGGREGATE
C. SUMPRODUCT
D. SUM
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
This question belongs to: Computer Microsoft Office
Question #156
Which of the following is the file extension for an MS Word template?
A. .dotx
B. .dotm
C. .docx
D. .docm
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.dotx is the extension for a Word template (macro-free). .docx is a document, .docm is macro-enabled document, .dotm is macro-enabled template.
This question belongs to: Computer Microsoft Office
Question #157
In MS PowerPoint, which pane displays the text content of slides in an outline format?
A. Slides pane
B. Outline pane
C. Task pane
D. Notes pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Outline pane (or Outline view) shows the slide text in a hierarchical outline. Slides pane shows thumbnails, Notes pane shows speaker notes.
This question belongs to: Computer Microsoft Office
Question #158
What is the keyboard shortcut to cut selected content in MS Office?
A. Ctrl + C
B. Ctrl + X
C. Ctrl + Z
D. Ctrl + V
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + X cuts (removes) the selection and places it on the clipboard. Ctrl + C copies, Ctrl + V pastes, Ctrl + Z undoes.
This question belongs to: Computer Microsoft Office
Question #159
In Excel, what does the 'VLOOKUP' function stand for?
A. Value Lookup
B. Vertical Lookup
C. Vector Lookup
D. Variable Lookup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
VLOOKUP stands for Vertical Lookup, used to search for a value in the first column of a table and return a value in the same row from another column.
This question belongs to: Computer Microsoft Office
Question #160
Which feature in MS Word allows you to automatically add a reference list at the end of a document for cited sources?
A. Index
B. Table of Contents
C. Bibliography
D. Cross-reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Bibliography feature in Word creates a list of sources cited in the document. Table of Contents lists headings, Index lists keywords, Cross-reference links to other parts.
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?'