MS Excel Functions Quiz

What function adds all the numbers in a range of cells?

• SUM

• DIFFERENCE

• PRODUCT

• QUOTIENT

How can you calculate the difference between two numbers in Excel?

• Using the DIFFERENCE function

• Using subtraction (-)

• Using addition (+)

• Using the AVERAGE function

What function multiplies all the numbers in a range of cells?

• SUM

• PRODUCT

• AVERAGE

• COUNT

What function returns only the integer portion of a division?

• QUOTIENT

• ROUND

• AVERAGE

• MAX

What function calculates the average of a range of numbers?

• SUM

• AVERAGE

• MAX

• MIN

What function returns the largest number in a range of cells?

• MAX

• MIN

• COUNT

• NOW

What function returns the smallest number in a range of cells?

• MAX

• MIN

• AVERAGE

• SUM

What function performs a logical test and returns one value for TRUE and another for FALSE?

• IF

• SUM

• AVERAGE

• COUNT

What function counts the number of numeric values in a range of cells?

• COUNT

• SUM

• AVERAGE

• MAX

What function returns the current date and time?

• NOW

• TODAY

• AVERAGE

• SUM