ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!

    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
    More Computer Language Questions

    Relevant for Exams:

    ask-question