Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - ClickGPT V4.0 C-5
P. 20

    Interdisciplinary Learning                                                    Lab Activity

                      Create an Excel worksheet of 15 to 20 difficult words you find out from daily newspaper and write their
                      meanings. Apply different formatting features. Also rename the sheet as 'Word Meaning'.

                  AUTOFILL

                  The AutoFill  feature automatically fills  a series of data in your worksheet. It saves your time by
                  completing the text or number series for you.

                                        Enter the first two numbers and select both the   1
                                        cells containing the numbers you have entered.

                                                   Position the mouse pointer
                                                   over the bottom right corner   2
                                                   of the last selected cell.

                                                                      Drag the mouse pointer
                                                                  3   over the cells you want
                                                                      to include in the series.

                              Quick Quiz

                    1.  What action allows you to combine multiple cells into one larger cell in a spreadsheet?

                               a. Selecting Cells                      b. Merging Cells

                    2.   Which feature in a spreadsheet application allows you to automatically fill cells with a series or pattern of
                        data?
                               a. Customising Worksheet Tab            b. AutoFill

                    3.  To adjust the width of columns or the height of rows in a spreadsheet, which feature should you use?
                               a. Inserting Rows/Columns               b. Column Width and Row Height

                                Recap

                                Excel provides a lot of facilities to modify and process data.

                                You can specify a column width of 0 to 255 characters and a row height of 0 to 409 points.

                                The default column width is 8.43 characters and the default row height is 15 points.

                                Combining two or more cells is known as merging.

                                Splitting cells means to separate two cells that were previously merged.
                                You can format a number of elements such as text, numbers, colouring and table styles.
                                AutoFill feature automatically fills a series of data in your worksheet.

                     18     Premium Edition-V

| 15 16 17 18 19 20 21 22 23 24 25 |