Which of the following are examples of aggregate functions?
Correct Answers:
c) SUM()
d) COUNT()
Aggregate functions perform a calculation on a set of values and return a single summarized result.
SUM()
SUM(A1:A10) returns the sum of values in A1 to A10.COUNT()
COUNT(A1:A10) counts how many cells have values in A1 to A10.Incorrect Answers:
TRIM()
TRIM(" Hello World ") → "Hello World"CLEAN()
CLEAN(A1) removes unwanted characters but does not aggregate.NOW()
NOW() → Returns current date and time.TODAY()
TODAY() → Returns the current date.No Payment Cards Needed
Discover a range of courses designed to provide you with the knowledge and skills needed to excel in your chosen field.
You don’t need one month to study and pass your test.
With Prepsaret, it takes you a few days to grasp all the concepts needed to pass your exams