excel formulas

how to add all numbers in the photo?

• =sum(1:6)

• =sum(A1:A6)

• =sum(2:7)

• =sum(A2:A7)

which formula can do the same function as =average(A2:A7)

• =(A1+A2+A3+A4+A5+A6)/2

• =(A1+A2+A3+A4+A5+A6)/6

• =(A2+A3+A4+A5+A6+A7)/6

• =(A2+A3+A4+A5+A6+A7)/2

WHICH FORMULA CAN FIND OUT HOW MANY NUMBERS WE HAVE IN THIS TABLE?

• =COUNT(A1:A10)

• =COUNTIF(A1:A10)

• =COUNT(B2:B7)

• =AVERAGE(A1;A8)

HOW MANY COLUMNS ARE IN TABLE IN PHOTO?

• 6

• 7

• 1

• 2

HOW TO COUNT HOW MANY 78 IN THIS TABLE?

• =COUNTIF(2:6,78)

• =COUNTIF(2:7,78)

• =COUNTIF(A2:A6,78)

• =COUNTIF(A2:A7,78)

WHICH FORMULA FINDS GREATEST NUMBER IN TABLE?

• =MAX(A1:A8)

• =MAXIMUM(A2:A7)

• =MIN(1:8)

• =MIN(A2:A7)

HOW MANY ROWS IN TABLE?

• 1

• 7

• 6

• 2

HOW MANY CELLS IN TABLE

• 1

• 6

• 7

• 2

HOW TO ADD FIRST THREE NUMBERS?

• SUM(A1:A3)

• =A2+A3+A4

• =SUM(A1:A3)

• =AVERAGE(3)