Excel SUM Function Quiz

What is the first step to use the SUM function for adding numbers in a column?

• Press the SUM button on the toolbar

• Select the entire column

• Type the numbers directly into the cell

• Click on the cell where you want the result

How do you select a range of cells in a row to sum them up?

• Use the arrow keys to select

• Click and drag across the cells

• Double-click on the first cell

• Type the range manually

What is the result of summing the values in row one, columns D through H?

• 151

• 219

• 235

• 45

When adding individual cells using the SUM function, what should you do after selecting the first cell?

• Double-click the cell

• Type a comma

• Press Enter

• Type a semicolon

What is the sum of the cells D5, H1, F3, E2, and E7?

• 235

• 45

• 219

• 151

How do you input actual values into the SUM function?

• Select the cells containing the values

• Use the toolbar to input values

• Drag and drop the values

• Type the values directly into the function

What is the result of adding the values 15, 21, and 9 using the SUM function?

• 151

• 219

• 235

• 45

Which method allows combining ranges, individual cells, and actual values in the SUM function?

• Using only ranges

• Using only individual cells

• Combining all methods

• Using only actual values

What is the result of combining cells A1 through A3, A6, A9 through A12, and the values 17 and 21?

• 151

• 583

• 219

• 235

What is the main advantage of the SUM function in Excel?

• It can only add numbers in a single column

• It is limited to adding actual values

• It can only add numbers in a single row

• It is versatile and can be used in many ways