Page 37 - iPro_trackGPT_V5_Class8
P. 37
B. Write ‘T’ for true and ‘F’ for false.
1. Capital function converts the text into upper case. ..........................
2. It is not possible to join together two or more different text strings
in Excel. ..........................
3. Every function in Excel must be followed by opening and closing
parentheses (). ..........................
4. You can select a cell range by either using the mouse or by holding down
the Shift key. ..........................
5. In the reference $G1, the column G is fixed, but the row is changable
change. ..........................
C. Fill in the blanks using the words given below:
Sorting, Functions, Count, Mixed, $
1. .......................... sign is used before row number and column letter to create an absolute
reference.
2. .......................... means arranging data in a certain order, like ascending (from smallest to
largest) or descending (from largest to smallest) order.
3. $A5 is an example of .......................... referencing.
4. Excel also contains built-in formulas called ...........................
5. .......................... function returns the count of the number of values in the selected range.
D. Match the following:
1. Data Series a. It can be horizontal or vertical, depending on
the chart type.
2. Data Labels b. It is a collection of related values.
3. Gridlines c. The rectangular section between the X and Y
axes.
4. Plot Area d. It shows data values, category names, series
names, etc.
Answer Arcade Section B (Subjective)
A. Short answer type questions.
1. Define chart.
...................................................................................................................................................................................
Spreadsheet—Functions and Charts 35

