Question

How can you create a mark sheet in
ms excel

Answer 1

1. First open microsoft excel from start menu in all programes.
2. Click on new from file menu to create a new spreadsheet.
3. Fill the data/information in various rows and columns by selecting the rows and columns one by one.
4. If we need to find sum, average then enter various enteries in columns and rows.

• hope its helps

Answer 2

Answer:

Hope it will help

Explanation:

How to Make Marksheet in Excel Format?

Let us understand how to create marksheet in excel.

Suppose, we have following data for marks scored in various subjects by 120 students.

We want to find the total marks scored, an average of marks (this will also help us to give students grade) and result that whether the student is passed or failed.

#1 – SUM Function

To find out the total, we will use the SUM

The syntax for the SUM in excel is as follows:

Marksheet in Excel Example 1.1

This function takes 255 numbers in this way to add. But we can also give the range for more than 255 numbers too as an argument for the function, to sum up.