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

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.

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

    What happens when a user enters a number with leading zeros (e.g., 00789) into a cell, in MS Excel 2019, by default?

    1. Excel retains the leading zeros and stores the number as entered.
    2. Excel automatically removes the leading zeros and stores the number as 789.
    3. Excel stores it as a text value instead of a number, preserving the leading zeros.
    4. 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.

Answer it in the practice appMake a topic-wise quiz