Page 87 - TGPT_V5.0_C5_Flipbook
P. 87

3.  Which of these is the keyboard shortcut to copy and paste cell contents?

                                 a.  Ctrl + Z & Ctrl + V                       b.  Ctrl + C & Shift + V
                                 c.  Ctrl + C & Ctrl + V                       d.  Shift + C & Ctrl + V

                        4.  Which of the following functions is used to calculate the smallest value of a range of values?
                                 a.  MIN                                       b.  SUM

                                 c.  AVG                                       d.  None of these

                        5.  Which of the following is true about the Wrap Text feature?

                                 a.  It deletes the text in the cell.
                                 b.  It changes the text colour.

                                 c.  It displays multiple lines of text inside a cell.

                                 d.  It affects the text in other cells.
                        6.   What happens if a column or row has a width or height of 0?

                                 a.  It becomes larger                          b.  It gets hidden

                                 c.  It changes colour                          d.  It gets deleted


                        Fill in the blanks with the correct words.



                          Hints  Predefined, Len, 15 points, Cell, Functions, Column, 8.43 characters, Product

                        1.  To edit any content, you have to select the                             .


                        2.  To select a column, place the mouse pointer on the                                header.

                        3.                               function multiplies the value in a range of cells.

                        4.                               are predefined formulas in Excel to perform both simple and
                           complex calculations.

                        5.                               function returns the length of the text string.

                        6.   By using                             border styles, you can quickly add a border around
                           cells or ranges of cells.

                        7.    The default column width is                             and the default row height is
                                                         .


                         Tick () the correct statements and cross () the wrong ones.

                        1.    You can also change the data by double-clicking in the cell and start typing
                           the new data.

                        2.   You cannot create a custom border in Excel.





                                                                                     Editing Cell Contents in Excel 2021  85
   82   83   84   85   86   87   88   89   90   91   92