click below
click below
Normal Size Small Size show me how
Graves Spreadsheet V
Graves Spreadsheet Vocabulary
Question | Answer |
---|---|
An application or program, useful for calculating and relating data. | Spreadsheet |
Used to reference the cells in a spreadsheet. | Address |
Usually made up of column letters along the top and row numbers down the side. | Address |
Information coded into a suitable form for computer input, processing, and output. | Data |
Anything that is a number. | Numeric |
Text in a cell. Cannot be calculated, just sorted. | Label |
A calculation entered by the user for the data in the spreadsheet. e.g. =(A6+A7)-A5 | Formula |
Make it easier to put sophisticated calculations into the worksheet and make the long, laborious calculations quick and accurate. e.g. =SUM (C6:C12) | Function |
A numerical result of a formula or function. | Value |
A place where you can enter data in a spreadsheet. | Cell |
The intersection of a row and column. | Cell |
Two cell references usually separated by a colon. (A23:C42) | Cell Range |
Horizontal cells on a spreadsheet (in one line). | Row |
Vertical cells on a spreadsheet (in one line). | Column |
To define the visual appearance of the value of a cell, block, row, column, or the entire spreadsheet. | Format |
To place the information in the order you want it to be. | Sort |
A diagrammatic representation of data. | Graph |
A form of graph which represents numeric values as segments of a circle. | Pie Chart |
A form of graph in which numeric values are represented by horizontal or vertical rectangles. | Bar Chart |
An axis-type graph in which data points are joined by a line. | Line Graph |
To eliminate items of data from analysis based on one or more criteria | Filter |
In order from small numbers to larger numbers, or from a to z (alphabetical) | Ascending Order |
In order from large numbers to smaller numbers, or from z to a (reverse alphabetical) | Descending Order |