Modelling and Presenting Numeric Data

What is the result?

What is the result?

What is the result?

What is the result?

What is the result?

What is the result?

Which statement best describes the SUMIF function in Excel?

• Totals numbers together

• To sum values that meet a specific criteria

• To look for values that meet a specific criteria

• Adds numbers then finds the average

What would be the formula if you wanted to sum all numbers in a range below 500?

• =SUMIF(A1:A10,''<500'')

• =SUMIF(A1:A10,''>500'')

• =SUMIF(A1:A10,<500)

• =SUM(A1:A10,''<=500'')

If you wanted to look in a range and find the text 'peaches', then look in the range adjacent and total only the values where there is a match to peaches, what would be the formula?

• =SUMIF(A1:A10,peaches,B1:B10)

• =SUM(A1:A10,'peaches',B1:B10)

• =SUMIF(A1:A10 & peaches & B1:B10)

• =SUMIF(A1:A10,''peaches'',B1:B10)

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)