hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    ________ is not a basic function of MS Excel.
    Question

    ________ is not a basic function of MS Excel.

    A.

    count()

    B.

    sum()

    C.

    max()

    D.

    addition()

    Correct option is D

    The correct answer is (d) addition()
    Explanation:
    ● MS Excel uses specific built-in functions for calculations, but "addition()" is not one of them.
    ● To add numbers, Excel uses the sum() function or the arithmetic operator '+'.
    ● count(), sum(), and max() are standard, basic functions used for data analysis in spreadsheets.
    Information Booster:
    ● count() – Counts the number of cells that contain numbers.
    ● max() – Returns the largest value in a set of values.
    ● Formulas in Excel always start with an equals sign (=).
    Additional Knowledge:
    ● Average() – Calculates the mean of a range of cells.
    ● Min() – Returns the smallest value in a range of cells.

    Free Tests

    Free
    Must Attempt

    UPTET Paper 1: PYP Held on 23rd Jan 2022 (Shift 1)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    Free
    Must Attempt

    UPTET Paper 2 Social Science : PYP Held on 23rd Jan 2022 (Shift 2)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    Free
    Must Attempt

    UPTET Paper 2 Maths & Science : PYP Held on 23rd Jan 2022 (Shift 2)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    test-prime-package

    Access ‘KVS PGT’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow