Page 36 - Trackpad_ipro 4.1_Class8
P. 36
B. Write ‘T’ for true and ‘F’ for false. Correct the false statements.
1. Every formula begins with a + sign. ..........................
2. Combined reference is a type of cell reference. ..........................
3. We cannot create a Bar chart in Excel. ..........................
4. You cannot sort more than one column at a time in a selected
range of cells. ..........................
5. The Add Level button is available under the Insert tab. ..........................
6. Sorting can also be done through the Sort & Filter group under the
Data tab. ..........................
C. Fill in the blanks using the words given below:
Hints
Functions, Equal, Dollar ($), Square root, Custom sort, Column
1. .......................... are predefined formulas in Excel.
2. Formulas in Excel begin with the .......................... sign.
3. The SQRT function returns the .......................... of the given number.
4. The .......................... chart usually displays the data in the form of vertical bars.
5. In Mixed Referencing, you can lock either a column or a row by preceding it with a
.......................... symbol.
6. .......................... is used when data is to be sorted on the basis of more than one criteria.
D. Match the following:
1. Area chart a. Trends over a period of time
2. Pie chart b. Quantitative magnitude of data
3. XY Scatter Plot chart c. Sector showing relative size of each value
4. Line chart d. Correlation between two sets of values
Let's Do It Section B (Subjective)
A. Short answer type questions.
1. What is a cell reference?
...................................................................................................................................................................................
2. Define the following terms:
a. Data Series b. Legend
.................................................................................. .....................................................................................
.................................................................................. .....................................................................................
34 iPro (Ver. 4.1)-VIII

