Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| ALLOWS YOU TO SEE HOW TEH STYLE FORMATTING AFFECTS CELLS IN YOUR WORKSHEET. |
|
|
Term
|
Definition
| THE STANDARD SETTINGS EXCEL USES IN ITS SOFTWARE, SUCH AS COLUMN WIDTH OR NUMBER OF WORKSHEETS IN A WORKBOOK. |
|
|
Term
|
Definition
| TEXT IN THE FIRST ROW OR COLUMN OF A WORKSHEET THAT IDENTIFIES THE TYPE OF DATA CONTAINED THERE. |
|
|
Term
|
Definition
| A NUMBER ENTRED IN THE WORKSHEET. |
|
|
Term
|
Definition
| A NUMBER ENTERED IN THE WORKSHEET AS A LABEL, NOT AS A VALUE-SUCH AS THE YEAR 2005 USED AS A COLUMN LABEL. |
|
|
Term
|
Definition
| AN APOSTROPHE(') USED TO INDICATE THAT A NUMBER IS A LABEL AND NOT A VALUE. |
|
|
Term
|
Definition
| A LIST OF SEQUENTIAL NUMBERS, DATES, TIMES, OR TEXT. |
|
|
Term
|
Definition
| THE DEFAULT NUMBER OF CHARACTERS THAT DISPLAY IN A COLUMN BASED ON THE DEFAULT FONT. |
|
|
Term
|
Definition
| A BLOCK OF CELLS IN AN EXCEL WORKSHEET |
|
|
Term
|
Definition
| A BLOCK OF ADJACENT CELLS IN A WORKSHEET. |
|
|
Term
|
Definition
| CELLS IN A WORKSHEET THAT ACT AS A BLOCK, BUT ARE NOT NECESSARILY ADJACENT TO EACH OTHER. |
|
|
Term
|
Definition
| A COLOR THAT FILLS A CELL, APPEARING BEHIND THE DATA. |
|
|
Term
|
Definition
| A COLLECTION OF COORDINATED FONTS, COLORS, AND EFFECTS FOR GRAPHIC ELEMENTS SUCH AS CHARTS AND IMAGES THAT CAN BE QUICKLY APPLIED TO ALL SHEETS IN A WORKBOOK |
|
|
Term
|
Definition
| 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. |
|
|
Term
|
Definition
| A STYLE THAT VERTICALLY ALIGNS WITH DOLLAR SIGNS($), THOUSANDS SEPERATORS(,) AND DECIMAL POINTS. |
|
|
Term
|
Definition
| A METHOD 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. |
|
|
Term
|
Definition
| WORKSHEETS THAT ARE SELECTED AS A UNIT, ANY ACTION PERFORMED ON THIS UNIT WILL AFFECT ALL THE WORKSHEETS IN A GROUP |
|
|
Term
|
Definition
| THE SELECTED WORKSHEET; THE TAB NAME OF AN ACTIVE SHEET IS BOLD. |
|
|
Term
|
Definition
| A PREDEFINED FORMULA THAT USES THE VALUES IN THE CELLS YOU SELECT TO CALCULATE THE ANSWER. |
|
|
Term
|
Definition
| THE NAME GIVEN TO ONE OF EXCEL'S PREDEFINED FORMULAS. |
|
|
Term
|
Definition
| THE PARTS OF A FORMULA THAT ARE VARIABLE. YOU SELECT THE CELL/CELLS FOR EACH ARGUMENT; AND EXCEL CALCULATES THE ANSWERS BASED ON TEHIR VALUES. |
|
|
Term
|
Definition
| TO USE A FUNCTION AS AN ARGUMENT WITHIN ANOTHER FUNCTION |
|
|
Term
|
Definition
| A FEATURE THAT SPEEDS UP THE MANUAL ENTRY FUNCTIONS. |
|
|
Term
|
Definition
| A FEATURE THAT TEMPORARILY PERFORMS THE FOLLOWING CALCULATIONS ON A RANGE OF CELLS WITHOUT MAKING YOU WRITE A FORMULA; AVERAGE, COUNT, COUNTA, MAX, MIN, AND SUM. |
|
|
Term
|
Definition
| A TEXT NOTE ATTACHED TO A WORKSHEET CELL |
|
|
Term
|
Definition
| AN IDENTIFICATION LABEL ASSIGNED TO A GROUP OF CELLS. |
|
|
Term
|
Definition
| A SORT OF EQUATION SUCH AS B6>25) THAT RETURNS A VALUE; SUCH AS TRUE / FALSE. |
|
|
Term
|
Definition
| A VARIABLE USED IN A FUNCTION. IT CAN BE A NUMBER, TEXTS, FORMULA, OR A CELL REFERENCE, A COMMA SEPERATES EACH ARGUMENT IN A FUNCTION. |
|
|
