APPSC ASO 2025 Paper 2 · Question 149
Question 149 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.
What happens when a user enters a number with leading zeros (e.g., 00789) into a cell, in MS Excel 2019, by default?
- Excel retains the leading zeros and stores the number as entered.
- Excel automatically removes the leading zeros and stores the number as 789.
- Excel stores it as a text value instead of a number, preserving the leading zeros.
- Excel converts it into a scientific notation format, such as 7.89E+02.
Show answer
Answer: (2) Excel automatically removes the leading zeros and stores the number as 789.
Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.