Learn with Anil · APPSC Assistant Statistical Officer (ASO) PYQsPractise online →Subscribe ₹149

APPSC ASO 2025 Paper 2 · Question 143

Question 143 of the APPSC Assistant Statistical Officer 2025: Paper II (Statistics, Economics, Accountancy & Computers) (29 April 2025). Try it first, then open the answer. The explanation is in the practice app with the All-in-One Pass.

  1. ASO 2025 Paper 2 · Q143 · Basics of Computers · MS Excel & Office

    Select the option that is correct regarding the following two statements labelled Assertion (A) and Reason (R). Assertion (A): In MS-Excel 2019, inserting a new row in the middle of a dataset shifts the existing rows downward, preserving the relative cell references in formulas. Reason (R): MS-Excel automatically updates absolute cell references when new rows or columns are inserted to ensure formulas remain accurate.

    1. Both Assertion (A) and Reason (R) are true, and (R) correctly explains (A).
    2. Both Assertion (A) and Reason (R) are true, but (R) does not correctly explain (A).
    3. Assertion (A) is true, but Reason (R) is false.
    4. Assertion (A) is false, but Reason (R) is true.
    Show answer

    Answer: (3) Assertion (A) is true, but Reason (R) is false.

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

Answer it in the practice appMake a topic-wise quiz