Due Date: Tuesday, September 10, 2002



MNSC 341 HOMEWORK ASSIGNMENT 2

(Excel Project 3)

Due Date: Submit it along with Lab Assignment 2

Multiple Choice, True/False, and Fill-up the blanks questions

1 In Excel, text can be rotated counterclockwise by entering a number between __________ on the Alignment sheet in the Format Cells dialog box.

1 1º and 90º b. -1º and -90º c. 90º and 180º d. -90º and -180º

2 To copy formats to a range of cells, __________.

1 drag through the range to which the format should be pasted, click the Format Painter button, and then select a cell with the desired format

2 drag through the range to which the format should be pasted, select a cell with the desired format, and then click the Format Painter button

3 click the Format Painter button, drag through the range to which the format should be pasted, and then select a cell with the desired format

4 select a cell with the desired format, click the Format Painter button, and then drag through the range to which the format should be pasted

3 When a date is displayed in the General format (e.g., 37071.75), the whole number portion of the number (37071) represents the number of days since __________.

1 December 31, 1899 b. January 1, 1990

2 December 31, 1999 d. January 1 of the current year

4 The primary difference between the Insert command on the shortcut menu and the Rows command on the Insert menu is this: the Insert command __________.

1 only can be used to insert single cells, while the Rows command can be used to insert entire rows

2 requires that an entire row be selected in order to insert a row, while the Rows command requires that a single cell be selected in a row to insert one row

3 only can be used to insert entire rows, while the Rows command can be used to insert single cells

4 requires that a single cell be selected in a row to insert one row, while the Rows command requires that an entire row be selected in order to insert a row

5 If cells containing 600 and 580 are copied using the fill handle, the next three values of the extended series will be __________.

1 500, 480, 400 b. 560, 540, 520 c. 570, 560, 550 d. 579, 578, 577

6 Valid format symbols that can be entered with a number include all of the following except the __________.

1 asterisk (*) b. comma (,) c. dollar sign ($) d. percent sign (%)

7 A formula using __________ instructs Excel to keep both the row and column references constant (absolute) as it copies the formula to a new location.

1 B17 b. $B17 c. B$17 d. $B$17

8 In an IF function, valid comparison operators (and their meaning) include all of the following except __________.

1 = (equal to) and (not equal to)

2 < (less than) and > (greater than)

3 >= (greater than or equal to) and < (less than or greater than) and ^ (outside of)

9 The IF function =IF(B4>=$B$21, $B$20, 0) is assigned to cell B10. If the value in cell B4 is 4,754,250, the value in cell B21 is 5,000,000, and the value in cell B20 is 75,000, the value display is cell B10 will be __________.

1 4,754,250 b. 75,000 c. 5,000,000 d. 0

10 To divide the window into four panes, as shown in the accompanying figure, click the __________ on the Windows menu.

1 New Window command b. Arrange command

2 Split command d. Freeze Panes command

[pic]

11 If the result a formula should produce is known, the __________ on the Tools menu can be used to determine the value of a cell on which the formula depends.

1 Track Changes command b. Data Analysis command

2 Share Workbook command d. Goal Seek command

12 With large worksheets that extend beyond the size of a window, it is best to enter titles in the upper-left corner.

1 True b. false

13 If the fill handle is used to create a series of numbers or non-sequential months, the first item in the series must be entered in one cell and the second item in the series in an adjacent cell.

1 True b. false

14 If cells are to be copied to more than one paste area, after selecting the paste area press the ENTER key instead of clicking the Paste button on the Edit menu or shortcut menu.

1 True b. false

15 If cell A7 contains the formula =A4+A5 and row 5 is deleted, then Excel assigns the formula =A4+#REF! to cell A6 (originally cell A7) and displays the error message #REF! in cell A6.

1 True b. false

16 Excel automatically formats a date stamp to the date and time format, m/d/yy h:mm, where the first m is the month, d is the day of the month, yy is the last two digits of the year, h is the hour of the day, and mm is the minutes past the hour.

1 True b. false

17 In an IF function's logical_test, each expression can be a cell reference, a number, text, a function, or a formula.

1 True b. false

18 Excel has four toolbar docks, one on each of the four sides of the window.

1 True b. false

19 To split the window into four panes, first select the cell where the panes should intersect.

1 True b. false

20 Excel not only recalculates all formulas in a worksheet when new data is entered, but also redraws any associated charts.

1 True b. false

21 __________ are values in cells that can be changed to determine new values for formulas.

22 When a second item is copied, the __________ displays with icons representing different items copied to the Office Clipboard.

23 When a number is entered with a(n) __________, Excel immediately displays the number with an assigned format.

24 The __________ is an Excel function used to enter the system date in a cell in a worksheet.

25 To keep a cell reference constant when it copies a formula or function, Excel uses a technique called __________.

26 The __________ is an Excel function that is useful when the value assigned to a cell is dependent on a logical test.

27 To assign a Currency style with a floating dollar sign, the __________ on the shortcut menu must be used rather than the Currency Style button on the Formatting toolbar.

28 A separate sheet on which a chart resides is called a(n) __________.

29 Before a chart item, such as the chart title or labels, can be formatted, it must be _____________.

30 In a Pie chart, a slice can be emphasized by offsetting, or __________, it from the rest of the slices.

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

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

Google Online Preview   Download