Excel Formulas

Which function would you use to find the largest number in a range?

• MIN

• MAX

• SUM

• COUNT

What does the function COUNT do?

• Counts the number of empty cells

• Totals a range of cells

• Counts the number of cells that contain numbers

• Finds the average of a range

How would you write an IF function to check if a cell value is greater than 10?

• =IF(A1

• =IF(A1=10,A1*2,A1*3)

• =IF(A1>10,A1*3,A1*2)

• =IF(A110,A1*3,A1*2)

Which symbol is used to denote Absolute Addressing?

• #

• $

• &

• @

What does the function AVERAGE do?

• Adds a list of numbers and divides by the count

• Finds the highest number in a range

• Totals a range of cells

• Counts the number of non-empty cells

How would you sum the range B3:B12 in Excel?

• =SUM(B3:B12)

• =COUNT(B3:B12)

• =AVERAGE(B3:B12)

• =MAX(B3:B12)

What would the formula be if =C2+$E$5 was copied down one cell?

• =C2+$E$5

• =C3+$E$5

• =C2+$E5

• =C3+$E5

Which function would you use to count the number of non-empty cells?

• COUNT

• COUNTA

• COUNTBLANK

• MAX

How would you write a formula to round a number to 0 decimal places?

• =ROUND(A1,2)

• =ROUND(A1,0)

• =ROUND(A1,1)

• =ROUND(A1,-1)

What is Relative Addressing?

• Keeping a cell reference the same when copying

• Changing cell references automatically when copying

• Counting the number of cells in a range

• Summing a range of cells