Question

Create a worksheet in MS-Excel in which you would maintain your Monthly Expenses on Stationery.
Please note the following guidelines and ensure the same:-
a. Take any 5 items only.
b. It should have the following headings: Serial no, Commodity, Price, Quantity, Discount per
item, Total after discount, Total amount paid.
c. Give a discount of 10% on each commodity using Absolute reference.
d. Discount per item = Price * 10%(using absolute referencing)
e. Total after discount = Price – Discount per item
f. Total amount paid = Quantity * Total after discount

Answer 1

Answer:

Also called a spreadsheet, the workbook is a unique file created by Excel XP.

Title bar. The title bar displays both the name of the application and the name of the spreadsheet.

Menu bar. ...

Column headings. ...

Row headings. ...

Name box. ...

Formula bar. ...

Cell. ...