Excel Lesson 4: Entering Worksheet Formulas

10 terms by stprice 

Create a new folder

Advertisement Upgrade to remove ads

Absolute cell reference

Does not change when copied or moved to a new cell.

Formula

The equation used to calculate values in a cell.

Manual calculation

Lets you determine when Excel calculates the formulas.

Mixed cell reference

Cell references that contain both relative and absolute references.

Operand

A constant (text or number) or cell reference used in a formula.

Operator

A symbol that indicates the type of calculation to perform on operands.

Order of evaluation

The sequence used to calculate the value of a formula.

Point-and-click method

Allows you to point and click each cell in a formula rather than typing
cell references.

Relative cell reference

Adjusts to its new location when copied or moved.

Sum button

Makes adding long columns or rows of numbers simple to do.

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