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

Excel Practice Final

AB
Active CellHighlighted worksheet cell ready for data entry
CellMeeting point of a row and column
ColumnsAppear vertically in a worksheet; identified by letters
Formula barShows the data that is being entered in the active cell; displays a formula
HighlightEntry point of a worksheet indicated by a dark border around a cell
Name boxShows the active cell
RangeSelected group of cells
RowsAppear horizontally in a worksheet; identified by numbers
SpreadsheetA grid of rows and columns that holds numbers, words, and formulas used to solve problems that involve numbers
WorkbookA collection of related worksheets
WorksheetA computerized spreadsheet
BorderA line that is placed around text for emphasis or decoration
Cell formatThe way data is shown in a cell
CurrencyA format that displays numerical data preceded by a dollar sign
Absolute cell reference$A$3
Cell referenceIdentifies a worksheet cell by the column letter and row number
FormulasEquations that calculate a new value from values currently on a worksheet
OperandNumbers or cell references used in calculations in the formulas
OperatorTells Excel what to do with operands in a formula
Order of OperationsSequence used to calculate the value of a formula
Relative cell referenceCell reference that adusts to a new location when copied or moved
FillingCopies data into the cells adjacent to the original
FreezingKeeps row or column titles on the screen when scrolling
ChartGraphical representation of data in a worksheet
Chart sheetA separate sheet in a workbook where you create and store a chart
Column ChartUses bars of varying heights to illustrate values in worksheets
Embedded chartA chart created within a worksheet; can be viewed at same time as data
Line chartSimilar to column char except uses points connected to lines
Pie chartShows relationship of part to a whole
Cell alignment buttonsAlign left, right, center, merge and center
Ctrl + `Used to display formulas in a worksheet
Ctrl + HomeUsed to get to cell A1
Protection commandFound in the tools menu
#####Means data is wider than column width
Ctrl keyUsed to copy data using the drag-an-drop method
Merge and CenterCombines several cells into one cell


Business Teacher
Turlock High School

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