IT SBA OUTLINE
SPREADSHEETS
Microsoft Excel
An electronic spreadsheet is a program which organizes information into rows and columns so that is can be operated on easily. It enables you to store numbers and formulae to carry out operations on the numerical data.
Terms to Know
Row – Rows run horizontally in an Excel worksheet. They are identified by a number in the row header.
Column- Columns run vertically in a worksheet.
Each column is identified by a letter in the column header starting with Column A and running through to Column XFD.
Cell In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as a cell. The intersection point between a column and a row is a cell.
Cell Address- A cell address in a spreadsheet, such as Excel, identifies the location of the cell in the spreadsheet. A cell address is a combination of column letter and row number of a cell, such as C4 or D8.
Workbook- A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.
Worksheet- A worksheet is a single page or sheet in a spreadsheet program such as Excel.
Range- A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border.
Relative Cell Addressing- In spreadsheet programs such as Lotus 1-2-3, a relative cell address identifies the location of a cell or group of cells.
Cell addresses are used in formulas, functions, charts , and other spreadsheet commands.
By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.
In contrast, an absolute cell address does not change when a formula is copied and pasted to other cells. A relative cell address consists of the column letter and row number that intersect at the cell's
Microsoft Excel
An electronic spreadsheet is a program which organizes information into rows and columns so that is can be operated on easily. It enables you to store numbers and formulae to carry out operations on the numerical data.
Terms to Know
Row – Rows run horizontally in an Excel worksheet. They are identified by a number in the row header.
Column- Columns run vertically in a worksheet.
Each column is identified by a letter in the column header starting with Column A and running through to Column XFD.
Cell In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as a cell. The intersection point between a column and a row is a cell.
Cell Address- A cell address in a spreadsheet, such as Excel, identifies the location of the cell in the spreadsheet. A cell address is a combination of column letter and row number of a cell, such as C4 or D8.
Workbook- A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.
Worksheet- A worksheet is a single page or sheet in a spreadsheet program such as Excel.
Range- A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border.
Relative Cell Addressing- In spreadsheet programs such as Lotus 1-2-3, a relative cell address identifies the location of a cell or group of cells.
Cell addresses are used in formulas, functions, charts , and other spreadsheet commands.
By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.
In contrast, an absolute cell address does not change when a formula is copied and pasted to other cells. A relative cell address consists of the column letter and row number that intersect at the cell's