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

EXCEL--Lesson 1 and 2 Review

Microsoft Office 2000 Introductory Course

Lesson 1--EXCEL Basics
Lesson 2--Changing the Appearance of a Worksheet

AB
Spreadsheet/Worksheetgrid of rows and columns containing numbers, text, and formulas
Columnsappear vertically and are identified by letters at the top of the worksheet
Rowsappear horizontally and are identified by numbers on the left side of the worksheet
Cellthe intersection of a row and a column, for example C4
Active Cellcell that contains the highlight
Formula Barappears below the formatting toolbar and diplays the name box showing the active cell
IVthe last column
65,536the last row
Ctrl + Homeused to move quickly to cell A1
F5the Go To function key
Rangea selected group of cells forming a rectangle
Textalphabetical characters such as headings and labels
Numbersvalues, dates, or times
Formulasequations that calculate a value
F2Edit function key
Workbookcollection of related worksheets
Zoommagnify or reduce the view of the worksheet
Deleteused to clear data from an active cell
Ctrl + Endmove to the last cell containing data
###########display that indicates the column is not wide enough to display the data
Double-Click the Right Edge of the Column HeadingEZ method to automatically find the best fit for the column width
Format, Column, Widthsteps to change the column width
Wrapped Textbegins a new line within the cell
Rotated Textdisplays text at an angle
Indented Textmoves the text several spaces to the right
Merge and Centermerges multiple cells into one cell and places the text in the middle of the merged cells
Format, Cells, Alignment, Wrap Textsteps to wrap text
Format, Cells, Alignment, Rotate Textsteps to rotate text
Font Stylesbold, italicize, underline
Fill Colorchanges the background color of a cell
Font Colorchanges the color of the text
Format, Cells, Patternssteps to change color of cell shading
Format, Cells, Bordersteps to add a border
Borders Button on Formatting Toolbarapplies the last border that was used
General Formatdefault format--displays text and numerical data as it is keyed
Edit, Clear, Formatsteps to clear the format--but not the data from a cell
Number Formatdisplays numerical data with a fixed number of places to the right of the decimal (1000.00)
Currency Formatdisplays numerical data preceded by a dollar sign; however, dollar signs and decimal points do not necessarily line up vetically wihin the column ($1,000.00)
Accounting Formatdisplays numerical data with a dollar sign and decimal point that line up vertically within a column
Left Alignmentalignment used to display all numbers in Excel
Text Formatdisplays numerical data that will not be used for calculation, such as serial numbers containing hyphens
ExcelMicrosoft Office 2000 Spreadsheet Application used to solve problems that involve numbers


Kathy Bellott

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