click below
click below
Normal Size Small Size show me how
Computer
exam
| Question | Answer |
|---|---|
| allows you to enter, calculate, manipulate, and analyze data | worksheets |
| To display all the buttons on a toolbar, double-click the ___ on the left of the toolbar | move handle |
| Each worksheet in a workbook has ____ rows | 65,536 |
| To quit excel in voice command mode, say | File, Exit |
| The ____ key selects the cell down one worksheet window from the active cell | Page Down |
| group of adjacent cells | range |
| the ___ on a worksheet is one in which you can enter data | active cell |
| the standard toolbar contains the ___ button | copy |
| the horizontal and vertical lines on a worksheet are called | gridlines |
| to save a workbook using the shortcut keys, press | CTRL + S |
| built-in collection of formats which you can apply to a range of cells | auto-format |
| range of cells receiving a copy is called the | destination |
| which of the following is not a valid entry into a cell that requires numbers? | # |
| the Formatting toolbar contains the ___ button | center |
| in Excel, the default chart type is the ___ chart | 2-D column |
| means Excel can differentiate between uppercase and lowercase letters | Case-sensitive |
| inside a workbook are sheets called | worksheets |
| the small black square located in the lower-right corner of the heavy border around the active cell is called the | fill handle |
| a heavy border and transparent blue background which indicates a selected range is called | see-through view |
| data displays in the ___ as you type | formula bar |
| every time you enter a value into a cell in the worksheet, Excel ___ all formulas | recalculates |
| to center data in a cell, click the ___ button on the Standard toolbar | center |
| allows you to select cells for use in a formula by using the mouse | point mode |
| to verify that a formula contains the intended cell references, use excel's | range finder |
| to select a range of cells using the keyboard, press ___ then use the arrow keys | F8 |
| the process of finding and correcting errors in a worksheet is called | debugging |
| to override the order of operations, use | parentheses |
| a ___ is made up of two values and a relational operator | condition |
| the ___ alerts Excel that you are entering a formula or function and not text | equal sign |
| The ___ style format displays a dollar sign to the left of the number in a cell and displays numbers to the nearest cent | currency |
| you can assign a ___ to a cell and Excel will calculate the result | formula |
| ___ colors tend to reach towards your worksheet's reader | warmer |
| to determine the average of a range of numbers, click the ___ in the formula bar, the click AVERAGE | Insert button |
| the ___ version of a worksheet shows the results of formulas | values |
| in designing a worksheet, the most important thing to consider is ___ | function |
| when Excel starts and the blank workbook displays on the screen, all of the columns have a default width of ____ characters in 10-point Arial font | 8.43 |
| if excel does not accept a formula, remove the ___ from the left side and complete the entry as text | equal sign |
| to display additional decimal places in a cell, click the ___ button on the formatting toolbar | |
| the ___ is the order in which arithmetic operators are calculated | order of operations |
| ___ colors tend to pull away from your worksheet's reader | cooler |