Data Analysis Part 2

If function allows to choose between two actions based on whether the condition is true or ..................

• false

• 1

• Yes

• -1

Fill the missing

=IF(....................., value_if_true,value_if_false)

• lookup_value

• criteria

• condition

• logical_test

An example of a range address

• A1;B3

• A1:B3

• A1-B3

• A1.B3

Put "yes" if paid atleast $20 and "no" if paid less than $20 . What to put in cell C2?

• =CONDITIONAL(B2>=20, "No","Yes")

• =IF(B2>=20, "Yes","No")

• =IF(B2=20, "Yes","No")

• =CONDITIONAL(B2>20, "No", "Yes")

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

Counts the number of cells that contain numbers

• Sum

• Counta

• Count

• Argument

Count the number of cells based on one criteria

• Sumif

• Productif

• Averageif

• Countif

A function used to add a range of cell if a certain condition is met.

• Addif

• Conntif

• Subtractif

• Sumif

Function that is used to make a decision based on a comparison.

• Sum

• Max

• Min

• If