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