Term
| Text is ______ when the cell that it resides in is not wide enough to display all of it. |
|
Definition
|
|
Term
| Adding a data series to a chart |
|
Definition
| 1.Select the chart, 2.Click the Select 3.Data button, 4.Click the Add button, 5.Select the range |
|
|
Term
| Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting. |
|
Definition
|
|
Term
| TRUE or FALSE? The range reference for nonadjacent ranges separates each adjacent range reference by a colon. |
|
Definition
|
|
Term
| TRUE OR FALSE Calculated values too large to fit into the cell are displayed in scientific notation. |
|
Definition
|
|
Term
| TRUE OR FALSE? Excel allows you to cycle through the different reference types using the F2 key. |
|
Definition
|
|
Term
| TRUE OR FALSE? $B$8 is a(n) relative reference to cell B8. |
|
Definition
|
|
Term
| general syntax of all functions |
|
Definition
| FUNCTION(argument1, argument2, ...) |
|
|
Term
| Absolute references symbol |
|
Definition
|
|
Term
| 2 ways a chart can be displayed |
|
Definition
| in a worksheet & chart sheet |
|
|
Term
| A chart sheet can contain ____, enabling you to display several charts at once within a single sheet. |
|
Definition
|
|
Term
| TRUE or FALSE? When you insert a new column, the existing columns are shifted to the left. |
|
Definition
|
|
Term
|
Definition
| applies formatting only when a cell’s value meets a specified condition. |
|
|
Term
|
Definition
| By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left |
|
|
Term
|
Definition
| cell reference absolute by preceding the columns (A and B) and row (2) with a dollar sign ($ |
|
|
Term
| TRUE OR FALSE? Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value. |
|
Definition
|
|
Term
| The code ____ will display the file name of the current workbook. |
|
Definition
|
|
Term
| The name given to an Excel workbook before you rename it is _____? |
|
Definition
|
|
Term
| “AD” is an example of a ______? |
|
Definition
|
|
Term
| The header and footer sections include |
|
Definition
| left,right and center section |
|
|
