Question

Create an excel sheet to enter 5 subject marks of 10 students and perform the following:
1. Calculate sum, max,min and average marks for each student. (Use Auto Fill to apply formula)
2. Insert a chart (Name and 5 subject marks of all students) with appropriate chart title.

Answer 1

Answer:

STEP : 1. First go to file menu and choose new sub menu and select work sheet option and click ok. STEP : 2. Enter the fields Reg No, students name, subject-Tamil, English, Maths, Science, Social, Total, Average, Result and grade.

Answer 2

Answer:

The Sum ,avg, Max, min function is generated and graph is calculated

Explanation:

1) SUM Function

To find out the total, we will use the SUM function

The syntax for the SUM in excel is as follows:

sum(range1,range,....)

sum(range1:range2,....)

2) Average

• For calculating average marks, we will use the AVERAGE function. The syntax for the AVERAGE function is the same as the SUM function.
• This function returns the average of its arguments.
• We can pass arguments to this function the same way we pass arguments to the SUM function.
• For evaluating the average in the excel mark sheet, we will use the AVERAGE function in the following way. First, we will select marks scored by a student in all five subjects.

Max and Min

• The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as:
• =MAX(B2:B6)
• =MIN(B2:B6)

Chart

• Select the chart.
• Click on Design –> Change Chart Type option from Type group.
• Change chart type dialog box appears.
• Select the desired chart from the list of charts.