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 |