Question

Mention all the step to create worksheet to write name name ,roll number,class and mark of four subject . Write the formula to calculate the total mark and percentage of each student

Answer 1

Explanation:

a note onn web mining approaches for web data analysis.

Answer 2

Explanation:

To create a worksheet in Excel, follow these steps:  

Click on MS Excel icon on the desktop or go to Start button. Click on All programs. Click on Microsoft Office. Select Microsoft Excel.  

A new workbook will open on the screen.

Start creating the table with required fields by filling the cells.  

Under Column A, write roll number, Column B for name of the student, Column C for Class, Column D Subject 1, Column E Subject 2, Column F Subject 3, Column G Subject 4.  

In Column H write Total and moving next column write percentage.  

Enter the details in cell A2, B2, C2, D2, E2,F2, G2 and so on.  

Save the worksheet, Click Ctrl + S. A dialog box will appear. Select the location where you want to save file. Write the new name of file like Class 7A result sheet.  

To calculate total and percentage

• In cell H2, write the formula as = sum (D2:E2:F2:G2) . Press the enter key.  
• Drag the formula to copy it in other cells.  
• In Cell I2, write the formula of percentage $=\left(\frac{H 2}{\text {total marks}}\right) \times 100$.