BIM - Excel 3-7

An instruction excel uses to calculate a result

• order of precedence

• formula

• arithmetic operation

• sum function

A built-in calculation used to add a range of values together

• order of precedence

• formula

• arithmetic operation

• sum function

A block of cells in an Excel worksheet

• range

• noncontiguous range

• collapse dialog button

• group

A block of adjacent cells (next to each other) in a worksheet

• range

• contiguous range

• noncontiguous range

• group

Cells in a worksheet that act as a block, but are not necessarily adjacent to each other

• range

• contiguous range

• noncontiguous range

• group

The feature that enables Excel to create a series automatically or expand columns and rows

• auto fill

• fill handle

• series

• wrap text

A green box on the lower-right corner of the selected cell or range that you can use to fill (copy) a series or formula

• auto fill

• fill handle

• series

• wrap text

A list of sequential numbers, dates, times, or text

• auto fill

• fill handle

• series

• wrap text

A feature that causes long cell entries to appear on multiple lines

• auto fill

• fill handle

• series

• wrap text

A style that displays dollars signs ($) immediately preceding the number and includes a thousands separator (,)

• comma format

• currency format

• number format

• percent format