Page 1 :
ST. MARY’S CONVENT SR. SEC. SCHOOL, DEWAS, Periodic Test — 3, 2021-22, Information Technology (Code 402), , Class IX, Max. Marks: 20, General Instructions:, 1. Read the questions carefully., 2. Marks allotted are mentioned against each question., ‘Answer the following questions —, 1. What is the difference between a worksheet and a workbook? 1M, 2. What are embedded charts? 1M, 3. What is the use of sorted data? 1M, 4. What is conditional formatting? 2M, 5. What are regular expressions? How are they useful? 2M, 6. Write two advantages and two disadvantages of using charts and graphs. 2M, 7. ‘Quality Ice cream Parlour’ maintains the details of items sold during the day ina, workbook as shown below - 2M, 4 A B c D, 1 Quality Ice cream Parlour, 2 Flavour Quantity Rate Amount, 3 Pista 14 35 490, 4 Vanilla 20 30 600, 5 Tuti Frooti 6 35 210, 6 Cassatt 4 40 160, 7 Mango 8 35 280, 8 Kesar 6 40 240, 9 Total 1980, a) Give the cell references of two cells that should change automatically when Quantity, of Vanilla ice-cream is changed., b) Write the formula used in cell ‘D9’ to find Total Amount., 8. Write the steps to insert an object from gallery. 3M, 9. How will you format date so that it appears in the format similar to 02-February-2022? 3M, 10. Write cell references for the following — 3M, , a) Cell formed by intersection of Row 18 and Column F, b) Absolute reference formed by Row 8 and Column K, c) Mixed reference (relative column and fixed row) formed by Row 15 and Column M