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