Quia Home Home FAQ About Log in Subscribe now 30-day free trial
Java Games: Matching, concentration, word search, and flashcards.

SPREADSHEET VOCABULARY TERMS

Computer Skills - Activities/Resources
Day 6 of 20
(Vicki McKenzie)


AB
DATADistinct pieces of information, usually formatted in a special way -- variety of forms -- as numbers or text
CELLIn spreadsheet applications, this is a box in which you can enter a single piece of data. The data is usually text, a numeric value, or a formula. Each has its own address, such as B3.
COLUMNa vertical line of characters extending from the top to the bottom of the screen.
ROWa horizontal line of characters extending from the top to the bottom of the screen.
VALUENumerical data
LABELIn spreadsheet programs, it is any descriptive text placed in a cell.
MEDIANThe middle number of a group of numbers; that is, half the numbers have values that are greater than this, and half the numbers have values that are less than this. For example, 4 is this for the following numbers. 2, 3, 3, 5, 7,10.
GRAPH/CHARTA picture created from a set of numbers. They can help you recognize trends that are not obvious in a simple list of numbers. Popular types include line, bar, area, and pie.
FORMULAan expression/equation that defines how one cell relates to other cells =A4*D7
FUNCTIONcalculation that reuse frequently repeated complex worksheet formulas
OPERATORS+, (add), -, (subtract), / (divide), * (multiply)
AVERAGEThe arithmetic mean; It is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
RANGEThe labels of columns and rows on a worksheet which refer to the cells within those columns and rows
CELL REFERENCEThe location of a cell in a spreadsheet. This address consists of a column letter (A) followed by a row number (1). Together they make A1.