Page 58 - Code Craft Computer-7

Knowledge Check

A. Mark the correct response.

1. ___________ feature is used to set a specific result for one cell
by adjusting a value in another cell. OMR Sheet
a. Data Validation b. Filter
Use only blue/black ball
c. Goal Seek d. Subtotal pen to fill the circles. It
should be darkened
2. ________feature allows us to arrange the given data according completely and properly.
to a particular field either in an ascending or in a descending Wrong methods
order.
Correct method
a. Filter b. Data Validation
c. Sort d. None of these
1. a b c d
3. _________helps us to manage and analyse the data.
a. Goal Seek b. Subtotal
2. a b c d
c. Data Validation d. None of these

4. _________ component of a chart depicts the colours, patterns 3. a b c d
and symbols assigned to a data series.
a. Plot Area b. Data Series 4. a b c d
c. Legend d. Data Marker

B. Gap-fill exercise.

1. ___________ means arranging data either in ascending or descending order.
2. ___________ is a powerful tool for consolidating, summarising and presenting the data.
3. ___________ is used to restrict the cell entries within a specified range.

4. ___________ are the bars, slices or other elements that represent the data values.
5. A ___________ is a pictorial representation of data.

C. True and False assessment.

1. Filtering means sorting the data.
2. You can sort data only in ascending order in a worksheet.
3. When the data changes, the chart is updated automatically.
4. Category axis is the horizontal axis of the chart.

5. Value Axis is also known as x-axis.

D. Give appropriate responses to the questions.
1. What is the use of the sorting feature in Excel?
2. What is the use of Subtotal?

3. State the use of PivotTable.
4. How is sorting different from filtering the data in Excel?

5. What is a chart? Name some components of a chart.

58