Basic Excel Functions

Question 1

Adds values of the selected cells.

Answer 1

=SUM

Question 2

Eliminates the need to create a formula to create the average manually

Answer 2

=AVERAGE

Question 3

•Helps us quickly know about the number/count of numeric values (numbers) entries.

•Usually ignores data sets other than numbers

Answer 3

=COUNT

Question 4

Helps us give the maximum in a given set of data, cells, or ranges.

Answer 4

=MAX

Question 5

Helps us get the minimum value in a specific range.

Answer 5

=MIN

Question 6

•Lets us pick or record any random number from the given set of numbers.

•Categorized under the Math and Trigonometry functions

Answer 6

=RANDBETWEEN

Question 7

Returns the current date

Answer 7

=TODAY

Question 8

Returns both the current time and date

Answer 8

=NOW

Question 9

Syntax:
SUM

Answer 9

=SUM (number1[number2],….)

Question 10

Syntax:
COUNT

Answer 10

=COUNT (number1, [number2],…)

Question 11

Syntax:
MAX

Answer 11

=MAX (number1, [number2],…)

Question 12

Syntax:
MIN

Answer 12

=MIN (number1, [number2],…)

Question 13

Syntax:
RANDBETWEEN

Answer 13

=RANDBETWEEN (bottom, top)

Question 14

Syntax:
TODAY

Answer 14

=TODAY()

Question 15

Syntax:
NOW

Answer 15

=NOW()

Question 16

Basic Excel Functions:
8 Functions

Answer 16

=SUM
=AVERAGE
=COUNT
=MAX
=MIN
=RANDBETWEEN
=TODAY
=NOW