Excel Flashcards
What does this symbol mean? +
addition
What does this symbol mean? -
subtraction
What does this symbol mean? *
Multiplication
What does this symbol mean? /
Division
What does this symbol mean? ^
Exponents
All formulas in Excel must begin with an…
equals sign (=)
What are absolute references?
they do not change when copied or filled
What does $A$2 mean?
The column and row do not change when copied
What does A$2 mean?
The row does not change when copied
What does $A2 mean?
The column does not change when copied
SUM
adds all of the values of the cells in the argument
AVERAGE
determines the average of the values included in the argument.
COUNT
counts the number of cells with numerical data in the argument.
MAX
determines the highest cell value included in the argument.
MIN
determines the lowest cell value included in the argument.
