Downloaded 10 times
Uploaded byFrya Lora
PPTX, PDF332 views
Functions and formulas
This document discusses formulas and functions in Excel. It defines formulas as mathematical expressions that perform calculations using values, cell references, and operators. Functions are predefined Excel formulas that can quickly perform common tasks like summing or averaging ranges of cells. Examples of commonly used functions include SUM, AVERAGE, MAX, MIN, and COUNT. The document also distinguishes between contiguous and non-contiguous cell ranges and identifies common symbols used in formulas like exponents, parentheses, multiplication, and more.
More Related Content
What's hot
Viewers also liked
Similar to Functions and formulas
More from Frya Lora
Functions and formulas
- 1.
- 2. FORMULA • Is amathematical expression which consists of a series of values, cell references, and mathematical operators that results in a calculation. FUNCTIONS • Built-in formulas in Excel that you can use as a quick way of performing a task that would usually take more time if a formula were used.
- 3.
- 4. COMMONLY USED EXCELFUNCTIONS ∑ Function name Description Syntax SUM Displays the sum of the range =SUM(range) AVERAGE Displays the average value of the range =AVERAGE(range) MAX Determines the LARGEST value in the range =MAX(range) MIN Determines the SMALLEST value in the range =MIN(range) COUNT Calculates the number of values in the range =COUNT(range)
- 5. RANGE CONTIGUOUS RANGE • Range ofadjacent cells NON-CONTIGUOUS RANGE • Range of non-adjacent cells
- 6. DEX IN FORMULAS& FUNCTIONS
- 7. IDENTIFY THE SYMBOLSBELOW 1.: 2.( ) 3.^ 4.*
- 8. Thank you. • Thatwould be all for today.