Page 64 - Computer Class 07
P. 64
Conditional Formatting
If you want to apply formatting to cells, which contain data that meets certain
conditions, you can use the conditional formatting.
Let’s Learn...
Let’s
Learn...
To use the conditional formatting.
1. Select the range of cells to format (click on column header, if you want to apply
conditional formatting to the entire column).
2. Click on the Home tab.
3. Click on the Conditional formatting button and point to the Highlight Cell Rules
button. Click on the condition type which you want to apply.
4. The Condition box opens. Enter the condition for which you want the cells to get
formatted.
5. In the With drop-down list, specify the
formatting.
6. Click on the OK button when finished.
The data will get formatted as specified
in the selected range of cells.
8 <= is used to find out the number that is lesser than or equal to the condition.
8 You can enter a whole formula into any cell in your worksheet.
8 By default, all cell references are relative references.
8 A function is a pre-defined formula that performs calculations using specific values
in a particular order.
Objective Type Questions
A. Tick ( ) the correct one.3
1. How many types of operators are there?
a) One b) Two
c) Three d) Four
Computer-7 64 Computer-1
