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
   73   74   75   76   77   78   79   80   81   82   83