Computer Applications
Write all the steps to perform the following task in MS Excel:
Preparing a chart by using a sample data table
Answer
To prepare a chart by using a sample data table, follow these steps:
Step 1 — Select the range of cells whose data is to be represented.
Step 2 — Click the 'Insert' tab on the ribbon.
Step 3 — Click and select the type of chart (say, Column chart) from the 'Charts' group. A drop-down list opens.
Step 4 — Select the desired chart (say, a 2-D Column). The data will be displayed in the form of the chart selected.
Related Questions
Write all the steps to perform the following task in MS Excel:
Deleting a worksheet
Write all the steps to perform the following task in MS Excel:
Selecting partial range in a row
Write all the steps to perform the following task in MS Excel:
Selecting multiple columns in a worksheet
You have purchased some textbooks from a bookstore, as given below:
Write the steps involved to perform the following tasks in MS Excel on the table given above.
- Find the average price of the books.
- If the bookseller offers 10% discount, then calculate the amount to be paid to the shopkeeper.
- Find the price of the book which had the highest price among the books you bought.
- Calculate the total amount paid at the bookstore.