Spreadsheet
A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and you can insert formulas that manipulate the data. For example, there is an icon that has a formula to add numbers. This icon is called auto sum. Information can also be sorted, filtered and graphed.
We will be using Microsoft Excel.
Spreadsheet Terminology
Active cell: An active is the cell you are currently working on
Auto Sum: A formula that will add up a column of numbers
Cell: Each individual box on the spreadsheet
Cell Reference: The column letter and the row number of a cell
Column: The vertical division of a spreadsheet
Fill: Use the paint bucket tool to fill a cell with colour
Formula: A formula must always starts with “=” signs and what the calculations for each cell
Graph: A visual representation of data
Grid Lines: The horizontal and vertical lines on the spreadsheet
Row: The horizontal division on the spreadsheet
Selecting: To highlight a set of cells
Sheet: One page of a worksheet
Sheet tabs: Tabs that identify the worksheets in a workbook
Spreadsheets: A grid that organizes data
Value: A number that can be entered into a cell
Workbook: Many worksheets
Worksheet: One page of a spreadsheet
A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and you can insert formulas that manipulate the data. For example, there is an icon that has a formula to add numbers. This icon is called auto sum. Information can also be sorted, filtered and graphed.
We will be using Microsoft Excel.
Spreadsheet Terminology
Active cell: An active is the cell you are currently working on
Auto Sum: A formula that will add up a column of numbers
Cell: Each individual box on the spreadsheet
Cell Reference: The column letter and the row number of a cell
Column: The vertical division of a spreadsheet
Fill: Use the paint bucket tool to fill a cell with colour
Formula: A formula must always starts with “=” signs and what the calculations for each cell
Graph: A visual representation of data
Grid Lines: The horizontal and vertical lines on the spreadsheet
Row: The horizontal division on the spreadsheet
Selecting: To highlight a set of cells
Sheet: One page of a worksheet
Sheet tabs: Tabs that identify the worksheets in a workbook
Spreadsheets: A grid that organizes data
Value: A number that can be entered into a cell
Workbook: Many worksheets
Worksheet: One page of a spreadsheet