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 31 of 60
Question #601
In PowerPoint, what does the 'Rehearse Timings' feature do?
A. Creates a summary of presentation length
B. Checks for grammar errors in slide text
C. Records the time you spend on each slide for automatic slide show
D. Adds a countdown timer for each animation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Rehearse Timings sets slide advance times for self-running presentations.
This question belongs to: Computer Microsoft Office
Question #602
In MS Access, a query that asks the user to input a specific value each time it is run is called a:
A. Crosstab query
B. Select query
C. Action query
D. Parameter query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A parameter query prompts for criteria. Select query retrieves data, crosstab summarizes, action query updates/deletes.
This question belongs to: Computer Microsoft Office
Question #603
Which shortcut key is used to copy formatting in MS Word and Excel?
A. Ctrl + C
B. Ctrl + Alt + C
C. Ctrl + Shift + V
D. Ctrl + Shift + C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + C copies format (Format Painter). Ctrl + Shift + V pastes format. Ctrl + C copies content.
This question belongs to: Computer Microsoft Office
Question #604
In Excel, which formula will correctly return the text 'Hello' from cell A1 if A1 contains 'Hello World'?
A. =TRIM(A1)
B. =MID(A1,1,6)
C. =LEFT(A1,5)
D. =RIGHT(A1,5)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LEFT(A1,5) extracts first 5 characters ('Hello'). RIGHT gets from right, MID from any position, TRIM removes extra spaces.
This question belongs to: Computer Microsoft Office
Question #605
Which file format is used for a macro-enabled Word document?
A. .docm
B. .docx
C. .dotm
D. .doc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.docm is macro-enabled document. .docx without macros, .dotm macro-enabled template.
This question belongs to: Computer Microsoft Office
Question #606
What does Ctrl + Y do in MS Office?
A. Redo or repeat the last action
B. Delete a line
C. Yank text to clipboard
D. Open a new document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Y redoes an undone action or repeats the last command.
This question belongs to: Computer Microsoft Office
Question #607
In PowerPoint, which of the following is an entrance animation effect?
A. Desaturate
B. Spin
C. Fly In
D. Teeter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Fly In is an entrance effect. Spin is emphasis, Teeter is also emphasis, Desaturate is not a standard animation.
This question belongs to: Computer Microsoft Office
Question #608
In MS Access, which view is used to design the structure of a table (field names, data types)?
A. Design View
B. Form View
C. Datasheet View
D. Layout View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Design View is used to define field properties. Datasheet View shows data in rows/columns.
This question belongs to: Computer Microsoft Office
Question #609
Which of the following is the shortcut to save the current workbook in Excel?
A. Alt + F4
B. F12
C. Ctrl + Shift + S
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.
This question belongs to: Computer Microsoft Office
Question #610
In Word, what is the function of the 'Format Painter'?
A. Clears all formatting
B. Checks spelling and grammar
C. Changes the font of the entire document
D. Copies formatting from one piece of text and applies it to another
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format Painter copies format. Clear Formatting removes formatting.
This question belongs to: Computer Microsoft Office
Question #611
In Excel, to quickly sum a range of numbers, use the shortcut:
A. Alt + =
B. Ctrl + Shift + $
C. Alt + Shift + =
D. Ctrl + +
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt + = inserts the AutoSum function.
This question belongs to: Computer Microsoft Office
Question #612
In PowerPoint, what file extension indicates a PowerPoint Show that opens directly in slideshow mode?
A. .pptx
B. .potx
C. .pptm
D. .ppsx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.ppsx is PowerPoint Show. .pptx is presentation, .potx template, .pptm macro-enabled presentation.
This question belongs to: Computer Microsoft Office
Question #613
Which of the following is a valid MS Access data type for storing pictures?
A. OLE Object
B. Attachment
C. Text
D. Hyperlink
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Attachment data type (Access 2007+) stores images and files. OLE Object is older but also stores objects; however, Attachment is the modern recommended type.
This question belongs to: Computer Microsoft Office
Question #614
In MS Word, what does the shortcut Ctrl + Shift + > do?
A. Increases the font size
B. Increases indent
C. Applies superscript
D. Toggles subscript
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Shift + > increases font size; Ctrl + Shift + < decreases.
This question belongs to: Computer Microsoft Office
Question #615
What is the purpose of the PMT function in Excel?
A. Converts a number to text with currency format
B. Returns the present value of an investment
C. Projects the future value of an investment
D. Calculates the periodic payment for a loan based on constant payments and interest rate
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT(rate, nper, pv) computes loan payment. FV returns future value, PV present value.
This question belongs to: Computer Microsoft Office
Question #616
Which view in MS Word displays the document without margins, headers, or footers for easier reading on screen?
A. Outline
B. Web Layout
C. Print Layout
D. Read Mode
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Read Mode (Full Screen Reading) maximizes reading space, hiding many toolbars. Print Layout shows margins and page breaks.
This question belongs to: Computer Microsoft Office
Question #617
To convert text to uppercase in Excel, which function is used?
A. UPPER()
B. PROPER()
C. LOWER()
D. CAPITAL()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPPER makes all letters uppercase. PROPER capitalizes each word's first letter, LOWER makes all lowercase.
This question belongs to: Computer Microsoft Office
Question #618
In MS Access, what is the default data type for a new text field (Short Text)?
A. Currency
B. Memo
C. Number
D. Short Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In Access 2013/2016, the default data type for a text field is Short Text (previously Text).
This question belongs to: Computer Microsoft Office
Question #619
Which key should be pressed to move to the next slide during a PowerPoint presentation?
A. Tab
B. Enter
C. Any of the above
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All these keys advance to the next slide: Spacebar, Enter, Page Down, Right Arrow, Down Arrow, or N.
This question belongs to: Computer Microsoft Office
Question #620
In MS Word, what does the 'Thesaurus' feature do?
A. Counts the words in the document
B. Provides synonyms and antonyms for a selected word
C. Checks the grammar of the document
D. Translates selected text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Thesaurus (Shift+F7) offers synonyms/antonyms.
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?'