Consider the following spreadsheet and answer the question that follow :
A | B | C | D | E | |
1 | No. | BookName | Price | No of copies | Total Price |
2 | 1 | Mastering Dbase | 200 | 4 | |
3 | 2 | Introduction to dbase | 150 | 8 | |
4 | 3 | HTML programming | 250 | 9 | |
5 | 4 | Web Based Applications | 199 | 6 |
a. Calculate the Total Price as Price * No_ of _ copies in cell E2.
b. Which option can be used to arrange the book in ascending order of price (lowest to highest)?
c. Find the highest price of a book and display in in cell C6.
d. Which option can be sued to change the background color of a cell?
e. Mention the feature used to display the data in a graphical form.
f. Change the alignment of text in cell B2 to central aligned.