Excel Module 2

Rules that determine the order in which operations are performed within a formula containing more than one arithmetic operation.

• Auto Fill

• Complex Formula

• Functions

• Order of Precedence

A formula that uses more than one arithmetic operator.

• Functions

• Mixed Reference

• Complex Formula

• Absolute Cell Reference

A cell address that refers to a specific cell and does not change when you copy the formula; indicated by a dollar sign before the column letter and/or row number.

• Function

• Mixed Cell Reference

• Absolute Cell Reference

• Relative Cell Reference

A cell address that refers to a cell's location in relation to the cell containing the formula and that automatically changes to reflect the new location when the formula is copied or moved.

• Function

• Mixed cell reference

• Absolute cell reference

• Relative cell reference

Button that appears after using the fill handle to copy cell contents

• Auto Fill Option Button

• Paste Options Button

• Formula Auto Complete

• Auto Fill

A special, predefined formula that provides a shortcut for a commonly used or complex calculations, such as SUM or FV

• Functions

• Auto Fill

• Formula AutoComplete

• Clipboard

A feature that automatically suggests text to insert.

• Auto Fill

• Formula AutoComplete

• Paste Options Button

• Mixed reference

A temporary Window storage area that holds the selections you copy or cut.

• Auto Fill

• Paste Options Button

• Clipboard

• Mixed Reference

Cell reference that combines both absolute and relative cell addressing.

• Relative

• Absolute

• Mixed Reference

Button that appears onscreen after pasting content

• Paste options button

• Auto Fill Options Button

• Auto