Steps for Excel Assignment
Step 0: Create Table and Columns
1. Open Microsoft Excel.
2. Click on a blank worksheet.
3. Type the column headers in the first row (for example: Student Name, Math, Science,
English, Total Marks, Average, Percentage).
4. Enter the data for each student under the respective columns.
(This forms your data table to work with formulas.)
1. SUM Function
Aim: To find the total of given numbers.
Steps:
1. Place the cursor in the cell where you want the total.
Type the formula:
=SUM(B2:D2)
2. (This adds values from B2 to D2.)
3. Press Enter.
4. Drag the formula down to calculate totals for other students.
2. COUNT Function
Aim: To count the number of numeric entries in a range.
Steps:
1. Select a blank cell for the result.
Type the formula:
=COUNT(A2:A5)
2. (This counts the number of numeric entries in the range A2 to A5.)
3. Press Enter.
3. AVERAGE Function
Aim: To calculate the average of given numbers.
Steps:
1. Click on the cell where you want the average.
Type the formula:
=AVERAGE(B2:D2)
2.
3. Press Enter.
4. Drag the formula down to calculate the average for other students.
4. PERCENTAGE Calculation
Aim: To calculate the percentage of obtained marks.
Steps:
In a blank column, type the formula:
=E2/300*100
1. (E2 = Total Marks, 300 = Maximum Marks for 3 subjects)
2. Press Enter.
3. Drag the formula down for other students.
5. Chart (Percentage Chart)
Aim: To create a chart showing students’ percentages.
Steps:
1. Select the Student Name column and Percentage column.
2. Go to Insert → Charts.
3. Choose a Column Chart / Bar Chart / Pie Chart.
4. A chart will appear in the worksheet.
5. Change the chart title to “Percentage Chart”.
6. Adjust formatting if needed.