Processing Data (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
Definition of data processing
Definition of data processing
Transforming raw data into useful information
Main goal of data processing
Main goal of data processing
Transform raw data into relevant & appropriate info
Most common data processing technique
Most common data processing technique
Sorting
What sorting means
What sorting means
Arranging/moving data without changing values
Location of Excel sorting tools
Location of Excel sorting tools
Data tab, Sort & Filter group
How text is sorted in Excel
How text is sorted in Excel
A to Z (ascending) or Z to A (descending)
Sorting by multiple columns in Excel
Sorting by multiple columns in Excel
Use Sort dialogue box, click 'Add Level'
What Excel formulas must begin with
What Excel formulas must begin with
Equals sign (=)
6 key Excel functions for data processing
6 key Excel functions for data processing
SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF
VLOOKUP function purpose
VLOOKUP function purpose
Finding specific information in large datasets