Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 53 - CodePilot V5.0 C7
P. 53

    4    Select the type of data
                              you want to allow.                                    The moon highlights different aspects

                                                                                     at different times, much like filtering
                       5    Set the specific criteria                                 focuses on specific data subsets.
                        (e.g., a range of numbers
                                   from 1 to 30).

                                                6    Click OK to apply the validation.

                     The selected column will now only accept data that meets the specified criteria, ensuring
                     correct data entry. Now, if you enter a quantity greater than 30, an error message will appear,
                     as shown.

                                                                                     You can also set input messages
                                                                                    to guide the user on what type of
                                                                                         data to enter into a cell.

                      TECH
                        T      ¢   Range: A group of adjacent cells selected for use in calculations or other operations.
                        E
                        R      ¢   Trend: The general direction in which data is moving over time, shown visually in charts.
                        M
                        S          Magnitude: It refers to the size or amount of the data represented by the area beneath the
                               ¢
                                  line, showing the volume or change over time.

                     REWIND RUN

                     «   Formulas in Excel start with an equal to (=) sign.
                     «   Operators are symbols used in formulas to perform specific mathematical or logical operations.

                     «   Cell referencing is using the address of a cell in a formula to refer to its value.
                     «   Functions are predefined formulas designed to perform specific calculations based on the data you
                        provide.
                     «   Sorting arranges your information in a specific order.
                     «   Excel offers a variety of chart types to suit different types of data and analysis.

                                                                                                                      51
                                                                                                         Excel in Excel

| 48 49 50 51 52 53 54 55 56 57 58 |