Formulas in Excel

Question 1

It returns a value that you set if a condition is met, and a value if it is not met

Answer 1

IF

Question 2

Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.

Answer 2

VLOOKUP

Question 3

It returns a value that you set if a formula has an error

Answer 3

IFERROR

Question 4

Rounds a number to the nearest decimal based on your specified number of digits

Answer 4

ROUND

Question 5

Get the nth largest value from a range of values

Answer 5

LARGE

Question 6

Get the nth smallest value from a range of values

Answer 6

SMALL

Question 7

Gives you the average of a group of values

Answer 7

AVERAGE

Question 8

Get the largest value from a range of values

Answer 8

MAX

Question 9

Get the smallest value from a range of values

Answer 9

MIN

Question 10

Gets the middle number in the set of numbers

Answer 10

MEDIAN

Question 11

Counts the number of cells that contain numbers

Answer 11

COUNT

Question 12

Counts the number of cells that are non-blank (Including empty text “”)

Answer 12

COUNTA

Question 13

Counts the number of cells that matches your specified condition

Answer 13

COUNTIF

Question 14

Counts the number of cells that matches your specified conditions

Answer 14

COUNTIFS

Question 15

Sums the values in a range that meet a criteria that you specify

Answer 15

SUMIF

Question 16

Sums multiple criteria

Answer 16

SUMIFS