Excel AND Function

Question 1

is a premade function in Excel

which returns ?? based on two or more conditions.

Answer 1

AND function
TRUE or FALSE

Question 2

The most common type of mean

Answer 2

arithmetic mean.

Question 3

is a premade function in Excel, which calculates the average of a range based on a true or false condition.

Answer 3

AVERAGEIF function

Question 4

is a function in Excel and is short for concatenate.

Answer 4

CONCAT

Question 5

is used to link multiple cells without adding any delimiters between the combined cell values.

Answer 5

CONCAT function

Question 6

is a new version of the old CONCATENATE function.

Answer 6

CONCAT

Question 7

The different parts of the function are separated by a symbol, like

Answer 7

comma , or semicolon ;

Question 8

which counts cells with numbers in a range.

Answer 8

COUNT

Question 9

which counts all cells in a range that has values, both numbers and letters.

Answer 9

COUNTA

Question 10

which counts blank cells in a range.

Answer 10

COUNTBLANK

Question 11

is helpful to find empty cells in a range.

Answer 11

COUNTBLANK function

Question 12

This covers the basic use for how to count specific numbers and words.

Answer 12

COUNTIF

Question 13

which counts cells as specified.

Answer 13

COUNTIF

Question 14

which counts cells in a range based on one or more true or false condition.

Answer 14

COUNTIFS

Question 15

which returns values based on a true or false condition.

Answer 15

IF

Question 16

which finds the highest number in a range.

Answer 16

MAX Function

Question 16

is used to retrieve a chosen amount of characters, counting from the left side of an Excel cell. The chosen number has to be greater than 0 and is set to 1 by default.

Answer 16

LEFT function

Question 17

is used to lowercase text in a cell.

Answer 17

LOWER function

Question 18

which finds the lowest value in a range,

Answer 18

MIN Function

Question 19

NPV means

Answer 19

Net Present Value

Question 19

which returns the middle value in the data.

Answer 19

MEDIAN Function

Question 19

which is used to find the number seen most times.

Answer 19

MODE Function

Question 20

is used to calculate the Net Present Value (NPV)

Answer 20

NPV function

Question 21

is often used together with the IF function.

Answer 21

OR function

Question 22

is used to generate random numbers.

Answer 22

RAND Function

Question 23

is used to retrieve a chosen amount of characters, counting from the right side of an Excel cell.

Answer 23

RIGHT Function

Question 24

which calculates the Standard Deviation (Std) for the entire population.

Answer 24

STDEV.P Function

Question 25

which calculates the Standard Deviation (Std) for a sample.

Answer 25

STDEV.S Function

Question 26

which adds numbers in a range.

Answer 26

SUM Function

Question 27

used to remove irregular text spacing and keep single spaces between words.

Answer 27

TRIM Function

Question 28

which allows searches across columns.

Answer 28

VLOOKUP Function