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

Excel 2010 Terms and Features

Review of Excel 2010 Terms and Features

AB
cellsmallest part of a spreadsheet
left aligndefault format of labels
GoTo KeyF5
valuesnumbers, formulas
numeric labelsused for descriptive headings
labelssimple text
truncatelabel too long to fit in a cell
cell is too small#####
Ctrl Homemoves cursor to cell A1 immediately
formulamathematical calucation
formula barformula or cell contents appear here
SUMfunction to add values in a range
MINfunction that indicates the lowest value in a range
Counttotals all the non-blank cells in a range
columnsvertical data
averageformula the finds the average of a range of cells
rowhorizontal data
edit keyF2
absolute reference keyF4
absolute reference$C$20
mixed reference$A10
relative referenceB5
equal signindicates the beginning of a formula
greater than>
less than<
not equal to<>
rangedefined area of cells
argumentrange of cells in a formula
right aligndefault format of values
active cellarea that is current


Business & Computer Teacher
Patoka School
Patoka, IL

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