Spreadsheet

Question 1

What is conditional formatting?

Answer 1

Conditional formatting is a feature in Excel which allows you to apply formatting to a cell or a range of cells based on certain criteria.
NOTE: CRITERIA MEANS A PARTICULAR CONDITION.
For e.g. (True/False), (Yes/No)

Question 2

To keep the formatting of your worksheet consistent, STYLES can be applied to a cell or a range of cells. HOW CAN YOU APPLY CELL STYLES?

Answer 2

To apply style to an active cell or range, click on ‘Cell Styles’ in the ‘Styles’ group on the Home Tab, then choose the cell style that you want to apply.
NOTE: You can apply MORE THAN ONE style to a cell or range of cells.

Question 3

How are tables formatted?

Answer 3

Tables can be formatted to help organise your content & make it easier for you to locate the information you need. Excel have many predefined (built-in) table styles that you can use to quickly format a table.