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

CDP Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon20 Mins
languageIcon English
Free
Must Attempt

EVS Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon20 Mins
languageIcon English
Free
Must Attempt

CTET Paper-I PYP (07 July 2024)

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
340k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow