Java Games: Flashcards, matching, concentration, and word search.

Computer Applications I Spreadsheet Vocabulary

Spreadsheet and charting vocabulary terms used in Computer Applications I

AB
Active CellCell ready for data entry
AlignmentEntering data in a cell, the default is: labels to the left; values to the right
CellIntersection of a row and column; identified by a cell reference
Cell RangeSelected group of cells that form a rectangle
Cell ReferenceColumn Letter and row number (Example: D14)
ColumnVertical group of cells named by letters
FormulaEquations with mathematical operators
FunctionPreformatted formulas without mathematical operators; Shortcut formula
LabelText, symbols, dates, or numbers not used in calculations
RowsHorizontal group of cells named by numbers
SpreadsheetProgram using rows and columns of data to manage information
ValueNumber entered into a spreadsheet that will be used for calculations
CopyRepeats formulas or functions across columns or rows
Currency formatFormats cells so that numbers appear as money, with money symbol and specific decimal amounts (Example: $0.00)
Multiply Symbol*
Divide Symbol/
Subtract Symbol-
Add Symbol+
BackspaceDeletes text to the left of the cursor
DeleteDeletes text to the right of the cursor
ChartVisual display of data in a spreadsheet; also known as a graph
Column ChartShows how values change over time; rectangular shapes compare data easily
Data markerObject that represents individual values
Data pointSingle value or piece of data from a data series
Data seriesCollection of related values from a worksheet
Embedded chartAppears on the same sheet as worksheet data
GridlineHorizontal or vertical line that extends across the plot area of a chart to make it easier to read/understand the values
LegendObject that explains symbols, colors, or patterns used to differentiate the series in a chart
Line ChartChart that shows a trend in data over time via linear markings
Pie chartChart that shows only one data series and is used to compare sizes of each part to the whole; percentage
Plot areaRectangular area bound by the category and values axes
Tick markSmall line or marker on the X-axis and Y-axis to help in reading the values
X-axisCategory axis that describes what is shown in the chart
XY ChartChart that is also known as a scatter chart and is used to show relationships between multiple values
Y-axisValue axis; also shows the range of values (or scale) of the chart


Cox Mill High School
Concord, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities