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

