click below
click below
Normal Size Small Size show me how
Excel Vocab
Excel Lesson 2 Vocab
| Question | Answer |
|---|---|
| RANGE | A BLOCK OF CELLS IN AN EXCEL WORKSHEET. |
| CONTIGUOUS RANGE | A BLOCK OF ADJACENT CELLS IN A WORKSHEET. |
| NONCONTIGUOUS RANGE | CELLS IN A WORKSHEET THAT ACT AS A BLOCK, BUT ARE NOT NECESSARILY ADJACENT TO EACH OTHER. |
| FORMAT | TO APPLY ATTRIBUTES TO CELL DATA TO CHANGE THE APPEARANCE OF THE WORKSHEET. |
| THEME | A COLLECTION OF CORRDINATED FONTS, COLORS, AND EFFECTS FOR GRAPHIC ELEMENTS SUCH AS CHARTS AND IMAGES THAT CAN BE QUICKLY APPLIED TO ALL SHEETS IN A WORKBOOK. |
| FONT | THE TYPEFACE OR DESIGN OF THE TEXT. |
| FILL | A COLOR THAT FILLS A CELL, APPEARING BEHIND THE DATA. |
| CELL STYLES | A COMBINATION OF A FONT, TEXT COLOR, CELL COLOR, AND OTHER FONT ATTRIBUTES APPLIED TO A SINGLE CELL. THEY ARE CALL QUICK STYLES IN OTHER OFFICE PROGRAMS. |
| FONT SIZE | THE MEASUREMENT OF THE TYPEFACE IN POINTS (ONE POINT EQUALS 1/72 OF AN INCH) |
| NUMBER FORMAT | A FORMAT THAT CONTROLS HOW NUMERICAL DATA IS DISPLAYED, INCLUDING THE USE OF COMMAS, DOLLAR SIGNS (OR OTHER SYMBOLS), AND THE NUMBER OF DECIMAL PLACES. |
| ACCOUNTING FORMAT | A STYLE THAT VERTICALLY ALIGNS WITH DOLLAR SIGNS ($), THOUSANDS SEPARATORS (,), AND DECIMAL POINTS. |
| PERCENT FORMAT | A STYLE THAT DISPLAYS DECIMAL NUMBERS AS A PERCENTAGE. |
| COMMA FORMAT | A STYLE THAT DISPLAYS NUMBERS WITH A THOUSANDS SEPARATOR (,). |
| CURRENCY FORMAT | A SYTLE THAT DISPLAYS DOLLAR SIGNS ($) IMMEDIATELY PRECEDING THE NUMBER AND INCLUDES A THOUSANDS SEPARATOR(,). |
| CLIPBOARD | A FEATURE OF WINDOWS THAT HOLDS DATA OR GRAPHICS THAT YOU HAVE CUT OR COPIED AND ARE READY TO BE PASTED INTO ANY DOCUMENT. |
| FILL HANDLE | DRAGGING THIS HANDLE, LOCATED IN THE LOWER-RIGHT CORNER OF THE ACTIVE CELL, WILL COPY CELL CONTENTS, FORMATTING, OR A FORMULA TO ADJACENT CELLS. |
| FORMAT PAINTER | A BUTTON ON THE HOME TAB THAT ALLOWS YOU TO COPY FORMATIING FOR A SELCTED OBJECT OR CELL AND APPLY IT TO ANOTHER OBJECT OR CELL. |
| RELATIVE CELL REFERENCE | A CELL ADDRESS EXPRESSED IN RELATION TO THE CELL CONTAINING THE FORMULA. FOR EXAMPLE, RATHER THAN ANMING A SPECIFIC CELL IN A FORMULA, A RELATIVE CELL REFERENCE MIGHT IDENTIFY A CELL THREE COLUMNS TO THE LEFT OF THE CELL CONTAINING THE FORMULA. |
| ABSOLUTE CELL REFERENCE | A CELL ADDRESS, SUCH AS $E$14, REFERENCED IN A FORMULA THAT DOES NOT CHANGE BASED ON THE LOCATION OF THE CELL THAT CONTAINS THE FORMULA. |
| PRINT PREVIEW | A FEATURE USED TO DISPLAY A DOCUMENT AS IT WILL APPEAR WHEN PRINTED. |
| CUT | THE COMMAND USED TO REMOVE DATA FROM A CELL OR RANGE OF CELLS AND PLACE IT ON THE CLIPBOARD. |
| PASTE | THE COMMAND USED TO PLACE DATA FROM THE CLIPBOARD TO A LOCATION ON THE WORKSHEET. |
| DRAG-AND-DROP FEATURE | A MEHOD USED TO MOVE OR COPY THE CONTENTS OF A RANGE OF CELLS BY DRAGGING THE BORDER OF A SELECTION FROM ONE LOCATION IN A WORKSHEET AND DROPPING IT IN ANOTHER LOCATION. |
| GROUPING | WORKSHEETS THAT ARE SELCETED AS A UNIT; ANY ACTION PERFORMED ON THIS UNIT WILL AFFECT ALL THE WORKSHEETS IN THE GROUP. |
| ACTIVE SHEET TAB | THE SELECTED WORKSHEET; THE TAB NAME OF AN ACTIVE SHEET IS BOLD. |