Excel tutorial 5 Review

What would be a correct formula for SUM in excel?

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

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

What function was used to find the lowest data ?

• AVERAGE

• MIN

• MAX

• SUM

The function COUNT is specific for _________________

• Counting cells

• Counting text

• Counting number

• Counting tables

Every formula starts with

• =

• +

• $

• !

Choose the answer that shows a RELATIVE cell reference

• =C4

• =($C$1*.5)+$D$1

• =$C$4

• =4^3

 

Choose the answer that shows a formula with an ABSOLUTE cell reference

• =B1*C4

• =B1*$C$4

• =A3

• =4^3

 

Choose the best description of the IF function

• Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

• Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false

• Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false

• Returns a value from a list using a given position

 

Choose the correct format of the IF function:

• =IF(logical test,value if true,value if false)

• =IF(value if true,value if false,logical test)

• =IF(logical test,value if false,value if true)

• =IF(value if false,value if true,logical test)

What is the formula to calculate the average of a range of cells in Excel?

• =MODE(range)

• =MEDIAN(range)

• =AVERAGE(range)

• =SUM(range)/COUNT(range)