Advanced Formulas and Functions (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
Formula in Excel
Formula in Excel
Expression using cell values to calculate, starts with =
Function in Excel
Function in Excel
Pre-built formula that performs specific calculations
Key difference: formula vs function
Key difference: formula vs function
Formulas are custom; functions are pre-built Excel tools
Number of built-in functions in Excel
Number of built-in functions in Excel
Over 400
ROUND function syntax
ROUND function syntax
=ROUND(number, num_digits)
ROUND precision: positive, zero, negative
ROUND precision: positive, zero, negative
Decimal places, whole number, tens/hundreds/thousands
Rounding vs formatting in Excel
Rounding vs formatting in Excel
Rounding changes value; formatting changes display only
COUNT function purpose
COUNT function purpose
Counts cells containing numerical values only
COUNTA function purpose
COUNTA function purpose
Counts cells with any information (numbers, text, formulas)
SMALL and LARGE functions purpose
SMALL and LARGE functions purpose
Find nth smallest or nth largest value in a range