Exel 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 which contains a number value

Question 2

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

Answer 2

=COUNTA(RANGE)

counts the number of certain values within cells

Question 3

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

Answer 3

=SUM(RANGE)

adds up the values within a cells 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 the group of cells specified

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

can be used in combination with other formulas to give more specific results

you can state if you want the the formula to activate when the condition is met or when it isn’t

Question 6

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

Answer 6

**=CONCATENATE(Value1, 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(Value1, Value2)

return the largest or smallest number with a cell’s dataset, respectfully

Question 8

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

Answer 8

=AND(logical1), (logical2)

determine if something I’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 **CONCATENATE* & what does it do ?

Answer 10

=REPLACE(old_text, start_num, num_chars, new_text)

ideal for making changes in a spreadsheet

allows you to replace certain values with a desired alternative quickly