MCQ

MS Office (advanced) — Word, Excel, PowerPoint ... MCQ - Practice Questions

Practice 5 questions across 1 topics with detailed explanations.

Start mixed practice

5Questions

1Topics

3Difficulty levels

Topics in MS Office (advanced) — Word, Excel, PowerPoint ...

MS Office (advanced) — Word, Excel, PowerPoint and Access 5 questions

Sample questions

1Which statement correctly distinguishes a transition from an animation in PowerPoint?

A A transition controls objects on one slide, while an animation changes the slide master.

B A transition stores common design, while an animation creates speaker notes.

C A transition controls movement between slides, while an animation controls objects on a slide.

D A transition and an animation both control only the presentation theme.

2Which Microsoft Office application is primarily used to store related records in tables and work with relationships, queries, forms and reports?

A Access

B Word

C PowerPoint

D Excel

3Match List I with List II and select the correct code. List I: (a) Word style, (b) Excel PivotTable, (c) PowerPoint Slide Master, (d) Access form List II: (1) User-friendly data-entry screen, (2) Repeated presentation design, (3) Named set of formatting instructions, (4) Data summary through fields and aggregations

A a-4, b-3, c-1, d-2

B a-3, b-4, c-2, d-1

C a-2, b-1, c-4, d-3

D a-1, b-2, c-3, d-4

4Consider the following statements about Excel cell references: 1. A relative reference such as A1 changes when a formula is copied. 2. An absolute reference such as $A$1 remains fixed when a formula is copied. Which option is correct?

A Only statement 1 is correct

B Both statements 1 and 2 are correct

C Only statement 2 is correct

D Neither statement 1 nor statement 2 is correct

5Which of the following statements about Excel data tools is incorrect?

A Data validation can restrict cell entries to an allowed list or number range.

B Filtering displays only records that meet selected conditions.

C Sorting hides all records that do not meet a selected condition.

D A PivotTable can summarise data using aggregations such as count, sum or average.

Topics in MS Office (advanced) — Word, Excel, PowerPoint ...

Sample questions

Explore more subjects