Page 31 - C_GPT _V4 _class_6
P. 31

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.




                                                                                              More on Excel 2019    29
   26   27   28   29   30   31   32   33   34   35   36