Shared Flashcard Set

Details

Excel project 2
for the test
51
Other
03/07/2007

Additional Other 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
d. AutoCorrect 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.
a. INSERT
Definition
c. ENTER
Term
9. A(n) _____ dollar sign always appears immediately to the left of the first digit.
a. currency
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
1. If a formula is entered into cell F4 to multiply the values in cells D4 and E4, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F4.
Definition
T
Term
2. The arithmetic operator, ^, directs Excel to perform the division operation.
Definition
F
Term
3. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.
Definition
F
Term
4. Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.
Definition
F
Term
5. When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values
Definition
T
Term
6. A smart tag indicator is a block plus sign located in the center of the cell.
Definition
F
Term
7. The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.
Definition
F
Term
9. The AutoSum button menu allows one of five often-used functions to be entered easily into a cell without requiring that its name or the required arguments be memorized.
Definition
T
Term
10. Excel has more than 400 functions.
Definition
T
Term
11. One of the least common mistakes made with Excel is to include the wrong cell reference in a formula.
Definition
F
Term
12. To use Range Finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked.
Definition
F
Term
1. One of the reasons Excel is such a valuable tool is that a(n) _________________________ can be assigned to a cell and Excel will calculate the result.
Definition
1. formula [EX 73]
Term
2. The _________________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
Definition
2. equal sign [EX 74]
Term
3. When more than one arithmetic operator is involved in a formula, Excel follows the same basic _________________________ that is used in algebra.
Definition
3. order of operations [EX 74]
Term
4. _________________________ allows cells to be selected for use in a formula by using the mouse.
Definition
4. Point mode [EX 75]
Term
5. Excel can identify certain actions to take on specific data (including dates, financial symbols, people’s names, and more) using _________________________.
Definition
5. smart tag [EX 78]
Term
6. Excel places a small purple triangle, called a(n) _________________________, in a cell to indicate that a smart tag is available.
Definition
6. smart tag indicator [EX 78]
Term
7. A blank cell in Excel has a numerical value of _________________________.
Definition
7. zero or 0 [EX 80]
Term
8. A(n) _________________________ takes a value or values, performs an operation, and returns a result to the cell.
Definition
8. function [EX 81]
Term
9. The values used with a function are called _________________________.
Definition
9. arguments [EX 81]
Term
10. The _________________________ is a function that sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
Definition
10. AVERAGE function [EX 81]
Term
11. Excel has a function called the _________________________ that displays the highest value in a range.
Definition
11. MAX function [EX 82]
Term
12. The _________________________ is a function used to determine the lowest number in a range.
Definition
12. MIN function [EX 84]
Term
13. Excel’s _________________________ can be used to check which cells are referenced in the formula assigned to the active cell.
Definition
13. Range Finder [EX 89]
Term
14. The _________________________ is a format that displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and rounds numbers to the nearest cent.
Definition
14. Currency style format [EX 98]
Term
15. A(n) _________________________ is a dollar sign that appears to the far left in a cell, often with spaces between it and the first digit.
Definition
15. fixed dollar sign [EX 98]
Term
16. A(n) floating dollar sign is a dollar sign that appears immediately to the left of the first digit in a cell with no _________________________.
Definition
16. spaces [EX 98]
Term
17. The _________________________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredth
Definition
17. Comma style format [EX 98]
Term
18. Formatting that appears only when the value in a cell meets specified conditions is called _________________________.
Definition
18. conditional formatting [EX 103]
Term
19. A(n) _________________________, which is made up of two values and a relational operator, is true or false for each cell in a range.
Definition
19. condition [EX 104]
Term
20. A(n) _________________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel.
Definition
20. character [EX 107]
Term
21. A(n) _________________________ is a dot on the screen that contains a color.
Definition
21. pixel [EX 107]
Term
22. _________________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.
Definition
22. Best fit [EX 107]
Term
23. _________________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.
Definition
23. Hiding cells [EX 109]
Term
24. Excel has a(n) _________________________ that can be used to check a worksheet for spelling errors.
Definition
24. spell checker [EX 111]
Term
25. When Excel’s spell checker finds a word that is not in the standard or custom dictionaries, it displays the word in the _________________________, as shown in the accompanying figure.
Definition
25. Spelling dialog box [EX 112]
Term
26. To correct a word throughout a worksheet, click the _________________________ in the Spelling dialog box shown in the accompanying figure.
Definition
26. Change All button [EX 113]
Term
27. To append words to the dictionary, click the _________________________ in the Spelling dialog shown in the accompanying figure when Excel identifies the word as not in the dictionary.
Definition
27. Add to Dictionary button [EX 113]
Term
28. Click the _________________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change.
Definition
28. AutoCorrect button [EX 113]
Term
29. By _________________________ the worksheet, you see exactly how it will look without generating a printout
Definition
29. previewing [EX 113]