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

Video based question                                                                 Scan the
              Watch the video and answer the question.                                             QR Code

                 What is the difference between sorting and filtering data?








                                                                                                 21 st   #Creativity
              LAB ACTIVITY                                                                     Century   #Flexibility
                                                                                                Skills
              1.  Complete the following activities in OpenOffice Calc.
                 •  Create a worksheet with the following headings and data:















                 •  Format the cell:
                      w C2:C5 to hold phone number starting with 0.
                      w D2:D5 to hold decimal values.
                      w E2:E5 to hold Date. Other versions of date can also be used.

              2.   Implement the example of the shopping bill discussed in this chapter. Study any bill
                 you get from a super store and implement it in Calc.                                   [NCERT]
              3.   Generate the Calc document with your in all your marks six different subjects. Make
                 total of the marks find out average and percentages from the data.                     [NCERT]
              4.   Use help to find information about sorting and filtering. Prepare notes on these topics
                 using Help.                                                                            [NCERT]

              5.   Use your notes on data validation and also use the data you have entered in Question 8 of this
                 exercise, to validate the data in the date of birth column so that nobody can enter data such as 33.
                 You have to make data validation in such a way that it will accept only 1 to 31 numbers as date
                 of birth values.                                                                       [NCERT]








               CAREER HERE
        People who are expert in spreadsheet may pursue their career as a Data Analyst, Data Entry Operator, Market Research Analyst,
        Retail Store Manager, Business Analyst, etc.





          314   Trackpad Information Technology-IX
   309   310   311   312   313   314   315   316   317   318   319