Step One: Enter Your Data
The first step is to enter your data into Excel. You can do this by opening up a new Excel workbook and typing your data into the cells. For this example, we'll be using a list of student names and their corresponding test scores.
Entering Student Names:To enter the student names, simply click on the first cell in the column and type in the name. Then, press Enter. Repeat this process for each student name.
Entering Test Scores:To enter the test scores, click on the first cell in the column and type in the score. Then, press Enter. Repeat this process for each student's score.
Step Two: Select the Data
Now that you have your data entered, you'll need to select it. To do this, click on the first cell in the data set and then drag your mouse down until all the cells are highlighted. Once your data is selected, you should see a black border around it.
Step Three: Click the AutoSum Button
Now that your data is selected, you're ready to total the column. To do this, click the AutoSum button, which is located in the ribbon at the top of the screen. When you click this button, Excel will automatically select the cells adjacent to your selection, and it will display the sum in the cell below your selection.
Step Four: View the Result
To view the result, simply click on the cell that contains the sum. You should now see the sum of the column, which in this case is the total test score for all students.