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

Latest News :

Split Data Single Sheet to Multiple Sheets in Excel ( 3 Ways )

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

Filter Option in Ms-Excel

Working on Employee Table in Ms-Excel

Power bill Table in Ms-Excel

Wrap Text & Merge and Center in Ms-Excel

User interface of Ms -Excel

Text Functions in Ms-Excel

View,Zoom & Show options in Ms-Excel

Data Table Option in Ms-Excel

Arithmetic Functions in Ms-Excel

Date & Time Functions in Ms-Excel

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

Flash Fill & Remove Duplicates

Filter Option in Ms-Excel

Working on Employee Table in Ms-Excel

Power bill Table in Ms-Excel

Wrap Text & Merge and Center in Ms-Excel

User interface of Ms -Excel

Text Functions in Ms-Excel

Fill & Clear Options in Ms-Excel

Working on Employee Table in Ms-Excel

leave a comment

Cancel reply