Page 77 - iPlus_Ver_2.0_class_7
P. 77

#Problem Solving & Logical Reasoning
 #Digital Literacy  Quick Byte
 Let’s CatCh Up      Microsoft Excel saves your 10 most recently selected custom colours. To quickly apply one

                     of these colours, click the arrow next to Fill Color, and then click the colour that you want
 Number the steps in the correct order to format numbers in Excel:
                     under Recent Colors.
 Step __ - Click the arrow next to the Number Format box.
                 Text Color
 Step __ - Select the Number category.

 Step __ - Click on the OK button.   To apply text colour, follow the given steps:

 Step __ -  Click on the More Number Formats option to see more details of number formats.   3  Click the arrow next to Font Color.
 Step __ - Click on the cell(s) that contains the numbers that you want to format.
                      2  Click on the
 Cell Styles         Home tab.

 You can use a cell style that includes a custom border, colours, and formatting. To apply the style
 to the cell, follow the given steps:

 3  Click on the Cell Styles command.                                                             4  Choose the
                       1  Select the
                                                                                                  colour that you
                       cell or range
 2  Click on the                                                                                  want to fill.
                       of cells.
 Home tab.
 1  Select the
 cell or range    i +  AUTOFILL
 of cells.
                 AutoFill feature is an additional feature in spreadsheet package like ‘Excel’ in which a certain
                 kind of predefined series of data such as name of months of a year, serial numbers, etc. are
                 automatically generated once the user feeds the initial data.

                 To use the AutoFill feature, follow the given steps:



 4  Choose the desired Cell Styles option.
 Cell Fill            1  Enter the first two numbers and


 To apply fill colour, follow the given steps:  select both the cells containing
                     the numbers you have entered.
 3  Click the arrow next to Fill Color.                                             2  Position the mouse pointer
                                                                                   over the bottom right corner
                                                                                   of the last selected cell.
 2  Click on
 the Home
 tab.


 4  Choose the
 colour that you
 1  Select the
 cell or range   want to fill.                              3  Drag the mouse pointer
                                                           over the cells you want to
 of cells.
                                                           include in the series.





                                                                                                                  75
                                                                                          More on Spreadsheets
   72   73   74   75   76   77   78   79   80   81   82