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

Excel Review Questions

AB
CellThe name of the box formed by the intersection of a row and a column.
Active cellThe name of the area within a worksheet that is selected, or ready to receive information
<F5>The <GoTo> key
ValuesAre used in calculations
Numeric LabelsUsed for descriptive headings such as social security numbers, telephone numbers
LabelsSimple text
####Cell is too small for value
<Ctrl><Home>Moves cursor to cell A1
FormulaAn instruction to calculate a number
Formula barFormula appears in the cell and in this area
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
COUNTCounts all the non-blank cells in a range
COUNTACounts labels or numeric labels
AVERAGEAverages values in a range of cells
MIN, MAX, SUM, AVERAGESamples of functions
RangeA defined area of the worksheet such as A1:H20
<F2>The edit key
$C$20Absolute reference, a cell that does not change
<F2>Edit key
Numeric LabelsDOB, SS #, Telephone Numbers

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