Page 312 - Trackpad IT-402_Class-IX
P. 312
B. Long answer type questions:
1. Differentiate between row range and column range with an example.
2. Answer the following:
a. Cell A1 contains 20 and B1 contains 3.
What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?
b. The contents of Cell A1, B1, C1 and D1 are 10, -20, 30 and -40 respectively.
What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1)?
c. Cell D3 contains the formula =$B3 + C3 and this formula is copied to cell E3. What will be the copied formula in
cell E3?
3. A Biology teacher has used spreadsheet software to form the tabular format of population growth in various countries in
the last 10 years. She now wants to depict a comparison of the same diagrammatically. Which option of the spreadsheet
she would use? Explain any two types of it.
4. How do formulae work in a spreadsheet? [NCERT]
5. A maths teacher wants to generate a series of multiples of 11. Which feature of the spreadsheet should he be advised to
use to make his work easier? What are the steps to use it?
6. What is the default name of the worksheet? How can it be renamed? [NCERT]
7. What is cell referencing? What is the significance of the $ sign in cell referencing? Explain with examples.
8. What is the use of Min function? Write any three ways to use it.
21 st #Computational Thinking
C. Competency-based/Application-based questions: Century
Skills #Productivity & Accountability
1. Snighdha’s computer mouse is not working properly and she wants to use shortcut key combination to work in digital
spreadsheet. Help her by giving the key combinations to do the following:
a. Move to one screen down on the worksheet.
b. Opens function wizard.
c. Moves the cursor to the Name box of the formula bar.
d. To change the value in a cell.
e. Go to last cell of a worksheet.
2. Consider the following worksheet.
Answer the following queries by writing functions/formulas:
a. Find the number of Jeans to be calculated as the product of QUANTITY and PRICE in cell D4.
b. Copy the formula from D5 to D8.
c. Find the total price of all the items in cell C9.
d. Find the most expensive item in cell C9.
e. Find the most inexpensive item in cell C10.
312 Trackpad Information Technology-IX

