Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - CodePilot V5.0 C6
P. 27

    BRIDGE BACK

                      Look at the picture and answer the following questions:
                      (a)  How many rows and columns are visible?
                      (b)  Which cell contains the highest value?

                      (c)  What value is displayed in cell C3?
                      (d)  Which two cells have the same value?

                     As you know, Excel is a powerful tool for managing and analysing data. It allows you to enter
                     data into a spreadsheet in a tabular format, organised into rows and columns. Excel offers a wide
                     variety of editing and formatting techniques.

                            AUTO FILL AND FLASH FILL

                     Auto Fill and Flash Fill are two powerful features that help you work faster and more efficiently.
                     These tools automatically complete data for you, saving you time and ensuring consistency.

                     AUTO FILL

                     Auto Fill quickly fills cells with a series of data, like numbers or dates, by continuing a sequence
                     based on the first few entries. To use the Auto Fill feature, follow the given steps:

                           1    Enter the first two
                       values to start the series.
                                                                                                 3    Hover the mouse over
                            2    Select both cells                                              the bottom-right corner
                               with the values.                                                 of the second cell (pointer
                                                                                                changes to the + sign).

                                           4    Drag the pointer over
                                            the cells you want to fill.

                     The Auto Fill feature will automatically fill in the data based on the pattern, completing your series

                     or sequence with minimal effort.

                                                                                                                      25
                                                                                                         Explore Excel

| 22 23 24 25 26 27 28 29 30 31 32 |