New Register here for RBI, SEBI & NABARD strategy workshop! April 9 at 7 PM

    Question

    Which of the following functions in MS Excel 365

    generates a real number greater than 0 and is used for statistical analysis, cryptography, gaming, and probability theory?
    A VLOOKUP Correct Answer Incorrect Answer
    B RAND Correct Answer Incorrect Answer
    C SUM Correct Answer Incorrect Answer
    D AVERAGE Correct Answer Incorrect Answer

    Solution

    The RAND function in Excel generates a random real number between 0 and 1. It is widely used for simulations, cryptography, and probability-related calculations. Knowledge Booster: 1. Use *=RAND()100 to generate numbers between 0 and 100. 2. For integers, combine with INT or ROUND functions. 3. SUM and AVERAGE are for aggregating values. 4. VLOOKUP is used for searching and retrieving data.

    Practice Next

    Relevant for Exams: