Card 3 / 13: How could you best derive a total sum for all the values in a Microsoft Excel spreadsheet column?
A)
It is not possible to perform this operation in a spreadsheet unless it has been formatted.
B)
You could select the range, then cut and paste it into the calculation window.
C)
You could select the empty cell below the last value in the column and then enter the following formula in the formula toolbar: =SUM(A1:A5), with A1:A5 being an example of the range of all the cells with values in the column.
D)
You could use a calculator and enter the total of the column manually.
Answer:
C) You could select the empty cell below the last value in the column and then enter the following formula in the formula toolbar: =SUM(A1:A5), with A1:A5 being an example of the range of all the cells with values in the column.
Previous Card | ← Previous Card Button |
Next Card | → Next Card Button |
Flip Card | Space-Bar |
|