University of Massachusetts Boston



University of Massachusetts Boston

College of Management

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

Excel Project 3 Q & A

True/False

Indicate whether the sentence or statement is true or false.

____ 1. Worksheets normally are small, seldom extending beyond the size of the window.

Multiple Choice

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

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

____ 3. If, in completing a paste, valuable data accidentally is deleted, immediately click the __________ on the Edit menu to cancel the paste.

|a. |Paste Special command |c. |Clear command |

|b. |Undo Paste command |d. |Redo Paste command |

____ 4. To copy a selection, hold down the __________ key while dragging the selection to its new location.

|a. |SHIFT |c. |CTRL |

|b. |ALT |d. |INSERT |

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

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

|a. |asterisk (*) |c. |dollar sign ($) |

|b. |comma (,) |d. |percent sign (%) |

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

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

____ 9. To specify an absolute reference in a formula, enter a(n) __________ before any column letters or row numbers that should be kept constant in formulas copied.

|a. |number sign (#) |c. |dollar sign ($) |

|b. |ampersand (@) |d. |asterisk (*) |

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

____ 11. 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) |

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

____ 13. 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]

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

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

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

Completion

Complete each sentence or statement.

17. To enter the system date, use the _________________________, which is one of 14 date and time functions available in Excel.

18. A cell reference with only one dollar sign before either the column or the row is called a(n) _________________________.

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

20. The leftmost entry in the general form of the IF function, _________________________, is made up of two expressions and a comparison operator.

Excel Project 3

Answer Section

1. F

2. B

3. B

4. C

5. D

6. A

7. D

8. A

9. C

10. D

11. A

12. D

13. B

14. C

15. A

16. C

17. NOW function

18. mixed cell reference

19. IF function

20. logical_test

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

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

Google Online Preview   Download