EX_Class(Sum,SumIF,Max,Min,Average)

To find the total marks for Ahmed we need to apply

• SUM()

• SUMIF()

• MAX()

• AVERAGE()

To find the HIGHEST mark Ahmed scored we need to apply

• SUM()

• SUMIF()

• MAX()

• AVERAGE()

To find who scored the lowest mark in Arabic we need to apply

• SUM()

• SUMIF()

• MIN()

• AVERAGE()

which is same as = A2+A5+A1 (ALL apply)

• =25+21+10

• =SUM(A1:A5)

• =SUM(A1,A2,A5)

• NOTMENTIONED

Find the total for numbers bigger than 15

• =SUMIF(A1:A6,"<15")

• =SUMIF(A1:A6,"<=15")

• =SUMIF(A1:A6,">15")

• =sum(A1:A6,15)

Find the total for numbers bigger than 15

• =SUMIF(A1:A6,"<15")

• =SUMIF(A1:A6,"<=15")

• =SUMIF(A1:A6,">15")

• =sum(A1:A6,15)

• =SUMIF(A1:A6,>15)

Which describe this formula best

=Sumif(E2:E7,">80")

• Find the total marks

• find the total marks in case of less than 80

• find the total marks of Alex in case he scored over than 80

• find the total marks of Alex

What is the result of

=Min(A1:A7)

• 0

• error

• Art

Max(),Min() and average() are belon to -----------

• Financial

• Statistical

• Math & Trig

• Logical

SumIF() Criteria can be applied to ----------

• Numbers

• Dates and times

• Text

• All that mentioned