Defination
What is addition
Plus two or more numbers together
What is 123+321
444
Sum
Sum: =SUM(number1,[number2]…)
Home
Move to column A in a sheet
hei hei
-200
What is Brackets
()
What is 2^6
64
And
=AND( condition1, [condition2], ... )
F2
Edit formulas or cell contents
nothing
+0
What is ^
Indices
7*11-8+7-9*2
58
SumIF
SUMIF( range, criteria, [sum_range] )
F4
Change between absolute, relative or mixed reference in a formula
something good
+1
What is Cell Referencing
The box at the top of the sheet can show the formula in the cell
12345+54327
66672
CountIF
= COUNTIF ( range , criteria )
F9
Recalculate formulas
something bad
-500
What is function
•A function is a special formula that can simplify complex calculations.
SUM（1，2，3，.....10)
FALS
VLOOKUP
=VLOOKUP ( lookup value , table_array , col_index_num , [range_lookup] )
Ctrl+D
Delete everything in the cells your select
the best one