Due Date: Tuesday, September 10, 2002



MNSC 341 HOMEWORK ASSIGNMENT 1

(Excel Project 2)

Due Date: (Submit it along with Lab Assignment 1)

1 Moving from left to right in a formula, the order of operations is as follows: first negation (-), then all __________.

1 exponentiations (^), then all percentages (%), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (-)

2 percentages (%), then all exponentiations (^), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (-)

3 exponentiations (^), then all percentages (%), then all additions (+) and subtractions (-), and finally, all multiplications (*) and divisions (/)

4 percentages (%), then all exponentiations (^), then all additions (+) and subtractions (-), and finally, all multiplications (*) and divisions (/)

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

1 SHIFT b. ALT c. CTRL d. HOME

3 Excel has a function called the __________ that displays the highest value in a range.

1 MIN function b. MAX function c. NOW function d. SUM function

4 When verifying a formula using the Auditing commands, to change the active cell to the one at the other end of the blue line, __________.

1 click the active cell b. double-click the active cell

2 click the blue line d. double-click the blue line

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

1 Sheet command b. AutoFormat command

2 Conditional Formatting command d. Style command

6 When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of __________.

1 12.43 points and the rows have a default height of 8.43 characters

2 12.43 characters and the rows have a default height of 8.43 points

3 8.43 points and the rows have a default height of 12.75 characters

4 8.43 characters and the rows have a default height of 12.75 points

7 To display a hidden column, position the mouse pointer to the __________.

1 left of the column heading where the hidden column is located and then drag to the right

2 right of the column heading where the hidden column is located and then drag to the left

3 left of the column heading where the hidden column is located and then drag to the left

4 right of the column heading where the hidden column is located and then drag to the right

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

1 HOME and END b. LEFT ARROW and RIGHT ARROW

2 PAGE UP and PAGE DOWN d. all of the above

9 In the Print dialog box in the accompanying figure, the __________ instructs Excel to print all the sheets with content in the workbook.

1 All option button

2 Selection option button

3 Active sheet(s) option button

4 Entire workbook option button

[pic]

10 In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the selected range.

1 All option button b. Selection option button

2 Active sheet(s) option button d. Entire workbook option button

11 To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then __________.

1 press the ESC key b. click the Name Box

2 press the INSERT key d. click a cell in the worksheet

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

1 true

2 false

13 When more than one operator is involved in a formula, Excel follows a different basic order of operations from that used in algebra.

1 true

2 false

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.

1 true

2 false

15 A function takes a value or values, performs an operation, and returns a result to the cell.

1 true

2 false

16 Excel has more than 400 functions that perform just about every type of calculation that can be imagined.

1 true

2 false

17 If the Range Finder is used to change cells referenced in a formula, press the ENTER key to complete the edit.

1 true

2 false

18 If the Trace Precedents command on the Auditing submenu is clicked, Excel displays cells with formulas in the worksheet that reference the active cell.

1 true

2 false

19 When developing presentation-quality worksheets, different fonts seldom are used in the same worksheet.

1 true

2 false

20 When the Currency Style button is used, Excel assigns a floating dollar sign that displays immediately to the left of the first digit.

1 true

2 false

21 The Increase Decimal button on the Formatting toolbar removes a decimal place from the selected cell each time it is clicked.

1 true

2 false

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

1 true

2 false

23 When conditional formatting is used, if the condition is false, Excel applies the formatting.

1 true

2 false

24 When a worksheet is printed, hidden columns print.

1 true

2 false

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

1 true

2 false

26 Sheet names can contain up to 31 characters (including spaces) in length.

1 true

2 false

27 Excel includes prewritten formulas called __________ to help compute statistics.

28 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 The __________ sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range.

30 The __________ on the Auditing submenu removes the highlights.

31 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 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 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 A(n) __________ is defined as a letter, number, symbol, or punctuation mark in 10-point Arial font, the default font used by Excel.

35 __________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

36 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 The __________ on the Standard toolbar can save time, paper, and frustration by displaying exactly how a worksheet will look without generating a printout.

38 __________ is the process of finding and correcting errors in the worksheet.

39 The __________ in the Page Setup dialog box allows the percentage of reduction or enlargement in the printout of a worksheet to be specified.

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

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download