Advanced Formatting (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Conditional formatting definition
Conditional formatting definition
Auto-applies formatting when cells meet specific conditions
5 main types of conditional formatting rules
5 main types of conditional formatting rules
Highlight cells, Top/Bottom, Data bars, Colour scales, Icon sets
What data bars do
What data bars do
Add coloured bars in cells like mini bar charts
What colour scales create
What colour scales create
Heat map effect using gradients
What icon sets add to cells
What icon sets add to cells
Small symbols based on values
AutoFill definition
AutoFill definition
Automatically fills in patterns of data to save time
Fill handle location
Fill handle location
Small square in bottom-right corner of selected cell
Relative references behaviour
Relative references behaviour
Cell references adjust automatically when copied
How to create absolute references
How to create absolute references
Add dollar signs ($) before column letter and/or row number
3 types of absolute references
3 types of absolute references
Fully absolute (1), Column (1)