Page 39 - TP_iPlus_V2.1_Class8
P. 39
Section B (Subjective)
A. Short answer type questions:
1. What is a cell range?
2. Define the following terms:
a. Data Labels
b. Legend
3. Define sorting.
4. What is a scatter chart?
B. Long answer type questions:
1. What is the use of the CONCATENATE function? Explain with an example.
2. What are the rules for entering a function?
3. Differentiate between a Pie chart and a Bar chart.
C. Competency-based/Application-based questions:
1. Saloni has been asked by the teacher to present the information in the form of a
suitable chart. She has data for a single series and the graph must show the relative
circular size of each value. Which chart type must she use?
2. Nidhi has made a spreadsheet for the marks obtained by the students in her class in
different subjects. Which feature should she use to keep the spreadsheet updated
if she has to change marks in one of the subjects of any student?
3. John is preparing a list of students with their marks obtained in exams. He wants to arrange the
data in ascending order according to the students' names. Suggest him a feature of Excel which
can help him in doing his work quickly.
4. The following question consist of two statements – Assertion (A) and Reasoning (R). Answer
these questions by selecting the appropriate option given below:
Assertion (A): Sorting in Excel can only be done in ascending order.
Reason (R): Excel does not support sorting data in descending order.
(a) Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)
(b) Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of
Assertion(A)
(c) Assertion (A) is true and Reason (R) is false
(d) Assertion (A) is false and Reason (R) is true
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. Gurvindar created an excel file. In it he used a chart to display data. According to you why he used the
chart in it?
2. Charles had to select row 7 in an Excel file. To do so, he clicked on the first cell of the row and dragged
it to select the entire row. If you were on his place, then how would you have selected the entire row 7?
37
Spreadsheet—Functions and Charts

