Introduction to Spreadsheet Terminology Parts of the Spreadsheet

Introduction to Spreadsheet Terminology

Parts of the Spreadsheet Window Active cells Column C Row 5

Entering Data into a Spreadsheet Labels – Alphabetical text Values – A number Formulas – Statement that performs a calculation Functions – Built-in formula that is a shortcut for common calculations

Identifying Labels and Values labels values

Identifying Formulas and Functions formula The result of the formula function The result of the function

Identifying Parts of a Spreadsheet Formula mathematical operators =B 2+C 2+D 2 equal sign—first part of any spreadsheet formula cell reference/address— made up of the column heading and the row number

Identifying Parts of a Spreadsheet Function =SUM(B 2: B 6) name of function equal sign range

Mathematical Operators + * / addition subtraction multiplication (asterisk) division (slash or diagonal)

Spreadsheet Functions Function Name AVERAGE COUNT IF MAX MIN ROUND SUM Description Average of arguments. Counts the number of cells in a range. Specifies a logical test to perform; then performs one action if test result in true and another if it is not true. Maximum value of range of cells. Minimum value of range of cells. Rounds a number to a specified number of digits. Totals a range of cells.

Relative and Absolute Referencing Relative – cells that change when they are copied into other cells Absolute – cells that do not change regardless of where it is copied