MS Office MCQs with Answers and Explanations

Question #981

Share Report

In Excel, which function returns the average of absolute deviations of data points from their mean?

A. VAR()

B. AVERAGE()

C. AVEDEV()

D. STDEV()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AVEDEV calculates average absolute deviation.

This question belongs to: Computer Microsoft Office

Question #982

Share Report

In MS Word, what is the purpose of 'Section Break (Next Page)'?

A. Ends the document

B. Inserts a page break only

C. Starts a new section on the same page

D. Starts a new section on the next page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Next Page section break starts a new section on a new page.

This question belongs to: Computer Microsoft Office

Question #983

Share Report

In PowerPoint, which option allows you to save a presentation as a video?

A. Save As -> MP4

B. File -> Export -> Create a Video

C. Both A and B

D. Slide Show -> Record -> Export

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both Export and Save As can create a video file.

This question belongs to: Computer Microsoft Office

Question #984

Share Report

In MS Access, to add a new table using SQL, you use:

A. SELECT INTO

B. CREATE TABLE

C. INSERT INTO

D. ALTER TABLE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CREATE TABLE defines a new table.

This question belongs to: Computer Microsoft Office

Question #985

Share Report

The shortcut to open the 'Find' dialog in MS Excel is:

A. Both A and B

B. Shift + F5

C. F5

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+F and Shift+F5 both open Find dialog.

This question belongs to: Computer Microsoft Office

Question #986

Share Report

In MS Word, to insert an index, go to:

A. References -> Insert Index

B. Insert -> Index

C. Review -> Index

D. Layout -> Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Index is under References tab.

This question belongs to: Computer Microsoft Office

Question #987

Share Report

In PowerPoint, what is the maximum number of slides a presentation can have?

A. 10,000

B. 1,000

C. No fixed limit; limited by system resources

D. 65,536

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
There's no practical slide limit, just memory.

This question belongs to: Computer Microsoft Office

Question #988

Share Report

In MS Access, which data type automatically inserts a unique sequential number?

A. AutoNumber

B. Calculated

C. Text

D. Number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AutoNumber increments automatically.

This question belongs to: Computer Microsoft Office

Question #989

Share Report

Which key combination is used to extend a selection to the beginning of a document in MS Word?

A. Ctrl + Home

B. Shift + Home

C. Alt + Home

D. Ctrl + Shift + Home

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+Home selects from cursor to document start.

This question belongs to: Computer Microsoft Office

Question #990

Share Report

In Excel, to display the 'Go To' dialog, press:

A. Ctrl + G

B. Alt + G

C. F5

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F5 and Ctrl+G both open Go To.

This question belongs to: Computer Microsoft Office

Question #991

Share Report

In PowerPoint, which view is best for reordering slides using drag and drop?

A. Reading

B. Notes Page

C. Normal

D. Slide Sorter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Sorter simplifies reordering.

This question belongs to: Computer Microsoft Office

Question #992

Share Report

In MS Access, which clause in SQL is used to specify the table from which to retrieve data?

A. SELECT

B. FROM

C. WHERE

D. INTO

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
FROM clause specifies table.

This question belongs to: Computer Microsoft Office

Question #993

Share Report

In Excel, what does the function =ROW() return in cell C5?

A. 3

B. Error

C. C5

D. 5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ROW() without argument returns the row number of the cell containing the formula.

This question belongs to: Computer Microsoft Office

Question #994

Share Report

In MS Word, to create a table by drawing, use:

A. Home -> Table

B. Insert -> Table -> Draw Table

C. Design -> Table -> Draw

D. Layout -> Draw Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Insert tab -> Table -> Draw Table.

This question belongs to: Computer Microsoft Office

Question #995

Share Report

Which of the following is a valid Excel function to find the position of a substring (case-insensitive)?

A. MATCH()

B. SEARCH()

C. FIND()

D. INSTR()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SEARCH is case-insensitive. FIND is case-sensitive.

This question belongs to: Computer Microsoft Office

Question #996

Share Report

In PowerPoint, 'Broadcast Slide Show' allows:

A. Sending slides via email

B. Remote viewers to watch the presentation in a web browser

C. Recording a video of the presentation

D. Creating a podcast

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Broadcast Slide Show (now Present Online) streams the slide show.

This question belongs to: Computer Microsoft Office

Question #997

Share Report

In MS Access, to delete all records from a table while keeping the structure, use:

A. ALTER TABLE;

B. DROP TABLE table_name;

C. TRUNCATE TABLE;

D. DELETE * FROM table_name;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
DELETE command removes records. DROP TABLE removes entire table. Access does not support TRUNCATE.

This question belongs to: Computer Microsoft Office

Question #998

Share Report

In MS Word, to save a document with a new name, press:

A. Ctrl + S

B. Ctrl + Shift + S

C. F12

D. Shift + F12

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F12 is Save As.

This question belongs to: Computer Microsoft Office

Question #999

Share Report

In Excel, to delete a worksheet, right-click the sheet tab and select:

A. Remove

B. Cut

C. Clear

D. Delete

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Right-click -> Delete removes the sheet.

This question belongs to: Computer Microsoft Office

Question #1000

Share Report

In PowerPoint, which tab contains the 'Record' option?

A. Insert

B. Slide Show

C. Animations

D. Design

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Record Slide Show is on Slide Show tab.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics