Functions in Spreadsheets (Grade 10 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 is the golden rule of sorting in spreadsheets?
What is the golden rule of sorting in spreadsheets?
Always keep row information together
Where are sorting tools located in Excel?
Where are sorting tools located in Excel?
Data tab
What does ascending order mean when sorting?
What does ascending order mean when sorting?
A to Z or smallest to largest
What does descending order mean when sorting?
What does descending order mean when sorting?
Z to A or largest to smallest
When is the Sort dialogue box method most useful?
When is the Sort dialogue box method most useful?
When you need more control over sorting
What is the first step in Method 1 for sorting a range?
What is the first step in Method 1 for sorting a range?
Select the entire data range
What are the quick sort button options called?
What are the quick sort button options called?
Sort A to Z and Sort Z to A
Why must row information stay together when sorting?
Why must row information stay together when sorting?
To maintain relationships between data
What is a common mistake when sorting data?
What is a common mistake when sorting data?
Sorting only one column with related data
What should you select to prevent data from becoming mixed up?
What should you select to prevent data from becoming mixed up?
The entire range of related data