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.
