Which of the following output is not expected from MS-excel function = RAND() ?

2022

Which of the following output is not expected from MS-excel function = RAND() ?

  1. A.

    0.73

  2. B.

    1

  3. C.

    0.01

  4. D.

    0.99

Attempted by 553 students.

Show answer & explanation

Correct answer: B

The RAND() function in MS-Excel generates a random decimal number between 0 and 1, where 0 is included but 1 is excluded. This means the output is always in the range [0, 1). Therefore, any value greater than or equal to 0 and less than 1 is a possible output. For example, 0.73, 0.01, and 0.99 are all valid outputs. However, the value 1 is not included in the range, so it cannot be generated by the RAND() function.

Explore the full course: Rssb Basic Computer Instructor