Page 313 - Trackpad IT-402_Class-IX
P. 313

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 a suitable appropriate chart.

               3.  A shopkeeper wants to do some calculations to do some stock update checks. Help him do so by suggesting the built in
                  functions to do the following tasks:
                  a.  To find the lowest quantity of the item in the stock.
                  b.  To add the price of the total stock.

                  c.  To find the average price of the stock.
                  d.  To find the highest price stock.
               4.  Rohit is preparing montly sales report with the help of spreadsheet. While typing, the text is not accommodated within the
                  column width. Which option should he use to make the text appear properly?

               5.  Make a list of your friends with name, phone number, birth date. Give the steps to do the following:
                  a. Generate the serial number using the AutoFill feature and write the steps.

                  b. Name should be center aligned.
                  c. Birthdate should be in the format dd,month,yyyy.

                  d. Give the extension of the file created in OpenOffice Calc.
               6.  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.






                                                                                          Electronic Spreadsheet  313
   308   309   310   311   312   313   314   315   316   317   318