More on Microsoft Excel

Chapter  Two

More on Excel

Answer the Questions

Q1. What are the two different ways in which you can sort data in excel?

Ans: The following are the two ways to sort data in excel

1.       Using Sort and Filter button present in the Editing group

2.       Using Sort Dialog box.

Q2. Write the steps to sort the data in descending order.

 Ans:  Step1: Select the desired range of cells

           Step 2: Click the sort and filter button.

           Step 3: Click Sort Z to A option from the list displayed.

Q3. What do you mean by custom filtering?

Ans: Custom filtering allows you to specify your own criteria for filtering the data in a worksheet.

Q4. Write the steps to filter the data in Excel.

 Ans:    Step 1: Click any cell within the range of data to be filtered in the worksheet.

            Step 2: Click the sort and filter button.

            Step 3: Click Filter option from the list displayed

            Step 4: Click the drop-down control of any column to filter the data of that particular column.

            Step 5: Click the Select All check box in the list. All the options will be deselected.

Step 6: Click the check box for the option 28000 or any amount.

Step 7: Click Ok

Q5. What are the different ways in which you can apply conditional formatting?

 Ans: The different ways in which we can apply conditional formatting are as follows:

1.       Highlight Cells Rules.

2.       Top/Bottom Rules.

3.       Data Bars.

4.       Color Scales

5.       Icon Sets.

Q6. Write the steps needed to perform conditional formatting using any one of the options.

 Ans:   Step 1: Select the desired range of cells.

Step 2: Click the conditional formatting button present in the styles group on the home tab, point to Highlight Cells Rules option and the click Greater Than option.

            Step 3: Enter the values for which the criterion is to be displayed.

            Step 4: Click the arrow next to the with drop-down list box and select the desired format.

            Step 5: Click OK.

Q7. What is a chart? List various components of a chart.

Ans: A chart is a graphical representation of data used to compare a series of data over different time spans. Components of a chart are Axis, Axis Title, Data Series, Chart Title, Chart area, Plot Area, Legend, Gridlines, Data Labels, Data Table.

Q8.  List different types of charts that can be created in excel. Write the steps needed to create a chart of any type.

Ans: Different types of charts that can be created in excel are Column chart, Line chart, Pie chart, Bar chart, Area chart, Scatter chart, Surface chart, Doughnut chart, Radar Chart.

Steps to create a chart:

Step 1: Select the desired range of cells.

Step 2: Click the Insert tab. The charts group on this tab contains different types of chart buttons.

Step 3: Click on any of the chart buttons. A List of chart subtypes is displayed.

Step 4: Select the desired chart subtype.

Q9. Write the steps to change the style of the chart.

Ans:    Step 1: Select the desired chart.

           Step 2: Click the design tab and then click the more button in the chart styles group.

           Step 3: Select the desired chart style from the list.