Term
Excel has only two conditional formats-data bars and highlighting.
True or false |
|
Definition
|
|
Term
| A(n)____ is a group of cells |
|
Definition
|
|
Term
| Auto-fill, which content and formats from a cell or range into an adjacent cell or range. True or False |
|
Definition
|
|
Term
| What takes precedence over multiplication |
|
Definition
|
|
Term
| a table style treats the table as a single object rather than a collection of cells. True or False |
|
Definition
|
|
Term
| From formula view, press ____ to switch the worksheet back to normal view. |
|
Definition
|
|
Term
| A _____ acts like a line or ruler, making it easier to read a chart's scale. |
|
Definition
|
|
Term
| What would result in adding the value 'k' to the end of each number on a chart's vertical axis? |
|
Definition
|
|
Term
Charts can be embedded into worksheets.
True or False |
|
Definition
|
|
Term
Put the following steps for selecting a nonadjacent range of cells in the proper order
1.select an adjacent range of cells.
2.With Ctrl key still pressed, continue to select other cell ranges until all of the ranges are selected.
3. Release the mouse button and Ctrl key.
4.Press and hold the Ctrl key, and then select another adjacent cell range. |
|
Definition
1,4,2,3
-Select an adjacent range of cells,
-press and hold the control key, and then select another adjacent cell range.
-With the control key still pressed continue to select other cell ranges until all of the ranges are selected.
-release the mouse button and the control key. |
|
|
Term
in the formula, =2+6*2, addiction would be calculated after multiplication.
true or false |
|
Definition
|
|
Term
| A chart can be displayed ____. |
|
Definition
| In a worksheet and in a chart sheet |
|
|
Term
| removing the contents of a cell is known as _____ a cell. |
|
Definition
|
|
Term
| =INT(AVERAGE(A1:A100)) is an example of a(n) _____ function. |
|
Definition
|
|
Term
| you can open the format cells dialog box by right-clicking a cell or selecting range, and then clicking ____ on the shortcut menu. |
|
Definition
|
|
Term
a newly inserted row has the same height as the row above it.
TRUE OR FALSE |
|
Definition
|
|
Term
| "AD" is an example of a ______. |
|
Definition
|
|
Term
Although dates and times in Excel appear as text, they are actually numbers.
TRUE OR FALSE |
|
Definition
|
|
Term
Modifying the number formats affects the value stored int eh workbook.
TRUE OR FALSE |
|
Definition
|
|
Term
| To display Mar 17, 2008 as a custom format, you would type___ in the Format Code:box in Excel |
|
Definition
|
|
Term
| The ____ is a rectangular area that labels the markers or symbols used in a chart. |
|
Definition
|
|
Term
| Which of the following shows the correct order of steps for adding a data series to a chart? |
|
Definition
| Select the chart, Click the Select Data button, Click the Add button, Select the range |
|
|
Term
| By default, Excel inserts a chart as an embedded chart. |
|
Definition
|
|
Term
| When a worksheet is printed, the gridlines that surround the cells are printed by default. |
|
Definition
|
|
Term
| Calculated values too large to fit into the cell are displayed in scientific notation. |
|
Definition
|
|
Term
| Placing a chart in a ____ displays only the chart and no worksheet cells. |
|
Definition
|
|
Term
| The range reference for nonadjacent ranges separates each adjacent range reference by a colon. |
|
Definition
|
|
Term
| As a general rule, you should ____ |
|
Definition
| center column titles, left-align text, and right-align numbers |
|
|
Term
| To go to column A of the current row, click ____. |
|
Definition
|
|
Term
| What is the result of the expression =50/(10*5)? |
|
Definition
|
|
Term
| Italic, bold, bold italic, and underline are examples of ____. |
|
Definition
|
|
Term
| In a column chart, you can ____. |
|
Definition
1)
add a gradient fill to columns
2)
reduce gap width between columns
3)
modify the appearance of data markers
Correct Response 4)
all of the above |
|
|
Term
| Excel is an electronic version of a(n) ____. |
|
Definition
|
|
Term
| If an optional argument is not included, Excel assumes a(n) ____ value for it. |
|
Definition
|
|
Term
| Removing the contents of a cell is known as ____ a cell. |
|
Definition
|
|
Term
| If a formula contains several functions, Excel starts with the outermost function and then moves inward. |
|
Definition
|
|
Term
| In the Function Arguments dialog box, required arguments are in bold type. |
|
Definition
|
|
Term
| In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets. |
|
Definition
|
|
Term
| To view formulas, rather than the resulting values in a worksheet, switch to ____. |
|
Definition
|
|
Term
| In the Format Axis dialog box, selecting Fixed 0.10 for the Minor Unit will result in ____. |
|
Definition
| minor tick marks appearing at 10% intervals |
|
|
