Page 33 - C_GPT _V4 _class_6
P. 33

4.   The               option helps us to fill colour in a cell.
                        5.   If the listed cell borders do not meet your needs, you can create a       border.


                  Q     Answer the following questions:
                    A
                        1.  How will you use the Shift key to select a range of cells?






                        2.   If you want to select the entire column in a worksheet, what will you do?



                        3.   Naina wants to modify the content of a cell in a worksheet. What should she do to achieve this?






                        4.   Which commands are used to make a copy of the selected data?




                        5.   What are the steps used to apply a cell style to a cell?









                        Scratch Your Brain.                                                    21 st  Century   #Critical Thinking
                                                                                                   Skills
                                                                                                       #Technology Literacy
                        1.  Complete the following terms related to Excel:

                            a.     W     A    P             E        T


                            b.       E    L   L             T   Y        E

                            c.   A   U        O    F            L

                            d.       O   R         S   H    E        T


                            e.   C            L



                        2.  Competency-based/Application-based questions:

                            a.   Vani is working in a workbook that contains 10 worksheets with names like Sheet 1,
                               Sheet 2, Sheet 3, and so on. Each worksheet has different set of data. She is having
                               problems remembering the type of data each sheet has. What would you suggest her
                               to overcome this problem?

                            b.   Mary has created a worksheet with records of 100 employees. She wants to apply a border on each
                               row and column to make them identifiable. Which feature of Excel can she use to complete this task?





                                                                                              More on Excel 2019    31
   28   29   30   31   32   33   34   35   36   37   38