Page 38 - iPro_trackGPT_V5_Class8
P. 38
2. What are the two main ways to add a formula to a worksheet?
...................................................................................................................................................................................
3. Name the three types of cell referencing that Excel uses.
...................................................................................................................................................................................
4. What is the purpose of changing a sheet's tab colour in Excel?
...................................................................................................................................................................................
B. Long answer type questions.
1. What do you mean by mixed referencing? Give a suitable example.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
2. Write the procedure to sort data in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Name and explain any two categories of functions available in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Payal has created an Excel sheet containing the names of all the students in the class, but
she mistakenly entered them in lowercase instead of uppercase. Is there a way to convert
these names to uppercase? If so, how can it be done?
2. Pooja is creating charts in excel. Help her to decide the type of chart she
should choose if:
a. She wants to show trends over a period of time.
b. She wants to show how different parts make up a whole, often in percentages.
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. Compare two different methods of entering a formula in Excel. Which method do you
find easier and why?
2. Why is it useful to sort data in ascending or descending order? Can you give an example
of when you might do this?
36 TrackGPT iPRO (V5.0)-VIII

