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

