University of Massachusetts Boston



University of Massachusetts Boston

College of Management

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

Excel Project 2 Q & A

True/False

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. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.

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

____ 4. Including the wrong cell reference in a formula is one of the least common mistakes made with Excel.

____ 5. The formulas version of a worksheet displays the actual formulas entered, rather than the resulting values.

____ 6. Sheet names can be up to 31 characters (including spaces) in length.

Multiple Choice

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 the sheet displaying on the screen or the selected sheets.

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

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

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

Completion

Complete each sentence or statement.

17. _________________________ can be used in a formula to override the order of operations.

18. Excel includes prewritten formulas called _________________________ that take a value or values, perform an operation, and return a result to the cell.

19. The _________________________ is a format that displays a dollar sign to the left of a number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place).

20. When using conditional formatting, a(n) _________________________, which is made up of two values and a relational operator, is true or false for each cell in a range.

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

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

Google Online Preview   Download