Spreadsheet Exercises - Autosum
 

Exercise 2

 

Create a new worksheet and rename it Exercise2

1

Enter the 12 rows of data

2

Using the autosum command total the column. 
3

But the autosum should not work, as there is a line break.

4

Formula time: In D16 type this: =sum(D3:D15) and see the answer.

5

Round up the decimals to two places

Use this data source as your resource to type

Exercise1 Exercise2 Exercise3 Exercise4 Exercise5 Exercise6 Index