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 39 of 60
Question #761
In PowerPoint, which feature allows you to apply a transition effect to all slides at once?
A. Apply To All button in Transitions tab
B. Animation Painter
C. Slide Master
D. Copy formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
After selecting a transition, clicking 'Apply To All' sets it for every slide.
This question belongs to: Computer Microsoft Office
Question #762
In MS Access, a relationship between two tables that requires a third junction table is called:
A. One-to-One
B. Self-join
C. One-to-Many
D. Many-to-Many
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Many-to-many relationships need a junction table with foreign keys to both primary tables.
This question belongs to: Computer Microsoft Office
Question #763
To navigate to the next cell in a table in MS Word, press:
A. Arrow keys
B. Ctrl + Right arrow
C. Tab
D. Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Tab moves to next cell; Shift+Tab to previous.
This question belongs to: Computer Microsoft Office
Question #764
In Excel, what does the 'Flash Fill' feature do?
A. Copies formatting from adjacent cells
B. Fills a range with random numbers
C. Fills cells with a series like AutoFill
D. Automatically fills values by detecting patterns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.
This question belongs to: Computer Microsoft Office
Question #765
Which of the following is a correct order to apply custom animation to an object in PowerPoint?
A. Insert tab -> Animation
B. Design tab -> Animate
C. Animations tab -> Add Animation -> select object
D. Select object -> Animations tab -> Add Animation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
First select the object, then add animation from the Animations tab.
This question belongs to: Computer Microsoft Office
Question #766
In MS Access, to import data from an Excel file, you can use:
A. Create tab -> Table from Excel
B. Database Tools -> Import
C. External Data tab -> Import Excel
D. Home tab -> Get External Data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The External Data tab provides import and link options.
This question belongs to: Computer Microsoft Office
Question #767
What is the shortcut to open the 'Format Cells' dialog with Font tab in Excel?
A. Alt + F
B. Ctrl + Shift + F
C. Ctrl + Shift + P
D. Ctrl + 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+F opens Format Cells -> Font. Ctrl+1 opens main Format Cells.
This question belongs to: Computer Microsoft Office
Question #768
In MS Word, 'Kerning' refers to:
A. Fitting text to a shape
B. Applying shadow effects to text
C. Adjusting the spacing between specific pairs of characters
D. Changing the line spacing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Kerning adjusts space between individual letters.
This question belongs to: Computer Microsoft Office
Question #769
In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20?
A. =NOT(A1>10)
B. =OR(A1>10, A1<20)
C. =AND(A1>10, A1<20)
D. =IF(A1>10, A1<20)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AND returns TRUE if all conditions are true.
This question belongs to: Computer Microsoft Office
Question #770
In PowerPoint, to loop a slide show continuously until Esc is pressed, set:
A. Design tab -> Customize -> Loop
B. Animations tab -> Repeat
C. Slide Show tab -> Set Up Slide Show -> Loop continuously until 'Esc'
D. Transitions tab -> Advance Slide -> After -> Repeat
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Set Up Show' dialog has the loop option.
This question belongs to: Computer Microsoft Office
Question #771
In MS Access, a select query that groups records and calculates sums, averages, etc., uses:
A. Sort row
B. Criteria row
C. Totals (Group By) row
D. Show row
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Clicking the Totals button (Σ) adds the Total row for grouping and aggregating.
This question belongs to: Computer Microsoft Office
Question #772
Which key combination is used to switch between open applications in Windows (and also in Office)?
A. Alt + Tab
B. Windows + Tab
C. Ctrl + Tab
D. Shift + Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+Tab switches between open windows. Ctrl+Tab switches between document windows within an application.
This question belongs to: Computer Microsoft Office
Question #773
In MS Word, what is the maximum font size that can be typed directly in the font size box?
A. 999
B. 1638
C. 72
D. 409
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can type up to 1638 points. The dropdown shows up to 72, but you can enter larger.
This question belongs to: Computer Microsoft Office
Question #774
In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:
A. Second row, third column of the range A1:C3
B. Third row, second column
C. Cell B2
D. An error
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell C2.
This question belongs to: Computer Microsoft Office
Question #775
In PowerPoint, the shortcut to insert a new comment is:
A. Ctrl + Alt + M
B. Shift + F2
C. Alt + N
D. Ctrl + Shift + C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+M inserts a new comment in PowerPoint.
This question belongs to: Computer Microsoft Office
Question #776
In MS Access, which query type creates a new table from the results of a query?
A. Delete query
B. Make-Table query
C. Append query
D. Update query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Make-Table query creates a new table and populates it.
This question belongs to: Computer Microsoft Office
Question #777
To add a row above the current row in an Excel table, press:
A. Ctrl + +
B. Ctrl + Shift + +
C. Alt + I, R
D. Shift + Space, Ctrl + +
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Select a cell, then Ctrl+Shift++ opens Insert dialog; if whole row is selected, it inserts. Also Ctrl++ works. But the common shortcut: Ctrl+Shift+plus sign. Both are plausible. I'll set A as correct: Ctrl+Shift++.
This question belongs to: Computer Microsoft Office
Question #778
In MS Word, what does 'Widow/Orphan control' prevent?
A. Page breaks before headings
B. Two consecutive hyphens
C. A single line of a paragraph at the top or bottom of a page
D. Overlapping text and images
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Widow/Orphan control keeps at least two lines together at page breaks.
This question belongs to: Computer Microsoft Office
Question #779
In Excel, which of the following formulas calculates the monthly payment for a loan of ₹5,00,000 at 10% annual interest for 5 years?
A. =PMT(10%/12, 5*12, -500000)
B. =PMT(10%, 5, 500000)
C. =FV(10%, 5, 500000)
D. =PV(10%/12, 5*12, -500000)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PMT requires rate per period, total periods, present value. Monthly rate is 10%/12, periods 60, PV -500000.
This question belongs to: Computer Microsoft Office
Question #780
In PowerPoint, 'Slide Show' menu offers 'Custom Slide Show' to:
A. Record narration
B. Apply custom animations to all slides
C. Change slide orientation
D. Play only selected slides in a specific order
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Custom Slide Show presents a subset of slides.
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: