Page 78 - iPrime_V2.2_class7
P. 78
C. Fill in the blanks using the words given below:
Hints
Cell Styles, Select All, Insert, Merge & Center
1. The ................................ command on the Home tab is used to add a column to a worksheet.
2. We can apply a style to the cells by using the ................................ command in the Styles
group under the Home tab.
3. We can select the entire worksheet by clicking on the ................................ button.
4. We can use ................................ option in the Alignment group to combine two or more
selected cells into a single cell.
Let's Do It Section B (Subjective)
A. Short answer type questions.
1. Can we unmerge the merged cells? If yes, write the name of the command used to do so.
2. What is the use of the Copy command on the Home tab?
3. Which feature of Excel allows us to display multiple lines of text inside a cell?
B. Long answer type questions.
1. Write the steps to wrap the text in a cell.
2. How will you change the row height and column width?
3. How will you apply cell borders?
4. If we type 12*(10+5)-5 in cell A5 and press the Enter key, then what will be the result in cell
A5? Justify your answer.
C. Application-based questions.
1. Sonia is preparing project details in a spreadsheet. Some 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. Anaya has prepared a marksheet for her class. She realised that she had
forgotten to enter the marks for one subject. How can she create space in
the marksheet to enter those marks?
Critical Thinking
Higher Order Thinking Skills (HOTS)
1. 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?
76 Touchpad iPRIME (Ver. 2.2)–VII

