FORMULAS AND FUNCTIONS

Question 1

FORMULAS AND FUNCTIONS

Answer 1

SUM
AVERAGE
COUNT
MAX
MIN

Question 2

This function adds all the values of the cells in the argument

Answer 2

SUM

Question 3

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument

Answer 3

AVERAGE

Question 4

This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range

Answer 4

COUNT

Question 5

This function determines the highest cell value included in the argument

Answer 5

MAX

Question 6

This function determines the lowest cell value included in the argument

Answer 6

MIN

Question 7

is an expression which calculates the value of a cell

Answer 7

Formula

Question 8

are predefined formulas, and are already available in Excel

Answer 8

Functions

Question 9

to count cells based on one criteria

Answer 9

COUNTIF

Question 10

to count cells based on multiple criteria

Answer 10

COUNTIFS

Question 11

to sum a range of cells

Answer 11

SUM

Question 12

to sum cells based on one criteria

Answer 12

SUMIF

Question 13

to sum cells based on multiple criteria

Answer 13

SUMIFS

Question 14

checks whether a condition is met, and returns one value if TRUE and another value if FALSE

Answer 14

IF

Question 15

returns TRUE if all conditions are true and return FLASE if any of the conditions are false

Answer 15

AND

Question 16

returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false

Answer 16

OR

Question 17

to calculate the average of range of cells

Answer 17

AVERAGE

Question 18

to average cells based on one criteria

Answer 18

AVERAGEIF

Question 19

to find the median

Answer 19

MEDIAN

Question 20

to find the most frequently occuring number

Answer 20

MODE

Question 21

to calculate the standard deviation

Answer 21

STDEV

Question 22

to find the minimum value

Answer 22

MIN

Question 23

to find the maximum value

Answer 23

MAX

Question 24

to find the third largest number

Answer 24

LARGE

Question 25

to find the second smallest function

Answer 25

SMALL

Question 26

Parts of a function

Answer 26

Equal sign
Function name
Argument-

Question 27

can refer to both individual cells and cell ranges and must be enclosed within parentheses

Answer 27

Argument