Aspirant Academy
ENHI

MCQ

MS Office (advanced) — Word, Excel, PowerPoint and Access MCQ - Practice Questions with Answers

Solve 5 MS Office (advanced) — Word, Excel, PowerPoint and Access questions for RAS/RPSC preparation.

Practice questions

Q1Which 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
Explanation

Access is the relational database application in the Office suite; its main objects include tables, relationships, queries, forms and reports. Word is intended for formatted documents, PowerPoint for slide presentations, and Excel chiefly for worksheets and calculations, so they do not fit the complete set in the stem.

Q2Match 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
Explanation

A Word style is a named set of formatting instructions (a-3), and an Excel PivotTable summarises data through fields and aggregations (b-4). A PowerPoint Slide Master controls repeated design (c-2), while an Access form provides a user-friendly data-entry screen (d-1); only option B contains all four matches.

Q3Which 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.
Explanation

Transitions operate between slides, whereas animations apply to objects within a slide. The Slide Master, not either of these effects, stores repeated design, and speaker notes serve the presenter; this eliminates options A, B and D.

Q4Consider 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
Explanation

Both statements are correct. A relative reference adjusts with the copied formula, whereas the dollar signs in $A$1 lock both the column and the row; therefore options claiming that only one or neither statement is correct are eliminated.

Q5Which 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.
Explanation

Option C is incorrect because sorting changes the order of records; it does not hide records by a condition. Filtering performs the hiding described there, while data validation restricts entry and a PivotTable aggregates data, making options A, B and D correct.

You've seen 5 of 5 sample questions

Unlimited practice on MS Office (advanced) — Word, Excel, PowerPoint and Access comes with the RAS Test Series + Practice pack or Gate Pass.

Explore other subjects

Current AffairsReasoning & Mental AbilityIndian EconomyScience & TechnologyIndian Constitution & GovernanceRajasthan History, Art & CultureEnvironment & EcologyGeography of Rajasthan