Question

What is M.S Exel?How to create marksheet in Exel?​

Answer 1

Answer:

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software

Let’s assume a user wants to create a spreadsheet for the calculation of some budget. He has some product and each product sales in each quarter for the year 2018. Now he wants to show this budget to his client.

Let’s see how we can do this with the help of the spreadsheet.

Step 1: Open MS Excel.

Step 2: Go to Menu and select New >> click on the Blank workbook to create a simple worksheet.

OR – Just press Ctrl + N: To create a new spreadsheet.

Step 3: Go to the spreadsheet work area. Which is sheet1

Step 4: Now create headers for Sales in each quarter in the first row by merging cells from B1 to E1, and in row 2, give the product name and each quarter’s name.

Step 5: Now, write down all product names in column A

Step 6: Now provide the sales data for each quarter in front of every product.

Now, in the next row, put one header for Grand Total and calculate each quarter total sales.

Answer 2

Answer:

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software.

Marksheet in Excel Format

#1 – SUM Function

#2 – Colon Method (Shift Method)

#3 – ROUND Function

#4 – IF Function

# 5 – COUNTIF