Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2629_Devagiri_C-6
P. 34

    The options to insert, delete, rename, move and copy a worksheet are available in the Cells
                                                             group on the Home tab.

                                                                                               21 st
                           EXPERIENTIAL LEARNING                                              Century   #Technology Literacy
                                                                                               Skills
                        Create an Excel worksheet to track how many hours you spend on each subject every week.

                        (a)  Use columns for days of the week and rows for different subjects.
                        (b)   Format the text using bold for subject names and adjust the font size to make headings clear.
                        (c)  Rename the sheet as ‘Study Tracker’.

                             ADJUSTING COLUMN WIDTH AND ROW HEIGHT

                      In Excel, you can adjust the column width and row height to fit your data. You can specify a column
                      width from 0 to 255 characters and a row height from 0 to 409 points. This helps make your
                      worksheet more organised and readable. To set column width or row height, follow the given steps:

                                                              3    Click on the Format
                          2  Click on the Home tab.           option in the Cells group.
                                                                                          The default  column  width  in
                                                                                          Excel is 8.43 characters, while
                                                                                          the  default  row height  is  15
                                                                                          points.

                                                                                          If a cell shows #####, it means
                                                                                            the number is too wide for
                                                         4    Choose Column Width or
                          1    Select the column(s) or                                       the column. Increase the
                         row(s) whose width or height   Row Height from the dropdown.       column width to see it fully.
                            you want to change.

                      A Column Width or Row Height dialog box will appear.

                                                                                                5    Type the value that you
                                           5    Type the value that you                          want for the row height.
                                           want for the column width.

                                                                       OR
                         6    Click on the                                     6    Click on the
                            OK button.                                             OK button.

                       32
                            Premium Edition-VI

| 29 30 31 32 33 34 35 36 37 38 39 |