Student Marks Table(Find Total,Avg,Grade) In Ms-Excel – Computers adda

Latest News :

Student Marks Table(Find Total,Avg,Grade) In Ms-Excel

In this video we can discuss about How to find the Students Total, Average, Grade of Student Marks.

Ex Problem:-

Student Table:-

Take Student No, Name, Sub1, Sub2, Sub3 Marks the find Total marks, Average marks?

S.no = 1214

Name = PRASAD

Math’s = 95

Telugu = 64

English = 85

Hindi = 66

Total = ? (Math’s + Telugu + English + Hindi)

AVG = ? (Total / No. of Subjects)

Grade =?

durgaprasad

Related Posts

Pivot Table in Ms-Excel

How to Use Spread Sheets in Ms-Excel

User interface of Ms -Excel

Using Cell’s Basics(Fill handle) in Ms-Excel

Group,Ungroup & Subtotal in Ms-Excel

Travelling Agency Table in Ms-Excel

Fill & Clear Options in Ms-Excel

Freeze panes & Split in Ms-Excel

Alignments,Borders & Rotate options in Ms-Excel

Flash Fill & Remove Duplicates

Using IF formula Problems in Excel

Statistical Functions in Ms-Excel

Fill & Clear Options in Ms-Excel

Working on Employee Table in Ms-Excel

leave a comment

Cancel reply