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

Excel Exam Review

AB
CellUnique address of a cell that is the intersection of a column and a row
Active cellThis is the cell that is currently selected and where information will be dislayed
Protect sheetthis options keeps contents in cells from being deleted or changed
worksheetspreadhseet used to enter, calculate, manipulate and analyze data
column headingA column letter above the grid that identifies each column
functionsPre-written formulas used to help compute statistics
colon :used in a function to indicate the word "through" in a range of cells
####Cell is too small for value
xlsExtension given to all Excel files
=all formulas and functions begin with this symbol
FormulaAn instruction to calculate a number
Formula barplace where formulas and fucntions are displayed when they are entered
SUMAdds all values in a range of cells
MINIndicates the lowest value in a range of cells
MAXIndicates the highest value in a range of cells
/division sign
AVERAGEAverages values in a range of cells
>=Greater than or equal to
<=Less than or equal to
=Indicates the beginning of a formula
*multiplication sign
>Greater than
<Less than
MIN, MAX, SUM, AVERAGESamples of functions
RangeA defined area of the worksheet such as A1:H20
Freeeze Panesthis options lets you see column or row headings even when you scroll down the worksheet
gridlinesthe vertical and horizontal lines on the worksheet
legendlets you read the data on a chart
Tab keymoves one cell to the right
Shift+Tab keysmoves one cell to the left


CTE Business Teacher

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