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

