University of Massachusetts Boston



University of Massachusetts Boston

College of Management

MSIS 110: Introduction to Computers (Instructor: S. Mathiyalakan)

Indicate whether the sentence or statement is true or false.

____ 1. If a formula is entered into 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.

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

____ 3. Excel has more than 400 functions that perform just about every type of calculation imagined.

____ 4. The Increase Decimal button on the formatting toolbar is used to display additional decimal places in a cell.

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

____ 6. $B$17 is a relative reference while B17 is an absolute reference.

Identify the letter of the choice that best completes the statement or answers the question.

____ 7. The __________ preceding a formula is an important part of the formula: it alerts Excel that a formula or function is being entered and not text.

|a. |number sign (#) |c. |percent sign (%) |

|b. |dollar sign ($) |d. |equal sign (=) |

____ 8. In Excel, functions can be entered using any of the following methods except the __________.

|a. |Function command on the Tools menu |

|b. |keyboard or mouse |

|c. |Insert Function box on the formula bar |

|d. |AutoSum menu or Voice Command mode |

____ 9. The __________ function sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range.

|a. |MIN |c. |MAX |

|b. |AVERAGE |d. |COUNT |

____ 10. The __________ on the Format menu lets formatting be applied that appears only when the value in a cell meets specified conditions.

|a. |AutoFormat command |c. |Conditional Formatting command |

|b. |Cells command |d. |Style command |

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

|a. |8.43 characters, or 64 pixels |c. |12.75 points, or 17 pixels |

|b. |64 characters, or 8.43 pixels |d. |17 points, or 12.75 pixels |

____ 12. To save a workbook a second time using a new name or on a different drive, __________.

|a. |click Save on the File menu |c. |click Save As on the File menu |

|b. |press SHIFT+F12 |d. |press CTRL+S |

[pic]

____ 13. The Print dialog box in the accompanying figure does not display when the __________ is used.

|a. |Print button in a dialog box |c. |Print button in the Preview window |

|b. |Print command on the File menu |d. |Print button on the Standard toolbar |

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

|a. |Selection option button |c. |Active sheet(s) option button |

|b. |Print to file check box |d. |Collate check box |

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

|a. |Entire workbook option button |c. |Selection option button |

|b. |All option button |d. |Active sheet(s) option button |

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

|a. |click the Cancel box |c. |click the Name box |

|b. |press the ESC key |d. |press the ENTER key |

____ 17. If cells containing 780 and 760 are copied using the fill handle, the next three values of the extended series will be __________.

|a. |780, 760, 780 |c. |680, 660, 580 |

|b. |740, 720, 700 |d. |775, 770, 765 |

____ 18. To copy formats to a range of cells, __________.

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

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

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

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

____ 19. If formulas located in other cells reference cells in a deleted row or column, Excel displays the error message __________ in those cells to indicate a cell reference error.

|a. |#VALUE! |c. |#NULL! |

|b. |#N/A! |d. |#REF! |

____ 20. To freeze the worksheet titles and column titles, use the Freeze Panes command on the __________.

|a. |Format menu |c. |Data menu |

|b. |Tools menu |d. |Window menu |

____ 21. When a date is displayed in the General format (e.g., 337801.75), the whole number portion of the number (37801) represents the number of days since __________.

|a. |December 31, 1899 |c. |December 31, 1999 |

|b. |January 1, 1990 |d. |January 1 of the current year |

____ 22. A formula using __________ instructs Excel to keep the cell reference B17 constant (absolute) as it pastes the formula to a new location.

|a. |B17 |c. |B$17 |

|b. |$B17 |d. |$B$17 |

____ 23. The general form of the IF function is __________.

|a. |=IF(logical_test, value_if_true, value_if_false) |

|b. |=IF(logical_test, value_if_false, value_if_true) |

|c. |=IF(value_if_true, logical_test, value_if_false) |

|d. |=IF(value_if_false, logical_test, value_if_true) |

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

|a. |= (equal to) and (not equal to) |

|b. |< (less than) and > (greater than) |

|c. |>= (greater than or equal to) and < (less than or greater than) and ^ (outside of) |

____ 25. The IF function =IF(B4>=$B$22, $B$18, 0) is assigned to cell B8. If the value in cell B4 is 6692019, the value in cell B22 is 6,500,000.00, and the value in cell B18 is 60000, Excel displays __________ in cell B8.

|a. |6692019 |c. |6,500,000.00 |

|b. |60000 |d. |0 |

[pic]

____ 26. Different parts of a worksheet can be viewed through __________, as shown in the accompanying figure.

|a. |zoom boxes |c. |window panes |

|b. |chart sheets |d. |toolbar docks |

____ 27. When the window is divided into four panes, as shown in the accompanying figure, the bar going up and down the middle of the window is called the __________.

|a. |vertical split bar |c. |horizontal split bar |

|b. |vertical scroll bar |d. |horizontal scroll bar |

____ 28. When the window is divided into four panes, as shown in the accompanying figure, the bar going right to left across the middle of the window is called the __________.

|a. |vertical split bar |c. |horizontal split bar |

|b. |vertical scroll bar |d. |horizontal scroll bar |

____ 29. 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.

|a. |Track Changes command |c. |Share Workbook command |

|b. |Data Analysis command |d. |Goal Seek command |

Complete each sentence or statement.

30. Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called _________________________.

Excel Chapters 2 & 3- Answer Section

TRUE/FALSE

1. T

2. F

3. T

4. T

5. T

6. F

MULTIPLE CHOICE

7. D

8. A

9. B

10. C

11. A

12. C

13. D

14. A

15. A

16. D

17. B

18. D

19. D

20. D

21. A

22. D

23. A

24. D

25. B

26. C

27. A

28. C

29. D

COMPLETION

30. what-if analysis

sensitivity analysis

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

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

Google Online Preview   Download