The first step of learning about spreadsheets is understanding the terminology you will encounter as you work through this lesson. The glossary below lists terms that are specific to spreadsheet applications. Terminology that we learned when we looked at wordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet application
1.Absolute Cell Reference: An absolute cell reference is one that does not change when it is copied. To make a cell reference absolute, you must include a $ before the reference.The other type of reference is a Relative Reference..
2.Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard. The current active cell can be identified as being the one that has a darker black border around it. Also, the active cell reference is listed in the Name Box directly above the spreadsheet's column headings.
3.Anchor Cell: The anchor cell is the first cell that is highlighted in a range. When a range of cells is selected, they appear as highlighted in black. The anchor cell, however, remains white. If only one cell is selected in the sheet, it is the anchor cell.
4.Bar / Column Chart: A bar or column chart is a style of chart that is used to summarize and compare categorical data. The length of each bar represents the aggregate value (ex: sum) of that particular category. Bars run horizontally and columns run vertically.
5.Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3. Cells may contain Labels, Numbers, Formulas or Functions.
Answers & Comments
Answer:
The first step of learning about spreadsheets is understanding the terminology you will encounter as you work through this lesson. The glossary below lists terms that are specific to spreadsheet applications. Terminology that we learned when we looked at wordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet application
1.Absolute Cell Reference: An absolute cell reference is one that does not change when it is copied. To make a cell reference absolute, you must include a $ before the reference.The other type of reference is a Relative Reference..
2.Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard. The current active cell can be identified as being the one that has a darker black border around it. Also, the active cell reference is listed in the Name Box directly above the spreadsheet's column headings.
3.Anchor Cell: The anchor cell is the first cell that is highlighted in a range. When a range of cells is selected, they appear as highlighted in black. The anchor cell, however, remains white. If only one cell is selected in the sheet, it is the anchor cell.
4.Bar / Column Chart: A bar or column chart is a style of chart that is used to summarize and compare categorical data. The length of each bar represents the aggregate value (ex: sum) of that particular category. Bars run horizontally and columns run vertically.
5.Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3. Cells may contain Labels, Numbers, Formulas or Functions.