click below
click below
Normal Size Small Size show me how
Excel Vocab
Excel Lesson 1 Vocab
Question | Answer |
---|---|
WORKBOOK | AN EXCEL FILE WITH ONE OF MORE WORKSHEET. |
WORKSHEET | THE WORK AREA FOR ENTERING AND CALCULATING DATA MADE UP OF COLUMNS AND ROWS SEPARATED BY GRIDLINES (LIGHT GRAY LINES). ALSO CALLED SPREADSHEET. |
CELL | THE INTERSECTION OF A COLUMN AND A ROW ON A WORKSHEET. YOU ENTER DATA INTO THESE TO CREATE A WORKSHEET. |
ACTIVE CELL | THE ACTIVE CELL CONTAINS THE CELL POINTER. THERE IS A DARK OUTLINE AROUND THE ACTIVE CELL. |
FORMULA BAR | AS YOU ENTER DATA INTO A CELL, IT SIMULTANEOUSLY APPEARS IN THE FORMULA BAR, WHICH IS LOCATED ABOVE THE WORKSHEET. |
CELL REFERENCE | THE LOCATION OF A CELL IN A WORKSHEET AS IDENTIFIED BY ITS COLUMN LETTER AND ROW NUMBER. ALSO KNOWN AS THE CELL'S ADDRESS. |
SCROLL | A WAY TO VIEW LOCATIONS ON THE WORKSHEET WITHOUT CHANGING THE ACTIVE CELL. |
SHEET TABS | TABS THAT APPEAR AT THE BOTTOM OF THE WORKBOOK WINDOW, WHICH DISPLAY THE NAME OF EACH WORKSHEET. |
TAB SCROLLING BUTTONS | BUTTONS THAT APPEAR JUST TO THE LEFT OF THE SHEET TABS, WHICH ALLOW YOU TO SCROLL HIDDEN TABS INTO VIEW. |
BLANK WORKBOOK | A NEW EMPTY WORKBOOK CONTAINS THREE WORKSHEETS. |
TEMPLATE | A WORKBOOK WITH CERTAIN LABELS, FORMULAS, AND FORMATTING PRESET, SAVING YOU TIME IN CREATING COMMONLY USED WORKSHEEETS, SUCH AS MONTHLY INVOICES OR BALANCE SHEETS. |
LABEL | TEXT IN THE FIRST ROW OR COLUMN OF A WORKSHEET THAT IDENTIFIES THE TYPE OF DATA CONTAINED THERE. |
DEFAULTS | THE STANDARD SETTINGS EXCEL USES IN ITS SOFTWARE, SUCH AS COLUMN WIDTH OR NUMBER OF WORKSHEETS IN A WORKBOOK. |
UNDO | THE COMMAND USED TO REVERSE ONE OF A SERIES OF EDITING ACTIONS. |
REDO | THE COMMAND USED TO REDO AN ACTION YOU HAVE UNDONE. |
AUTOCOMPLETE | A FEATURE USED TO COMPLETE AN ENTRY BASED ON PREVIOUS ENTRIES MADE IN THE COLUMN CONTAINING THE ACTIVE CELL. |
PICK FROM DROP-DOWN LIST | A SHORTCUT USED TO INSERT REPEATED INFORMATION. |
AUTOCORRECT | A FEATURE USED TO AUTOMATE THE CORRECTION OF COMMON TYPING ERRORS. |
SPELLING CHECKER | A TOOL USED TO ASSIST YOU IN FINDING AND CORRECTING TYPOGRAPHICAL OR SPELLING ERRORS. |