Page 45 - TP_Prime_v2.2_Class_6
P. 45

2.  Short answer type questions.

                     a.   Can we unmerge the merged cells? If yes, write the name of the command used to do so.

                     b.  What is the use of Copy command on the Home tab?

                     c.  Which feature of Excel allows us to display multiple lines of text inside a cell?

                 3.  Long answer type questions.

                     a.  Write the steps to wrap the text in a cell.

                     b.  How will you change the row height and column width?

                     c.  How will you apply cell borders?                                                                   MORE ON EXCEL


                                                                                             21 st
                 4.  Competency-based/Application-based questions.                         Century   #Productivity & Accountability
                                                                                            Skills
                     a.   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.                       43
                        How can she change this?


                     b.   Anaya has prepared markesheet of her class. She realised that she has forgotten to enter
                        marks of one subject. How can she create space in the marksheet to enter those marks?


                    Activity Time                                                                  Century   #Critical Thinking
                                                                                                     21 st
                                                                                                     Skills
                 Locate six features of Excel in the grid.


                                         Split, Worksheet, Merge, Cell, Spreadsheet, Range

                                   A    W    B    S    P   L    I    T    C   D    E    F   G    H

                                   E    O    F    G   H    M    J    L   N     P   R    T   V    X
                                   Y    R    A   N    G    E    A    D    E   R    T    U    I   P

                                   B    K    R    S    P   R    E    A    D   S    H    E   E    T

                                   N    S    F    R   T    G    O    I    T   R    E    Y    P   T
                                   M    H    V    F   G    E    A    K    G   F    D    U    L   H

                                   C    E    L    L   S    W    Z    L    F   V    C    I   H    B

                                   K    E    E    C   H    S    X    M    V   F    T    I   J    F
                                   L    T    D   X    B    A    C    N    B   G    G    O   N    N
   40   41   42   43   44   45   46   47   48   49   50