Page 388 - TP_IT_V1.0_C9_flipbpookl
P. 388

After creating the sheet, write functions/formulas to the following:
                   Write the formula to calculate the Total points (Sum of Points + Bonus) of each player in cell F2 to F6.

                   Write the feature used for arranging the Rank from Highest to Lowest.
                   To find the Player with Maximum TOTAL to be written to Cell F7.
                   To find the Average of Points to be written in cell C7.

                   To change the Orientation of the Page from Landscape to Portrait.
               6.  Create the Quarterly sales report in LibreOffice Calc:














                  After creating the report, write functions/formulas to the following:

                   Write the formula to calculate the Total sales of North Zone.
                   Write the feature used for arranging the Sales from Lowest to Highest.
                   To find the Maximum Sales in East Zone.
                   To find the Average Sales in Jan-Mar in cell C7.

                   To find the difference between the sales in East Zone and West Zone in Apr-Jun.

                                                                                                       21 st
              Digital Presentation:                                                                  Century   #Creativity
                                                                                                      Skills
               1.  Create a Presentation on:
                  Ethics in IT

                  New Trends in Technology
                  Global Warming
                  Impact of Social Media

                  Cyber security
                  If you are given a choice of career in IT, then which one will you prefer and why?
                   Plagiarism and the World Wide Web

                 Notes
                   The presentation should have minimum of 10 slides.
                   The first slide should have your name, class and section.

                   The second slide should be the index slide.
                   All the slides in the presentation should have a common background.

                   Try to include one appropriate picture per slide.
                   Use Custom Animation and transition effects in each slide.
                  Use all the features learnt so far.


                386   Trackpad Information Technology (Ver. 1.0)-IX
   383   384   385   386   387   388   389   390   391   392   393