Page 335 - TP_IT_V1.0_C9_flipbpookl
P. 335

2.  Answer the following:
                       a.   Cell A1 contains the number 20 and B1 contains 3. What will be the value in 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 & -40 respectively. What will be the value 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 formula in cell E3?

                    3.  A Biology teacher used the 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.  A maths teacher wanted to generate a series of multiples of 11. Which feature of Spreadsheet should he be advised to use
                       to make his work easier? Explain with steps.
                    5.  What is cell referencing? What is the significance of $ sign in cell referencing? Explain with examples.

                                                                                               21 st   #Computational Thinking
                 C.  Competency-based/Application-based questions.                           Century
                                                                                               Skills  #Productivity & Accountability
                    1.  The HR Department of M/s Visilac LLC asked the Accounts Department to share the Salary Breakup of the employees for
                       further deliberation on revising the salaries in the future. The Accounts Department shared the following data, which
                       now needs to be analysed for Management’s decision-making process. Review the data below and answer the following
                       questions:
























                       a.  Calculate the DA as 25% of BASIC+HRA for each employee and display it in column D.
                       b.  Calculate the NET SALARY as BASIC+HRA+DA–PF for each employee and display it in column F.
                       c.  Find the maximum NET SALARY and display it in cell F9.
                       d.  Represent the above data in the form of a suitable chart.
                    2.  The figure given below shows marks scored by students in three different subjects:














                       Perform the given tasks based on the above spreadsheet:
                       a.  Write the formula in E2 to find the total marks scored by Arshia.
                       b.  Copy the formula entered in E2 for other students.


                                                                                               Electronic Spreadsheet  333
   330   331   332   333   334   335   336   337   338   339   340