Shared Flashcard Set

Details

ana-karen's Excel P2 Theory Ca
Computer Flash Cards
13
Business
10th Grade
03/07/2007

Additional Business Flashcards

 


 

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
Supporting users have an ad free experience!