Computer Science, asked by kishnoorchhatwal, 7 months ago

Lab Work
1. Create a worksheet that a Book Store accountant would maintain for his/her list of books. It
must have the following headings
Book No, Book Title, Category/Subject, Price, Copies, Total and Discount.
2. Fall data on all the fields except Discount and Total.
3. Write the correct formula to calculate the Total as Price Copies. Calculate the Discount as
10% of Total. Copy the formula to all the cells.
4. At the bottom of the worksheet, write the consolidated data as
Total Purchase
.... (find the sum of the column Total)
Total Discount
(find the sum of the column Discount)
The Highest Total
The Lowest Total
Please tell

Answers

Answered by shunmugauthaya
0

Answer:

must have the following headings

Book No, Book Title, Category/Subject, Price, Copies, Total and Discount.

2. Fall data on all the fields except Discount and Total.

3. Write the correct formula to calculate the Total as Price Copies. Calculate the Discount as

10% of Total. Copy the formula to all the cells.

4. At the bottom of the worksheet, write the consolidated data as

Total Purchase

.... (find the sum of the column Total)

Total Discount

(find the sum of the column Discount)

The Highest Total

The Lowest Total

Please tell

Explanation:

find the sum of the column Total)

Total Discount

(find the sum of the column Discount)

The Highest Total

The Lowest Total

Please tell

Similar questions