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.
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.
- Both Assertion (A) and Reason (R) are true, and (R) correctly explains (A).
- Both Assertion (A) and Reason (R) are true, but (R) does not correctly explain (A).
- Assertion (A) is true, but Reason (R) is false.
- 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.