Excel Formulas and Functions


Excel Formulas and FunctionsOnline version Important words it remember in Excel by Rose Jennings 1 Data Tab 2 Excel Valid Formulas 3 Functions Syntax 4 FORMULA TAB 5 FORMAT menu 6 Excel mathematical operations 7 NOT Valid Formulas Sort Filter A --> Z Z --> A =B5 + B6 =B4^2 =SUM(B3:B8) =COUNT(C3:C9) =MAX(D3:D10) AVERAGE COUNT MIN MAX DATE row height column width cell borders cell alignment + * ^ b4 -b2^3 h3*g3

Excel Formulas and FunctionsOnline version

Important words it remember in Excel

Sort

Filter

A --> Z

Z --> A

=B5 + B6

=B4^2

=SUM(B3:B8)

=COUNT(C3:C9)

=MAX(D3:D10)

AVERAGE

COUNT

MIN

MAX

DATE

row height

column width

cell borders

cell alignment

b4 -b2^3

h3*g3