excel functions part 1

which of the following computer task can be best done with MS EXCEL?

• edit photos

• edit videos

• write letters

• mathematical computation

which formula is used to get the average of certain numbers in excel?

• =AVERAGE(1,2,3)

• =AVE(CELL RANGE)

• =AVERAGE(CELL RANGE)

• AVERAGE(CELL RANGE)

What does this formula mean?

=SUM(B1:B12)

• Get the sum of the cells B1 and B12

• Get the sum of the cells from B1 to B12

• Get the sum of the cells in B1 plus B12

• Get the sum of all the cells except B1 and B12

Which is the correct formula to get the total sum of numbers listed in B2 and B7?

• =SUM(B2,B7)

• =SUM(B2:B7)

• =SUM(B2,B7

• =SUM/B2,B7/

Which is the symbol for "divide" in excel?

• (

• %

• /

• :

Which is the symbol of "times" (multiplication) in excel?

• $

• *

• @

• x

To get the proper value for this math equation, what must you type?

5x5=

• =5x5

• =5/5

• 5x5=

• =5*5

It  automatically gives the sum of certain elements in the list

• count if

• average

• sum

• sum if

Allows user to get the average of a certain cell range automatically

• sum if

• count if

• counta

• average

count the number of cells that are not empty

• count if

• sumif

• counta

• countblank