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

Excel Lesson 8 Flashcards

AB
Absolute Cell ReferenceA cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5.
AverageA function that adds the values of the cells in a range and divides the result by the number of cells in the range.
CellIndividual locations on a spreadsheet. The intersection of a row and column.
Cell ReferenceThe column letter and row number used to identify a cell, such as B3.
ColumnAppear vertically in a worksheet and are identified by letters at the top of the worksheet window.
CountA function that will return the number of cells in a range that contain values.
EmbeddingUsed to integrate spreadsheet data with other software applications when you do not want the target data to update when the spreadsheet data is edited.
Fill SeriesUsed to fill a row or column with consecutive data, such as the days of the week, months, etc.
FormulaInstructs the software to perform a calculation.
LabelCell data classification used for cells that contain text or for numbers that will not be used in calculations.
LinkingUsed to integrate spreadsheet data with other software applications when you want the target data to update anytime the spreadsheet data is edited.
MaxA function that displays the maximum value in a range of cells.
MinA function that displays the smallest value in a range of cells.
Order of OperationsThe order in which calculations will be performed by the software.
ParenthesesUsed to control the order of operations that will be performed by the software.
Relative Cell ReferenceA cell reference that when copied reflects the row or column it has been copied to.
RowAppear horizontally in a worksheet and are identified by numbers on the left side of the worksheet window.
SpreadsheetAn arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical format.
SumA function that adds the values in a range of cells.
ValueCell data classification used for cells that contain data that has potential to be used in calculations.
WorkbookA file which contains one or more spreadsheets.


Teacher
North Forsyth High School
Cumming, GA

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