TLE MS Excel

Shows the contents of the active cell and can be used to edit it

• Formula bar

• Sheet box

• Row heading

• Active cell

Horizontal bars on top of the worksheet. They are labeled with letters from A to XFD.

• Column heading

• Sheet tabs

• Row heading

• Active cell

Components of MS Excel that contains the names of the available worksheets in the workbook.

• Sheet tabs

• Row heading

• Active cell

• Name box

Vertical bars at the left side of the worksheet. They are labeled number from 1 to 1048576.

• Row heading

• Column heading

• Formula bar

• Active cell

Auto Sum function used to compute the total of all items in the specified range

• =Sum(range)

• =Average(range)

• =Count(range)

• =Max(range)

Auto Sum function used to count the values found in the range

• =Sum(range)

• =Average(range)

• =Count(range)

• =Max(range)

Auto Sum function used to get the average of the items in a range

• =Sum(range)

• =Average(range)

• =Count(range)

• =Max(range)

Auto Sum function used to get the largest value within the range

• =Sum(range)

• =Average(range)

• =Count(range)

• =Max(range)

Auto Sum function used to get the smallest value within the range

• =Sum(range)

• =Average(range)

• =Min(range)

• =Max(range)

A widely used spreadsheet program.

• Microsoft Excel

• Open office Calc

• Lotus 1-2-3

• Quattro Pro