Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 38 - 2629_Devagiri_C-7
P. 38

    To insert Sparklines, follow the given steps:

                        2    Click on the Insert tab.
                                                                                                  3    Choose the type of
                                                                                                 Sparkline you want to use.

                                                                                                  1    Select the range of cells.

                                                                      4    Enter the cell in the Location Range.

                                    5    Click OK to insert the Sparkline.

                      The Sparklines will now appear in the cell for the selected Location Range, visually representing

                      the data trends.

                             USING DATA VALIDATION

                      Data validation is used to restrict users from entering specific values in a cell or range of cells. It
                      helps prevent incorrect data entries and ensures that the data entered in Excel is accurate.

                      For example, if you want to restrict entries in the Quantity column to only numbers between 1
                      and 30, you can apply Data Validation to prevent users from entering values outside this range.
                      To apply Data Validation, follow these steps:

                                                          2    Click on the Data tab.

                                                                                                      3    Click on the Data
                                                                                                     Validation option.
                          1    Select the column header
                        where you want to apply data
                                         validation.

                       36
                            Premium Edition-VII

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