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

Excel Terms

AB
absolute referncesformulas that contain cell references that will not change because dollar signs have been used with the cell name
argumentused by a function to perform a set of calculations
AVERAGEfunction that adds the values of the cells in a range and divides the result by the number of cells in the range
bar chartdata graphed as a series of vertical bars
cellwhere a row and column intersect, identified by its column letter and row number
cell referencethe column letter and row number used to identify a cell
charta graphical representation of data stored in a spreadsheet
columnvertical line of data identified by a letter
column chartdata graphed as a series of horizontal bars
COUNTfunction that counts all thenon-blank cells in a range
fill handleused to copy the cell's contents to adjacent cells
formulamathematical statement used to calculate values
functionsused in formulas to perform common calculations
labelwords or characters stored in a cell that cannot be used in calculations
legendcontains labels that identify the series in a chart
line chartdata graphed using a continuous line
mathematical operatorsexamples are +, *, -, /
MAXfunction that displays the largest value in a range of cells
MINfunction that displays the smalles value in a range of cells
numeric labela number that will not be used in calculations, example is social security number
pie chartdata graphed as segments of a circular pie
rangepartial row or column of adjacent cells
relative referenceexcel automatically changes the cell references of a copied formula to apply to the new row or column
rowhorizontal line of data identifed by a number
spreadsheetrows and columns of data on which calculations can be performed
SUMfunction that adds the vlues in a range of cells
valuesnumeric data that can be stored in cells and used in calculations
workbookthe name given to a spreadsheet by Excel

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