Excel Functions Quiz

What does the SUM function do in Excel?

• It computes the total average of a range of cell

• It produces the value of the range of cell

• it adds the selected range of cells

• It adds the cell 1 and Cell 2

Which function can you use to count the number of cells containing data in a given range?

• SUM

• Count If

• Average

• Count

Describe the steps to sort data in ascending order based on a specific column.

• Click on the sort function and choose sort A-Z

• Click on the sort function and choose sort Z - A

• Click on the sort function and choose 1 – 10

• Click on the sort function and choose Z - A

What is the best formula to be used when using the sum function for the given set of data

• =A2:B2

• =SUM (A2+B2)

• =SUM (A2:B2)

• =A2+B2

What is the output of the data below

• C

• D

• A

• E

How would you name a cell in column E and row 4?

• E:4

• E4

• 4E

• 4:E

Using the SUM function, what would be the formula to be used?

• =SUM(A1+A5)

• =SUM(A1:A5)

• =SUM(A1-A5)

• =SUM(A1*A5)

Using the MIN function, what would be the formula to be used?

• MIN=(A1:A5)

• =MIN(A1+A5)

• =MIN(A1:A5)

• =MIN(A1+A5)

Using the MAX function, what would be the formula to be used?

• = MAX (A1+A5)

• = MAX (A1+A5)

• ( MAX A1:A5)

• =MAX(A1:A5)

Using the AVERAGE function, what would be the formula to be used?

• =AVERAGE(A1:A5)

• =AVE(A1+A5)

• =AVE(A1:A5)

• =AVERAGE(A1/A5)