Shared Flashcard Set

Details

Preparing an Excel Workbook
Terms
22
Business
12th Grade
01/07/2010

Additional Business Flashcards

 


 

Cards

Term
WORKBOOK
Definition
A FILE CREATED IN EXCEL; CONSISTS OF INDIVIDUAL WORKSHEETS.
Term
WORKSHEET AREA
Definition
AREA CONTAINING THE GRIDLINES IN THE EXCEL WINDOW
Term
GRIDLINES
Definition
THE HORIZONTAL AND VERTICAL LINES THAT DEFINE THE CELLS IN THE WORKSHEET AREA.
Term
CELL REFERENCE ( ADDRESS)
Definition
INCLUDES THE COLUMN LETTER AND ROW NUMBER.
Term
NAME BOX
Definition
A THICK BLACK BORDER SURROUNDING TEH ACTIVE CELL.
Term
CTRL + G
Definition
KEYBOARD SHORTCUT TO DISPLAY THE GO-TO DIALOG BOX.
Term
###
Definition
NUMBER IS TOO LONG TO FIT IN THE CELL AND DISPLAYS AS NUMBER SYMBOLS.
Term
CELL POINTER
Definition
MOUSE POINTER WHICH DISPLAYS AS A WHITE PLUS SIGN
Term
WORKBOOK FILE NAME
Definition
CONTAINS UP TO 255 CHARACTERS
Term
ENTER TAB ( SHIFT + TAB)
Definition
CHANGE OUT OF THE EDIT MODE.
Term
CANCEL BUTTON
Definition
DELETES THE CURRENT CELL ENTRY.
Term
ENTER BUTTON
Definition
INDICATES THAT YOU ARE FINISHED TYPING OR EDITING THE CELL ENTRY.
Term
AutoComplete
Definition
AUTOMATICALLY INSERTS DATA IN A CELL TAHT BEGINS THE SAME AS A PREVIOUS ENTRY.
Term
AutoCorrect
Definition
AUTOMATICALLY CORRECTS MANY COMMOM TYPOGRAPHICAL ERRORS
Term
AutoFill
Definition
AUTOMATICALLY INSERTS WORDS, NUMBERS, OR FORMULAS IN A SERIES.
Term
FILL HANDLE
Definition
BLACK SQUARE WITH WHICH YOU CAN QUICKLY FILL A RANGE OF CELLS WITH THE SAME DATA OR WITH CONSECUTIVE DATA.
Term
INCREMENT A SERIES
Definition
HOLD DOWN CTRL KEY WHILE DRAGGING THE FILL HANDLE.
Term
ALT + =
Definition
USED TO INSERT TEH SUM FUNCTION IN THE CELL.
Term
RELATIVE CELL REFERENCE
Definition
INSERT THE SAME BASIC FORMULA IN OTHER CELLS AND THE CELL REFERENCE CHANGE.
Term
HOLD DOWN CTRL KEY WHILE SELECTING CELLS.
Definition
SELECT NONADJACENT COLUMNS OR ROWS.
Term

FIRST CELL IN A RANGE

Definition

DISPLAYS WITH A WHITE BACKGROUND AND IS THE ACTIVE CELL.

Term
F8
Definition
TURNS ON THE EXTEND SELECTION MODE, MOVE THE INSERTION POINT TO THE DESIRED DIRECTION TO SELECT THE DATA.
Supporting users have an ad free experience!