Page 1 :
A~4264008 ee, , , , TF [all al 91% Ml 22:12, , , , , , , , € Class? IT-PT3.pdf (QQ &, , 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 ~, , What is the difference between a worksheet and a workbook?, , ‘What are embedded charts?, , What is the use of sorted data?, , ‘What is conditional formatting?, , What are regular expressions? How are they useful?, , Write two advantages and two disadvantages of using charts and graphs., ‘Quality Ice cream Parlour’ maintains the details of items sold during the day in a, ‘workbook as shown below , ZZEEE2, , z, , 4] 4 8 ¢ D, , 1 Quality Ice cream Parlour, 2 Flavour Quantity Rate Amount, 3 Pista 435490, 4 Vanilla 2 30600, 5 TutiFrooti 35210, 6 Cassatta 40 160, 7 Mango 35280, 8 Kesar 40 240, 9 Total 1980, , 2a) 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, , ) Cell formed by intersection of Row 18 and Column F, , b) Absolute reference formed by Row 8 and Column K, , ©) Mixed reference (relative column and fixed row) formed by Row 15 and Column M, , , , o