Page 82 - TP_iPlus_V2.1_Class7
P. 82
B. Long answer type questions:
1. Explain two ways to enhance your spreadsheet.
2. What is the difference between splitting and merging of cells?
3. Explain the elements of a formula.
4. When performing calculations using a formula, Excel follows certain rules of precedence. Explain
them.
5. Differentiate between Undo and Redo command.
C. Competency-based/Application-based questions:
1. Bhavik is creating an Excel worksheet where he has entered the names and
percentages of all the students in his class. When he prints the worksheet, the
border lines are not visible. What could be the possible reason for this?
2. Mallika is entering the number 45.68 into cell B4. However, when she presses the Enter key,
the value changes to 45.7. What could be the possible reason for this?
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. If Pavani selects cells A1 and A2 in Excel, both containing the number 5, and then uses the fill
handle to drag down to cell A10, what will the content of cell A8 be?
2. If Archit selects cells D1 and D2 in Excel, containing the numbers 5 and 10 respectively, and then
uses the fill handle to drag down to cell D10, what will be the value in cell D9?
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Write the output:
1. = 5 + 5^2
2. = (5 + 5)^2
3. = (8 + 4) – (3 – 2)^3
3. = 9/3 * 4
#Experiential Learning
Let’s Explore
Browse the internet to understand the differences between a formula and a function.
80
iPlus (Ver. 2.1)-VII

