Page 38 - iprime_V2.2_class8
P. 38
D. Match the following:
1. Area Chart a. Trends over a period of time
2. Pie Chart b. Quantitative magnitude of data
3. XY Scatter Plot Chart c. Sectors showing relative size of each value
4. Line Chart d. Correlation between two sets of values
Let's Do It Section B (Subjective)
A. Short answer type questions.
1. What is a cell reference?
2. Define the following terms:
a. Data Series b. Legend
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:
36 iPRIME (Ver. 2.2)–VIII

