Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 39 - CodePilot V5.0 C6
P. 39

    REWIND RUN

                     «   Auto Fill quickly fills cells with a series of data, like numbers or dates, by continuing a sequence based
                        on the first few entries.
                     «   Flash Fill automatically fills data based on the pattern you start typing, helping to split, combine or
                        format text like names and phone numbers.
                     «   A custom list allows you to define your own series of data that can be used to automatically fill cells.

                     «   Formatting text in a worksheet involves changing how the text appears to make it easier to read and
                        more visually appealing.

                     «   In Excel, you can easily add, rename or delete worksheets to organise your data better.
                     «   You can adjust the row height and column width automatically to fit the contents of the cells.

                                                 LEARNING LOGS

                     A.  Tick ( ) the correct option.
                        1.  Choose the feature that quickly fills cells with a series of data.

                                  (i)  Flash Fill                          (ii)  Auto Fill

                                  (iii)  Series Fill                       (iv)  Handle Fill

                        2.   Spot the option that is used to move the data to a new location.

                                  (i)  Cut                                 (ii)  Copy

                                  (iii)  Save                              (iv)  Delete

                        3.  Identify the purpose of adjusting column width in Excel.

                                  (i)  To change the font size             (ii)  To fit data properly in cells

                                  (iii)  To add a new worksheet            (iv)  To delete unwanted data

                        4.   To delete a row in Excel, which option should you select after right-clicking the row number?

                                  (i)  Insert Row                          (ii)  Delete Sheet Rows

                                  (iii)  Format Row                        (iv)  Merge Cells
                        5.   Which option helps you quickly split or combine text based on patterns in Excel?

                                  (i)  Auto Fill                           (ii)  Flash Fill

                                  (iii)  Bold                              (iv)  Merge & Center

                                                                                                                      37
                                                                                                         Explore Excel

| 34 35 36 37 38 39 40 41 42 43 44 |