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
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
Social Sciences,
3 months ago
English,
3 months ago
Science,
7 months ago
English,
1 year ago
English,
1 year ago