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. |