MNSC 341: Homework assignment 1
(Excel Project 2)
Answer Key
1. b (09Excl-2-10) Moving from left to right in a formula, the order of operations is as follows: first negation (-), then all ______.
2. c (09Excl-2-15) To select the nonadjacent range F11, H11, and I11, select cell F11, and then, while holding down the ______key, drag through the range H11:I11.
3. b (09Excl-2-18) Excel has a function called the ______that displays the highest value in a range.
4. d (09Excl-2-26) When verifying a formula using the Auditing commands, to change the active cell to the one at the other end of the blue line, ______.
5. c (09Excl-2-39) To display negative percents in a column in bold with a red background so they stand out, the ______on the Format menu can be used.
6. d (09Excl-2-43) When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ______.
7. a (09Excl-2-46) To display a hidden column, position the mouse pointer to the ______.
8. c (09Excl-2-53) Rather than click the Next and Previous buttons to move from page to page on a multiple page worksheet in the Preview window, the ______keys can be pressed.
9. d (09Excl-2-55) In the Print dialog box in the accompanying figure, the ______instructs Excel to print all the sheets with content in the workbook.
10. b (09Excl-2-55) In the Print dialog box in the accompanying figure, the ______instructs Excel to print the selected range.
11. d (09Excl-2-61) To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ______.
12. a - true (09Excl-2-9) If a formula is entered in cell F3 to multiply the values in cells D3 and E3, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F3.
13. b - false (09Excl-2-10) When more than one operator is involved in a formula, Excel follows a different basic order of operations from that used in algebra.
14. a - true (09Excl-2-14) When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and perform calculations using the appropriate values.
15. a - true (09Excl-2-16) A function takes a value or values, performs an operation, and returns a result to the cell.
16. a - true (09Excl-2-21) Excel has more than 400 functions that perform just about every type of calculation that can be imagined.
17. a - true (09Excl-2-24) If the Range Finder is used to change cells referenced in a formula, press the ENTER key to complete the edit.
18. b - false (09Excl-2-26) If the Trace Precedents command on the Auditing submenu is clicked, Excel displays cells with formulas in the worksheet that reference the active cell.
19. b - false (09Excl-2-28) When developing presentation-quality worksheets, different fonts seldom are used in the same worksheet.
20. b - false (09Excl-2-34) When the Currency Style button is used, Excel assigns a floating dollar sign that displays immediately to the left of the first digit.
21. b - false (09Excl-2-36) The Increase Decimal button on the Formatting toolbar removes a decimal place from the selected cell each time it is clicked.
22. b - false (09Excl-2-38) A floating dollar sign always displays to the left side of a cell, and the fixed dollar sign always displays immediately to the left of the first digit.
23. b - false (09Excl-2-40) When conditional formatting is used, if the condition is false, Excel applies the formatting.
24. b - false (09Excl-2-46) When a worksheet is printed, hidden columns print.
25. b - false (09Excl-2-55) Because the values version of a worksheet displays and prints the formulas, rather than the results, it makes it easier to see if any mistakes were made in formulas.
26. a - true (09Excl-2-62) Sheet names can contain up to 31 characters (including spaces) in length.
27. functions (09Excl 2-16) Excel includes prewritten formulas called ______to help compute statistics.
28. formula (09Excl 2-9) 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.
29. AVERAGE function (09Excl 2-16) The ______sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range.
30. Remove all Arrows command (09Excl 2-23) The ______on the Auditing submenu removes the highlights.
31. Paste Function button (09Excl 2-21) Using the ______on the Standard toolbar allows a function to be entered into a cell easily without requiring that its name or the necessary conditions be memorized.
32. Percent Style button (09Excl 2-39) The ______on the Formatting toolbar is used to display a value determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
33. condition (09Excl 2-40) A(n) ______, which is made up of two values and a relational operator, is true or false for each cell in a selected range.
34. character (09Excl 2-43) A(n) ______is defined as a letter, number, symbol, or punctuation mark in 10-point Arial font, the default font used by Excel.
35. Best fit (09Excl 2-43) ______means that the width of a column will be increased or decreased so the widest entry will fit in the column.
36. AutoCorrect button (09Excl 2-50) In the Spelling dialog box pictured, click the ______to add the misspelled word and the correct version of the word to the list of words corrected automatically.
37. Print Preview button (09Excl 2-51) The ______on the Standard toolbar can save time, paper, and frustration by displaying exactly how a worksheet will look without generating a printout.
38. Debugging (09Excl 2-55) ______is the process of finding and correcting errors in the worksheet.
39. Adjust to box (09Excl 2-57) The ______in the Page Setup dialog box allows the percentage of reduction or enlargement in the printout of a worksheet to be specified.
40. Preview window (09Excl 2-42) The ______in the Conditional Formatting dialog box shows the format that will be assigned to any cells in the selected range that meet the specified conditions.