[go: up one dir, main page]
Scribd
Upload
25 views3 pages

Grade 12 Spreadsheet Functions

The document outlines various spreadsheet functions suitable for Grade 12 students, categorized into Basic Arithmetic, Conditional, Text, Lookup and Reference, Date and Time, Mathematical, Financial, and Statistical functions. Each category includes specific functions along with their descriptions and usage. This serves as a comprehensive guide for students to utilize spreadsheet capabilities effectively.

Uploaded by

khothatsomakgae07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views3 pages

Grade 12 Spreadsheet Functions

The document outlines various spreadsheet functions suitable for Grade 12 students, categorized into Basic Arithmetic, Conditional, Text, Lookup and Reference, Date and Time, Mathematical, Financial, and Statistical functions. Each category includes specific functions along with their descriptions and usage. This serves as a comprehensive guide for students to utilize spreadsheet capabilities effectively.

Uploaded by

khothatsomakgae07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Spreadsheet Functions for Grade 12

1. Basic Arithmetic Functions:

- =SUM(range): Adds all numbers in the specified range.

- =AVERAGE(range): Calculates the average of the numbers.

- =MIN(range): Finds the smallest number.

- =MAX(range): Finds the largest number.

- =COUNT(range): Counts the number of numeric cells.

- =COUNTA(range): Counts non-empty cells.

2. Conditional Functions:

- =IF(condition, value_if_true, value_if_false): Returns one value if true, another if false.

- =IFERROR(value, value_if_error): Handles errors in formulas.

- =COUNTIF(range, criteria): Counts cells meeting a condition.

- =SUMIF(range, criteria, [sum_range]): Sums values meeting a condition.

- =AVERAGEIF(range, criteria, [average_range]): Averages values meeting a condition.

3. Text Functions:

- =CONCATENATE(text1, text2, ...): Combines text.

- =LEFT(text, number): Gets characters from the start.

- =RIGHT(text, number): Gets characters from the end.

- =MID(text, start, number): Gets characters from the middle.

- =LEN(text): Counts characters.

- =TRIM(text): Removes extra spaces.

- =UPPER(text): Converts to uppercase.


- =LOWER(text): Converts to lowercase.

- =PROPER(text): Capitalizes first letters.

4. Lookup and Reference Functions:

- =VLOOKUP(value, table, column, [approximate]): Vertical lookup.

- =HLOOKUP(value, table, row, [approximate]): Horizontal lookup.

- =INDEX(array, row, [column]): Finds value by row/column.

- =MATCH(value, array, [match_type]): Finds position.

- =OFFSET(reference, rows, cols, [height], [width]): Dynamic referencing.

5. Date and Time Functions:

- =TODAY(): Current date.

- =NOW(): Current date and time.

- =DATE(year, month, day): Creates a date.

- =DATEDIF(start, end, unit): Date difference.

- =YEAR(date), =MONTH(date), =DAY(date): Extract date parts.

- =WEEKDAY(date, [type]): Returns day of the week.

6. Mathematical Functions:

- =ROUND(number, digits): Rounds number.

- =ROUNDUP(), =ROUNDDOWN(): Round directionally.

- =POWER(number, power): Exponentiation.

- =SQRT(number): Square root.

- =PI(): Pi constant.

- =RAND(): Random number (0-1).

- =RANDBETWEEN(bottom, top): Random number in range.


7. Financial Functions:

- =PMT(rate, nper, pv, [fv], [type]): Loan payment.

- =FV(rate, nper, pmt, [pv], [type]): Future value.

8. Statistical Functions:

- =MEDIAN(range): Middle value.

- =MODE(range): Most frequent value.

- =STDEV(range): Standard deviation.

- =VAR(range): Variance.

You might also like