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


Term
2.All of the following are valid Excel arithmetic operators except _____. 

Definition


Term
3.When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____. 

Definition


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


Term
5.The _____ button lists formatting options following an insert of cells, row, or columns. 

Definition


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
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


Term
2.The _________________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text. 

Definition


Term
3. When more than one arithmetic operator is involved in a formula, Excel follows the same basic _________________________ that is used in algebra. 

Definition


Term
4. _________________________ allows cells to be selected for use in a formula by using the 

Definition


Term
5. Excel can identify certain actions to take on specific data (including dates, financial symbols, people’s names, and more) using _________________________. 

Definition


Term
6. Excel places a small purple triangle, called a(n) _________________________, in a cell to indicate that a smart tag is available. 

Definition


Term
7. A blank cell in Excel has a numerical value of _________________________. 

Definition


Term
8. A(n) _________________________ takes a value or values, performs an operation, and returns a result to the cell. 

Definition


Term
9. The values used with a function are called _________________________. 

Definition


Term
10. The _________________________ is a function that sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. 

Definition


Term
11. Excel has a function called the _________________________ that displays the highest value in a range. 

Definition


Term
12. The _________________________ is a function used to determine the lowest number in a range. 

Definition


Term
13. Excel’s _________________________ can be used to check which cells are referenced in the formula assigned to the active cell. 

Definition


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


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


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


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


Term
18. Formatting that appears only when the value in a cell meets specified conditions is called _________________________. 

Definition


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


Term
20. A(n) _________________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel. 

Definition


Term
21. A(n) _________________________ is a dot on the screen that contains a color. 

Definition


Term
22. _________________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column. 

Definition


Term
22. _________________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column. 

Definition


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


Term
24. Excel has a(n) _________________________ that can be used to check a worksheet for spelling errors. 

Definition


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


Term
26. To correct a word throughout a worksheet, click the _________________________ in the Spelling dialog box shown in the accompanying figure. 

Definition


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


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


Term
29. By _________________________ the worksheet, you see exactly how it will look without generating a printout. 

Definition


Term
30. _________________________ means the printout is printed across the width of the page. 

Definition


Term
31. _________________________ means the printout is printed across the length of the page. 

Definition


Term
32. The _________________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas. 

Definition


Term
33. The _________________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values. 

Definition


Term
34. _________________________ is the process of finding and correcting errors in a worksheet. 

Definition


Term
35. The most popular service on the Internet is _________________________, which is the electronic transmission of messages and files to and from other computers using the Internet. 

Definition

