Page 37 - Trackpad_ipro 4.1_Class8
P. 37
3. Define sorting.
...................................................................................................................................................................................
4. What is an area chart?
...................................................................................................................................................................................
B. Long answer type questions.
1. What is the use of the LEN function? Explain with an example.
...................................................................................................................................................................................
...................................................................................................................................................................................
2. What are the rules for entering a function?
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Differentiate between a Column chart and a Scatter chart.
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. You’re helping your class plan a fundraising event and need to calculate
the total amount raised from different activities and expenses. Which
spreadsheet function will assist you in managing and analysing this data
efficiently?
2. You’re presenting your class project on how different sports teams performed throughout
the year. Which types of charts in Excel will help you visualise and compare the performance
of each team more clearly?
#Experiential Learning
Higher Order Thinking Skills (HOTS)
Anjana has prepared stationery list to be purchased for her daughter in Excel as shown
below:
Now, perform the following tasks on the prepared spreadsheet:
a. In E2, she is writing the formula for calculating the amount spent on Notebooks,
as C2 * D2, but she is not getting any answer. Why? (Help her write the correct
input)
Spreadsheet—Functions and Charts 35

