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() ?
- A.
0.73
- B.
1
- C.
0.01
- 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.