Page 81 - iPlus_Ver_2.0_class_7
P. 81
B. Long answer type questions:
1. Write the steps to create a custom number format in Excel.
2. How will you change the row height and column width?
3. How will you apply cell style?
4. What are different elements of a formula? Explain them in brief.
5. What are certain rules of precedence while performing calculations using a formula in Excel?
C. Competency-based/Application-based questions:
1. Sonia is preparing project details in a spreadsheet. Some of the text in a cell is too long and gets
hidden when she types text in the adjacent cell on the right. How can she change this?
2. Assertion (A): Anaya needs to create space in the marksheet to enter marks for a forgotten
subject.
Reason (R): To make room for the additional marks, she can adjust the layout or formatting of
the marksheet, such as adding a new row or column.
(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
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Locate six features of Excel in the grid.
W R A P T E X T T F J A
R V G E U R E T I O O U
A H T G M F D R M R C T
M N X C O L U M N M E O
T B F R F W S W J U M F
M E R G I N G C E L L I
X O U M N L H E K A F L
T C E L L N I I B S I L
#Experiential Learning
Let’s Explore
Find out about more formulas used in Excel and discuss with your teacher.
79
More on Spreadsheets

