Basic HTML Version

|  | Table of Contents |  | View Full Version

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 |