Excel1 - Offices and Directory - University of ...
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 |
Excel1
Answer Section
TRUE/FALSE
1. T
2. T
3. F
4. T
5. T
6. T
7. F
8. T
MULTIPLE CHOICE
9. A
10. A
11. D
12. B
13. A
14. B
15. C
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- university of scranton tuition and fees
- university of minnesota college of education
- university of minnesota school of social work
- university of illinois directory champaign
- wharton school of the university of pennsylvania
- cost of university of scranton
- directory university of illinois champaign
- university of illinois track and field
- employee directory state of nc
- university of michigan sat scores and gpa
- kwame nkrumah university of science and tech
- university of alabama directory search