Excel Functions

Question 1

What is the equation for
COUNT & what does it do ?

Answer 1

=COUNT(RANGE)

counts the amount of cells within a given range

Question 2

What is the equation for
COUNTA & what does it do ?

Answer 2

=COUNTA(RANGE)

counts the number of certain values within a range of cells

Question 3

What is the equation for SUM & what does it do ?

Answer 3

=SUM(RANGE)

adds up the values within a cell or range of cells

Question 4

What is the equation for
AVERAGE & what does it do ?

Answer 4

=AVERAGE(RANGE)

provides the average value for a specified group of cells

Question 5

What is the equation for IF statement & what does it do ?

Answer 5

the formula is only ran when the data meets a certain condition

Question 6

What is the equation for
CONCATENATE & what does it do?

Answer 6

=CONCATENATE(Value, Separator, Value2)

to combine the value of two or more cells

Question 7

What is the equation for
MAX & MIN & what does it do?

Answer 7

=MAX(Value1, Value2)
=MIN(Value, Value2)

return the largest or smallest number within a cell’s dataset, respectively

Question 8

What is the equation for
AND & what does it do ?

Answer 8

AND(logical1), (logical2)

determine if something l’d true or false

Question 9

What is the equation for
XLOOKUp & what does it do ?

Answer 9

finding info within a Excel
Spread Sheet

Question 10

What is the equation for
REPLACE & what does it do ?

Answer 10

=REPLACE(old_text, start_num, num_chars, new_text)

allows you to replace certain values with a desired alternative quickly