Advertisement Upgrade to remove ads

cell

a rectangle in Microsoft Powerpoint

active cell

cell with black border around it

workbook

an Excel file

worksheets/sheets

a workbook can hold an unlimited amount of these

text values

words, names, numbers, addresses, or any combination of letters or numbers

labels

text values used as a column or row heading

numerical values

a number with +, -, (, ), and %

auto fill

remembers things you have entered in the past and will immediately fill in a cell so you do not need to type as much

fill handle

appears as a little black square in the bottom right corner of the active cell

formula

a mathematical expression

arithmetic operators

add (+), subtract (-), multiply (*), and divide (/)

exponent

(^) operator

order of operations

1. exponential calculations, 2. multiplication and division operations, 3. addition and subtraction operations, 4. calculations are completed from left to right, 5. all operations inside parentheses are completed first before completing othr operations

cell references

the key to solving a problem with many numbers to add, subtract, multiply, and divide

functions

similarly to formulas, are always preceded by an equals sign (=)

sum function

add the numerical values in selected cells

count function

count how many cells have numerical values

average function

find the average of numerical values in selected cells

min function

find the lowest or minimum number in selected cells

max function

find the highest or maximum number in selected cells

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set