Excel1



University of Massachusetts Boston

College of Management

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

Excel Project 1: Worksheets & Charting Q & A

True/False

Indicate whether the sentence or statement is true or false.

____ 1. To start Excel, Windows must be running.

____ 2. A new workbook opens with three worksheets, but additional worksheets can be added up to a maximum of 255.

____ 3. To identify a cell, specify the row number first, followed by the column letter.

____ 4. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as these cells contain no data.

____ 5. The area on a worksheet where a chart displays is called the chart location.

____ 6. A password can be up to 15 characters long and is case-sensitive, meaning Excel can differentiate between uppercase and lowercase letters.

____ 7. If, when a workbook is saved, a password is assigned but later forgotten, the workbook still can be accessed.

____ 8. If a workbook is closed, click the New button on the Standard toolbar or click the New command on the File menu to begin working on the next workbook.

Multiple Choice

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

____ 9. The active cell can be identified in all of the following ways except __________.

|a. |a block arrow displays in the center of the cell |

|b. |the active cell reference displays in the Name box |

|c. |a heavy border surrounds the cell |

|d. |the column heading and row heading are highlighted |

____ 10. To complete an entry into a cell, click the __________.

|a. |Enter box |c. |Cancel box |

|b. |Function box |d. |Name box |

____ 11. Numbers can contain all of the following characters except __________.

|a. |+ - ( ) |c. |0 % E e |

|b. |, / . $ |d. |& @ ! ~ |

____ 12. Excel’s __________ provides a convenient way to add the numbers in cells.

|a. |AVERAGE function |c. |COUNT function |

|b. |SUM function |d. |INT function |

____ 13. The __________ defines the appearance and shape of letters, numbers, and special characters.

|a. |font type |c. |font form |

|b. |font size |d. |font style |

____ 14. When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) __________.

|a. |Line chart |c. |Pie chart |

|b. |Column chart |d. |Scatter chart |

____ 15. In the Save As dialog box, the __________ displays a list of shortcuts (pointers) to the most recently used files in a folder titled Recent.

|a. |My Documents button |c. |History button |

|b. |Desktop button |d. |Favorites button |

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

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

Google Online Preview   Download