How to create a marksheet in ms excel
Answers
To create marksheet in ms excel we have:-
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.
6)To find sum enter syntax [=sum] and select he cells of which we need to find sum.
7)Similarly for average we use syntax[=average] and the starting cell separated by colon and ending cell .This will find the average of cells.
8)After creating the worksheet we need to save it by clicking on file tab and save option in it .
9)Type the name we want to give to sheet and click on save button.
10)In this way we create a marksheet in excel.
Answer:
To create marksheet in ms excel we have:-
Explanation:
1)First open microsoft excel from begin menu in all programes.
2)Click on new from report menu to create a brand new spreadsheet.
3)Fill the data/statistics in diverse rows and columns via way of means of choosing the rows and columns one via way of means of one.
4)If we want to discover sum, common then input diverse enteries in columns and rows.
6)To discover sum input syntax [=sum] and pick out he cells of which we want to discover sum.
7)Similarly for common we use syntax[=average] and the beginning mobileular separated via way of means of colon and finishing mobileular .This will discover the common of cells.
8)After growing the worksheet we want to store it via way of means of clicking on report tab and store choice in it .
9)Type the call we need to offer to sheet and click on on store button.
10)In this manner we create a marksheet in excel.
#spj2