Question

from a book store as given below. Perform
the following tasks in MS Excel from the given table and write all the steps.
А
B
c с
1
2 Name of the book
Publisher
Price
3 Concise Physics
Selina Publishers
220
4 Concise Chemistry
Selina Publishers
240
5 Concise Biology
Selina Publishers
260
6 Understanding Mathematics
410
7 Understanding Computer App.
400
Avichal Publishing Co.
Arya Publishing Co.
Avichal Publishing Co.
Oxford University
8 Indian History
280
9 English Grammar
260
10
14 <
Science Marks
Sheet2
Sheet3
>
Ready
100%
1. Find the average price of the books.
2. If the bookseller offers 10% discount, then calculate the amount to be paid to the
shopkeeper.
3. Determine the highest price of the book purchased by you.
4. Calculate the total amount paid to the book store.
Spreadsheet: Functions and Charts 39​

Answer 1

Answer:

woo la xm la woo la all ka woo