Advanced Formatting (Grade 11 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What does conditional formatting do automatically?
What does conditional formatting do automatically?
Applies formatting based on cell values
How many main types of conditional formatting rules are there?
How many main types of conditional formatting rules are there?
Five
What do data bars do in cells?
What do data bars do in cells?
Act like mini bar charts inside cells
What effect do colour scales create in spreadsheets?
What effect do colour scales create in spreadsheets?
Heat map effect
Which values can Top/Bottom rules highlight?
Which values can Top/Bottom rules highlight?
Top 10 or bottom 10 values
What is AutoFill compared to in the note?
What is AutoFill compared to in the note?
A smart assistant
Where is the fill handle located?
Where is the fill handle located?
Bottom-right corner of selected cell
What does Fill Series create?
What does Fill Series create?
A logical sequence
What symbol creates absolute references?
What symbol creates absolute references?
Dollar sign ($)
What does a fully absolute reference look like?
What does a fully absolute reference look like?
1