Page 334 - TP_IT_V1.0_C9_flipbpookl
P. 334
B. Fill in the blanks.
1. displays the name or a reference of an active cell or a selected cell range.
2. is used to enter a formula that needs to be applied in the current cell or selected cell range.
3. is a combination of a column name and a row number.
4. The option reduces the font size of the contents to accommodate it within the column width.
5. gives the status of the spreadsheet in terms of insert or overwrite mode, sheet sequence number, page
style and many more.
C. State whether the following statements are true or false:
1. A horizontal scrollbar is used to move up or down in a spreadsheet.
2. Ctrl + Home takes the cursor to the first sheet.
3. An expression with an equal “=” sign is treated as text and no calculations will be done.
4. =min(100:200;3452) is an example of functions in spreadsheet.
5. The size of the font by default is 10 which can be increased or decreased.
SECTION B (Subjective Type Questions)
A. Short answer type questions.
1. Make a list of the tools present in the formula toolbar.
2. Name the three types of referencing methods in the spreadsheet.
3. What is the role of Autofill feature in spreadsheet?
4. The value in cell C10 is 100 and cell D10 is 60. The formula entered in cell E10 is =C10 – D10. If the formula is copied to
E20 then what will be displayed in cell E20:
a. Cell
b. Formula Bar
Explain your answer with reason.
5. Assume the values in some cells as A3=2, B3=3, C3=1 and D3=A3+B3/C3.
What will be displayed in D3 if:
a. A3 is changed to 5
b. B3 is deleted
B. Long answer type questions.
1. Consider the following spreadsheet
Answer the following queries by writing functions/formulas to:
a. find the amount paid for Jeans in the cell D4. (calculated as the product of QUANTITY and PRICE)
b. copy the formula used in D4 from D5 to D8.
c. find the total amount of all the items in the cell D9.
d. find the most expensive item in cell C9.
e. find the most inexpensive item in cell C10.
f. calculate the average price of all the items in cell C11.
g. find the number (count) of the items in cell A9.
h. represent the above data using the suitable chart.
332 Trackpad Information Technology (Ver. 1.0)-IX

