Page 21 - ClickGPT V4.0 C-5
P. 21

Assess Yourself

                        Choose the correct option.

                        1.   Nimish has created a worksheet with 4 rows and 4 columns. Now, he wants to perform some operations
                           on the worksheet, like moving, copying, and deleting data. What should be the first step to do so?
                                  a. Select data                                b. Hide data


                                  c. Organise data                              d. None of these
                        2.    Sakshi wants to change the width of a column in an Excel worksheet. What is the range for specifying
                           column width?

                                  a. 0 to 255 points                            b. 0 to 409 characters

                                  c. 0 to 255 characters                        d. 0 to 409 points

                        3.    Suppose, you want to break a cell into two cells. Which of the following operations will work in this situation?
                                  a. Merging cell                               b. Appending cell


                                  c. Splitting cell                             d. Deleting cell
                        4.   Which of the following features is used to display multiple lines of text inside a cell?

                                  a. Wrap Text                                  b. Cut

                                  c. Copy                                       d. Paste

                        5.   Which of the following operations can we perform on a worksheet tab?

                                  a. Change colour                              b. Delete

                                  c. Rename                                     d. All of these


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

                        1.  Wrapping text in a cell does not affect other cells.

                        2.   Combining two or more cells is known as merging.

                        3.   We can add a border only around a particular cell in a worksheet.

                        4.   AutoFill feature automatically fills a series of data in your worksheet.

                        5.   The Insert button on the Home tab is used to add a column into a worksheet.

                        Fill in the blanks with the correct words.


                                             Hints  Cut & Paste, Select, Fill Color, Select All, Custom


                        1.  Click on the cell to            it.
                        2.   The               button is used to select the entire worksheet.
                        3.    When we use the               commands, the content is moved to the new place and removed
                           from its original place.



                                                                                              More on Excel 2019    19
   16   17   18   19   20   21   22   23   24   25   26