Name:
_____________________________ Class:________________ Date:____________ ID: A
Excel Lesson 2
True/False
Indicate whether the sentence or statement is true or false.
1. Wrapping will create a new line of text within a cell. T ______ F ______
2. Rotating will move text from the right side of the cell to the left side of the cell. T ______ F ______
3. Text in a cell may be aligned by clicking toolbar buttons or by choosing the Cells command on the Format menu. T ______ F ______
4. The color of the text in a cell may not be changed. T ______ F ______
5. Borders may be placed on any or all sides of a cell or range. T ______ F ______
6. You can widen a column by using the Column Width dialog box. T ______ F ______
7. The Merge and Center alignment button is commonly used to center a title across the top of a worksheet.
T ______ F ______
8. In order to change a cell’s appearance, you must first select the cell you want to change.
T _______ F ______
9. To paint a format, you must highlight the cell that you want to format. T _______ F ______
10. You can remove the formats you apply to a cell by choosing Clear on the Tools menu.
T _______ F ______
Multiple Choice
Identify the letter of
the choice that best completes the statement or answers the question.
11. When data is wider than the column, Excel will display the _____ symbol.
a. ##### c. &&&&&
b. $$$$$ d. ******
12. The ____ tab
in the Format Cells dialog box contains the options for wrapping and rotating
text.
a. Wrapping c. Orientation
b. Alignment d. Position
13. The ____ button on the Formatting toolbar is represented by a bucket of paint.
a. Format Painter c. Fill Color
b. Drawing d. Font Color
14. Which of the following occurs when a format is painted in a cell or range?
a. The data, but not the format, of the source cell is copied to the destination cell.
b. The format and data of the source cell is copied to the destination cell.
c. The format, but not the data, of the source cell is copied to the destination cell.
d. Color is added to all cells that have been selected.
15. You would use the ____ to copy a cell’s format to another cell.
a. Format Painter c. Format Copier
b. Conditional formatting d. Cell Painter
16. Formats that have already been created within Excel are called ___________.
a. Text Formats c. General Formats
b. Number Formats d. Auto Formats
17. The AutoFit Selection option is found on the Column submenu of the ______________ menu.
a. c.
b. d.
18. Excel automatically _______________ - aligns a text entry in a cell.
a. c.
b. d.
19. Arial and Times New Roman are examples of _____________.
a. c.
b. d.
20. The _____________________ format displays data in a format designed by the user.
a. c.
b. d.
21. A(n) ___________________ icon identifies the Format Painter button on the toolbar.
a. c.
b. d.
Matching
Match the format name that follows
with the display description below.
a. General d. Number
b. Scientific e. Special
c. Text
____ 22. Displays numerical data that will not be used for calculation
____ 23. Displays either text or numerical data as keyed
____ 24. Displays numerical data that requires a specific format
____ 25. Displays numerical data with a fixed number of places to the right of the decimal point
____ 26. Displays numerical data in exponential notation
Match the following text positions with the
description of their appearance.
a. Centered c. Wrapped
b. Rotated d. Indented
____ 27. Begins a new line within the cell
____ 28. Displays text at an angle
____ 29. Moves the text several spaces to the right
____
30. Places text in the
middle of the cell