Home > Flashcards > Business > ana-karen's Excel P2 Theory Ca

Details Title: ana-karen's Excel P2 Theory Ca Description: Computer Flash Cards Total Flash Cards: 13 Created: 03/07/2007 05:42:05	To study from this set of flash cards, or to create your own your own study flash cards, register HERE. If you are already a registered user, CLICK HERE.
Cards Term 1. To start a new line in a cell, press _____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys. Definition a. ALT+ENTER Term 2. All of the following are valid Excel arithmetic operators except _____. Definition d. > Term 3. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____. Definition b. 26 Term 4. When an error occurs in a formula in a cell, Excel displays the _____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell. Definition c. Trace Error Term 5. The _____ button lists formatting options following an insert of cells, row, or columns. Definition b. Insert Options Term 6. In Excel, functions can be entered using any of the following methods except the _____. Definition a. Function command on the Tools menu Term 7. To save a saved workbook using a new name or on a different drive, _____. Definition b. click Save As on the File menu Term 8. If Range Finder is used to change cells referenced in a formula, press the _____ key to complete the edit. Definition c. ENTER Term 9. A(n) _____ dollar sign always appears immediately to the left of the first digit. Definition c. floating Term 10. The _____ in the Conditional Formatting dialog box can be used to remove one or more active conditions. Definition b. Delete button Term 11. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of _____. Definition a. 8.43 characters, or 64 pixels Term 12. To set a column width to best fit, _____ boundary of the column heading above row 1. Definition d. double-click the right Term 13. To instruct Excel to display a hidden column, position the mouse pointer to the _____. Definition d. right of the column heading boundary where the hidden column is located and then drag to the right