SUM and AutoSUM Step by Step Tutorial

Adding the data to an Excel Spreadsheet

Use the data below with the tutorial: How to Use Excel's SUM and Auto SUM.

To enter the data accurately,

1. Open a blank Excel spreadsheet file
2. Select the cell indicated by the cell reference provided
3. Type the corresponding data into the selected cell.

The formatting for this spreadsheet will not match the example used in the step by step tutorial instructions. If you want to add formatting, go to the tutorial Step by Step Excel Formatting for instructions on how to add basic formatting features to a spreadsheet.

Cell - Data

B1 - The Cookie Shop
B2 - 1st Quarter Statement
B3 - for 2006
A5 - 1st Quarter Sales:

A9 - Peanut Butter
A10 - Chocolate Chip
A11 - Oatmeal Raisin
A12 - Lemon

B7 - January
C7 - February
D7 - March
A8 - Sales Revenue:

B9 - 1292
B10 - 2047br] B11 - 1795
B12 - 1250br]

C9 - 1156
C10 - 1987
C11 - 2010
C12 - 1345

D9 - 1250
D10 - 1156
D11 - 1892
D12 - 1292
A13 - Total Revenues:

• Functions Tutorial - Overview
• Using the SUM Function
• Using the Auto SUM Command
• Selecting the range for Auto SUM
• Data SUM Auto SUM Tutorial