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 46 of 60
Question #901
In MS Access, which data type should you choose to store a web address?
A. Attachment
B. Text
C. Memo
D. Hyperlink
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Hyperlink data type stores URLs.
This question belongs to: Computer Microsoft Office
Question #902
What is the keyboard shortcut to open the 'Font' dialog box in MS Word?
A. Both A and B
B. Ctrl + Shift + F
C. Ctrl + F
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+D opens Font dialog. Ctrl+Shift+F also opens Font dialog with Font tab selected.
This question belongs to: Computer Microsoft Office
Question #903
In Excel, the 'Paste Special' dialog can be opened with:
A. Both A and C
B. Ctrl + Shift + V
C. Ctrl + Alt + V
D. Alt + E, S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+V opens Paste Special. Alt+E,S also opens it (legacy).
This question belongs to: Computer Microsoft Office
Question #904
In PowerPoint, what is the extension of a PowerPoint template?
A. .pptx
B. .potx
C. .ppsx
D. .pptm
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.potx is template.
This question belongs to: Computer Microsoft Office
Question #905
In MS Access, which type of query makes a new table?
A. Append query
B. Make-Table query
C. Select query
D. Update query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Make-Table creates new table from query results.
This question belongs to: Computer Microsoft Office
Question #906
Which shortcut key is used to center align text in MS Word?
A. Ctrl + J
B. Ctrl + L
C. Ctrl + E
D. Ctrl + R
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+E centres, Ctrl+L left, Ctrl+R right, Ctrl+J justify.
This question belongs to: Computer Microsoft Office
Question #907
In Excel, which function returns the number of days in a month?
A. EDATE()
B. MONTH()
C. DAYSINMONTH()
D. EOMONTH() with DAY()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
There is no direct function; you can use =DAY(EOMONTH(date,0)).
This question belongs to: Computer Microsoft Office
Question #908
In PowerPoint, to hide the slide thumbnails pane, you can:
A. Click the X at the top right of the pane or drag the splitter
B. Right-click slide and Hide
C. Press Ctrl + F1
D. Go to View -> Slide Thumbnails
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Close or resize the thumbnails pane.
This question belongs to: Computer Microsoft Office
Question #909
In MS Access, which property defines the pattern for data entry (like phone number)?
A. Format
B. Input Mask
C. Default Value
D. Validation Rule
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Input Mask controls entry format.
This question belongs to: Computer Microsoft Office
Question #910
To create a hanging indent in MS Word, press:
A. Tab
B. Ctrl + Shift + T
C. Ctrl + T
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.
This question belongs to: Computer Microsoft Office
Question #911
In Excel, what does the formula =SUMIF(A1:A10, ">5") do?
A. Counts cells greater than 5
B. Sums all values and adds 5
C. Sums values in A1:A10 that are greater than 5
D. Returns error
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SUMIF with criteria ">5" sums cells >5 in the range.
This question belongs to: Computer Microsoft Office
Question #912
In PowerPoint, 'Embed fonts' option is available under:
A. File -> Options -> Save
B. Insert -> Text -> Font
C. Design -> Fonts
D. View -> Slide Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Embed fonts is in PowerPoint Options, Save section.
This question belongs to: Computer Microsoft Office
Question #913
In MS Access, the 'Expression Builder' helps to:
A. Generate reports
B. Build SQL queries graphically
C. Create calculated fields, validation rules, and query criteria
D. Design forms visually
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Expression Builder assists in writing expressions.
This question belongs to: Computer Microsoft Office
Question #914
What is the default file extension of a macro-enabled PowerPoint presentation?
A. .ppsm
B. .pptm
C. .potm
D. .pptx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.pptm is macro-enabled presentation. .ppsm macro-enabled show.
This question belongs to: Computer Microsoft Office
Question #915
In MS Word, the 'Equation' tool is used to insert:
A. Chemical equations only
B. SmartArt graphics
C. Statistical charts
D. Mathematical equations and formulas
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Equation under Insert tab allows mathematical notation.
This question belongs to: Computer Microsoft Office
Question #916
In Excel, the keyboard shortcut to edit a cell comment (note) is:
A. Ctrl + F2
B. Alt + F2
C. Shift + F2
D. F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shift+F2 inserts or edits comment.
This question belongs to: Computer Microsoft Office
Question #917
Which of the following is a 'view' available for slides in PowerPoint?
A. Normal
B. All of these
C. Slide Sorter
D. Outline
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All are views.
This question belongs to: Computer Microsoft Office
Question #918
In MS Access, what is the maximum number of fields in a table?
A. 255
B. 1,000
C. 256
D. 64
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An Access table can have up to 255 fields.
This question belongs to: Computer Microsoft Office
Question #919
To quickly find the sum of selected cells in Excel, look at:
A. Status bar
B. Title bar
C. Formula bar
D. Name box
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
When you select numeric cells, the status bar displays Sum, Average, Count.
This question belongs to: Computer Microsoft Office
Question #920
In MS Word, 'Shrink One Page' command attempts to:
A. Reduce the document by one page by adjusting font size and spacing
B. Delete the last page
C. Zoom out
D. Print the document on one page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shrink One Page (Print Preview) reduces content to fit one less page.
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 Fundamentals 326 Programming Languages 0 Computer Software 347 Computer Networking 325 Internet and Web Technologies 461
Explore Subjects
English 15164 Computer 5279 Geography GK 6121 Static General Knowledge 6362 History GK 3374
Practice Mix
A man rows a distance of 16 km downstream in 2 hours and returns upstream in 4 hours. Find the speed of the river current.
The Naga Hills are in:
Sundar walks 4 km towards east. Then he turns right and walks 3 km. Again he turns to the right and continues walking. Which direction is he going now?
At what rate percent compound interest will Rs. 1000 become Rs. 1728 in 3 years?
Carnot efficiency depends on: