Question

SUBJECT: COMPUTER
1. Make a sheet in Excel for the following bookshop details:
1. Book_id
2. B_name
3. B_price
4. Author name
5. No. of copy sold.
a) Give text color "red" and borders of cell should be in "blue" color.
b) Find the total amount to be paid for each book after the discount of
10%.
​

Answer 1

Answer:

Easy

Explanation:

After creating the database in Excel just type this formula in the Total amount place

Formula: =10/100*B_price*No. of copies sold