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