Question

Prepare two mark sheet I ms Excel

Answer 1

Answer:

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 rowsand 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.