MGT 2180 Module 2 (Excel) Chapter 2 matching
Links worksheets
3D cell reference
range name
A label assigned to a single cell or group of cells
ROUND
An Excel function that controls how many decimal places display for a values
Evaluate Formula
Button that starts a review of each part of a formula to determine errors
Trace Precedents
Buttons that shows all cells referenced in the active cell's formula
F2
Enables the current cell's edit mode
COUNT
Tallies the number of cells in a range
AutoSum
This button opens a list of commonly used statistical functions
Formula
Uses common arithmetic operations to perform calculations
AVERAGE
a built-in function that calculates the arithmetic mean of a range of cells