Using the SUM Function in Excel

What is the primary purpose of the SUM function in Excel?

• To subtract numbers

• To multiply numbers

• To quickly add up numbers

• To divide numbers

In what orientations can the SUM function be used to subtotal numbers?

• Only vertically in a column

• Only horizontally in a row

• Vertically in a column or horizontally in a row

• Diagonally across cells

What is the total sum of the values 10.5, 7.2, 200, 5.4, and 8.1?

• 221.2

• 231.2

• 211.2

• 241.2

What is the most efficient way to use the SUM function to add a range of cells from A2 to A6?

• =A2+A3+A4+A5+A6

• =SUM(A2,A3,A4,A5,A6)

• =SUM(A2:A6)

• =ADD(A2:A6)

To sum numbers horizontally in a row from cell A2 to E2, what is the correct syntax for the SUM function?

• =SUM(A2+E2)

• =SUM(A2;E2)

• =SUM(A2-E2)

• =SUM(A2:E2)