Page 77 - TP_iPlus_V2.1_Class7
P. 77
#Problem Solving & Logical Reasoning
#Digital Literacy
Let’s CatCh Up
Number the steps in the correct order to format numbers in Excel:
Step __ - Click the arrow next to the Number Format box.
Step __ - Select the Number category.
Step __ - Click on the OK button.
Step __ - Click on the More Number Formats option to see more details of number formats.
Step __ - Click on the cell(s) that contains the numbers that you want to format.
Cell Styles
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 option on Styles group
2 Click on the
Home tab.
1 Select the
cell or range
of cells.
4 Select the desired cell styles option that you want to apply.
Fill Color
To apply fill colour, follow the given steps:
3 Click on the arrow next to Fill Color on the Font group.
2 Click on
the Home
tab.
4 Select the
colour that you
1 Select the
cell or range want to fill.
of cells.
75
More on Spreadsheets

