Mastering Excel Formulas and Functions

SUM

AVERAGE

COUNT

MAX

To change the font of the text

To apply different formats to cells based on specific conditions

To sort data in ascending order

To create a chart

It checks if A1 is less than 10 and returns "High" if true, otherwise "Low"

It checks if A1 is greater than 10 and returns "High" if true, otherwise "Low"

It checks if A1 is equal to 10 and returns "High" if true, otherwise "Low"

It checks if A1 is not equal to 10 and returns "High" if true, otherwise "Low"

10

8

15

5

It checks if B2 is "No" and returns "Approved" if true, otherwise "Denied"

It checks if B2 is "Yes" and returns "Approved" if true, otherwise "Denied"

It checks if B2 is "Yes" and returns "Denied" if true, otherwise "Approved"

It checks if B2 is "No" and returns "Denied" if true, otherwise "Approved"

$$A$$ 1

A$1

$A1

A1