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
8. If Range Finder is used to change cells referenced in a formula, press the _____ key to complete the edit. 

Definition


Term
9. A(n) _____ dollar sign always appears immediately to the left of the first digit. 

Definition


Term
10. The _____ in the Conditional Formatting dialog box can be used to remove one or more active conditions. 

Definition


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


Term
14. To check the spelling of the text in a single cell, _____ to make the formula bar active and then click the Spelling button on the Standard toolbar. 

Definition


Term
15. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks _____. 

Definition
b. the remainder of the worksheet, including notes and embedded charts 


Term
16. Rather than click the Next and Previous buttons to move from page to page in the Preview window, the _____ keys can be pressed. 

Definition


Term
17. When the mouse pointer shape is a magnifying glass, the previewed page in the Preview window can be clicked to carry out the function of the _____ button. 

Definition


Term
18. Excel does not display the Print dialog box shown in the accompanying figure when the _____ is used. 

Definition
d. Print button on the Standard toolbar 


Term
19. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print the selected range. 

Definition
a. Selection option button 


Term
20. In the Print dialog shown in the accompanying figure, the _____instructs Excel to print the worksheet currently on the screen or the selected worksheets. 

Definition
c. Active sheet(s) option button 


Term
21. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print all the worksheets with content in the workbook. 

Definition
a. Entire workbook option button 


Term
22. To toggle between the values version and the formulas version of a worksheet, hold down the _____ key. 

Definition
c. CTRL key while pressing the ACCENT MARK (`) 


Term
23. When Excel first is installed, all of the following Web queries are available except _____. 

Definition
d. MSN MoneyCentral Investor Commodity Prices 


Term
24. To change the stock symbols Excel uses when refreshing the data in a Web query, click the _____ on the External Data toolbar. 

Definition
b. Query Parameters button 


Term
25. To rename sheets, doubleclick the sheet tab in the lowerleft corner of the window, type the new sheet name, and then _____. 

Definition


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


Term
2. The arithmetic operator, ^, directs Excel to perform the division operation. 

Definition


Term
3. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators 

Definition


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


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


Term
6. A smart tag indicator is a block plus sign located in the center of the cell. 

Definition


Term
7. The AVERAGE function requires that the argument (the range) be included within parentheses before the function name. 

Definition


Term
8. When Point mode is used to enter a formula or function, the arrow keys can be used to complete the entry. 

Definition


Term
9. The AutoSum button menu allows one of five oftenused functions to be entered easily into a cell without requiring that its name or the required arguments be memorized. 

Definition


Term
10. Excel has more than 400 functions. 

Definition


Term
11. One of the least common mistakes made with Excel is to include the wrong cell reference in a formula. 

Definition


Term
12. To use Range Finder to verify that a formula contains the intended cell references, rightclick the cell with the formula to be checked. 

Definition


Term
13. Excel allows you to change the font of all the characters in a cell, in a range of cells, or in the entire worksheet. 

Definition


Term
14. The font type, size, or style can be changed at any time while a worksheet is active. 

Definition


Term
15. Left alignment, center alignment, and right alignment are used so rarely that Excel relegates the Align Left, Center, and Align Right buttons to the Standard toolbar. 

Definition


Term
16. Excel does not allow the contents of a cell to be aligned vertically. 

Definition


Term
17. To assign a fixed dollar sign, the Cells command on the Format menu or the Format Cells command on the shortcut menu must be used. 

Definition


Term
18. The Comma Style button is located on the Formatting toolbar. 

Definition


Term
19. Each time the Decrease Decimal button is clicked, Excel removes a decimal place from the selected cell. 

Definition


Term
20. Once you select a category in the Format Cells dialog box, you cannot select whether or not a dollar sign should be displayed or how negative numbers should appear. 

Definition


Term
21. All of the available negative number formats align the numbers in a worksheet on the decimal points. 

Definition


Term
22. When using conditional formatting, if the condition is true, then Excel applies the formatting. 

Definition


Term
23. A character is a dot on the screen that contains a color. 

Definition


Term
24. A pixel is defined as a letter, number, symbol, or punctuation mark in 10point Arial font, the default font used by Excel. 

Definition


Term
25. The default row height in a blank worksheet is 12.75 points (or 17 pixels). 

Definition


Term
26. When the format assigned to a cell causes the entry to exceed the width of a column, Excel automatically changes the column width to best fit. 

Definition


Term
27. If column width is decreased to zero, the column is hidden. 

Definition


Term
28. When a worksheet is printed, hidden columns print. 

Definition


Term
29. Row height can vary between zero (0) and 409 points. 

Definition


Term
30. To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box. 

Definition


Term
31. If a cell other than cell A1 is selected before starting the spell checker, a dialog box will display when the spell checker reaches the end of the worksheet, asking if the spell checker should continue checking at the beginning. 

Definition


Term
32. You can preview a worksheet using the Print Preview button on the menu bar. 

Definition


Term
33. Previewing a worksheet can save time, paper, and the frustration of waiting for a printout only to discover it is not what you want. 

Definition


Term
34. Once you change the orientation and save a workbook, Excel will save the orientation setting for that workbook until you change it. 

Definition


Term
35. When a new workbook is opened, Excel sets the orientation to landscape. 

Definition


Term
36. The Page Setup dialog box allows changes to be made to the default settings for a printout. 

Definition


Term
37. Scaling can be used to fit a wide worksheet on one page. 

Definition


Term
38. Excel displays the Print dialog box when you use the Print button on the Standard toolbar. 

Definition


Term
39. You can print portions of a worksheet by selecting the range of cells to print and then clicking the Selection option button in the Print what area in the Print dialog box. 

Definition


Term
40. The formulas version of a worksheet usually is significantly narrower than the values version. 

Definition


Term
41. To import external data from a World Wide Web site, it is necessary to have access to the Internet. 

Definition


Term
42. The data returned by stockrelated Web queries is realtime in the sense that it is no more than 20 minutes old during the business day. 

Definition


Term
43. Instead of using the External Data toolbar, any Web query command also can be invoked by rightclicking the returned worksheet to display a shortcut menu with several of the same commands as the External Data toolbar. 

Definition


Term
44. The tabs at the bottom of the worksheet window allow any of the worksheets in the workbook to be viewed. 

Definition


Term
45. Worksheet names can be up to 31 characters (including spaces) in length. 

Definition


Term
46. Longer worksheet names mean that more tabs will display. 

Definition


Term
47. The leftmost and rightmost scroll buttons to the left of the sheet tabs move one worksheet to the left or right. 

Definition


Term
48. The two middle scroll buttons to the left of the sheet tabs move to the first or last worksheet in the workbook. 

Definition


Term
49. With Excel, users have the capability of emailing a worksheet or workbook directly from within Excel. 

Definition


Term
50. When a workbook is sent as an attachment to an email, the recipient can doubleclick the attachment to open it in Excel, or save it on disk and then open it at a later time. 

Definition


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

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

