Name:     ID: 
 
Email: 

Microsoft Excel Lesson 2

True/False
Indicate whether the statement is true or false.
 

 1. 

Numbers that do not fit in the cell are shown as a series of question marks (??????).
 

 2. 

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.
 

 3. 

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.
 

 4. 

A format is the design of text.
 

 5. 

Press the Ctrl+B keys to apply bold.
 

 6. 

The default number format is General, which displays numbers the way you type them.
 

 7. 

You can use the Format Painter to copy formatting only to adjacent cells or ranges.
 

 8. 

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.
 

 9. 

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.
 

 10. 

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 11. 

If you want to specify a precise column width, use the Column Width ____.
a.
wizard
c.
status bar
b.
task pane
d.
dialog box
 

 12. 

____ determines the best width for a column or the best height for a row, based on its contents.
a.
MaxFit
c.
FitNow
b.
FitAuto
d.
AutoFit
 

 13. 

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.
a.
top
c.
right
b.
left
d.
bottom
 

 14. 

Excel ____ all numbers.
a.
right-aligns
c.
top-aligns
b.
left-aligns
d.
bottom-aligns
 

 15. 

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.
a.
Align
c.
Center
b.
Merge
d.
Merge & Center
 

 16. 

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.
a.
shifted to the right
c.
shifted up
b.
shifted to the left
d.
shifted down
 

 17. 

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.
a.
Page Layout
c.
Format
b.
Layout
d.
Page Format
 

 18. 

A ____ is a preset collection of design elements, including fonts, colors, and other effects.
a.
gallery
c.
theme
b.
style
d.
group
 

 19. 

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.
a.
Font
c.
Styles
b.
Edit
d.
Data
 

 20. 

Press the ____ keys to apply underlining.
a.
Ctrl+B
c.
Ctrl+U
b.
Ctrl+L
d.
Ctrl+I
 

 21. 

You can remove the borders from a selected cell by clicking ____ in the border style menu.
a.
Transparent
c.
Blank
b.
Border Off
d.
No Border
 

 22. 

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____  keys.
a.
Ctrl+1
c.
Ctrl+F
b.
Ctrl+A
d.
Ctrl+C
 
 
FIGURE EX 2-1

nar001-1.jpg
 

 23. 

In Figure EX 2-1 above, the cell that shows wrapped text is ____.
a.
A16
c.
A19
b.
A18
d.
A21
 
 
Case EX 2-1
Tessa’s boss has asked her to improve the appearance of a worksheet. Please answer the questions below.
 

 24. 

Tessa wants to find and replace italic text with bold text.  Where can she find the dialog box to do this?
a.
On the Home tab, in the Editing group, click the Find & Select button, and then click Replace.
b.
On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace.
c.
On the Home tab, in the Proofing group, click the Find & Select button, and then click Find.
d.
None of the above.
 

 25. 

Once the Find and Replace dialog box appears, with the Replace tab displayed, what button should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?
a.
Expand
c.
Continue
b.
More
d.
Options
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Style
b.
Font size
c.
Font
d.
Cell style
e.
Font style
 

 26. 

Features such as bold, italic, and underlining that add emphasis to a font.
 

 27. 

A collection of formatting characteristics you apply to a cell or range of data.
 

 28. 

Combination of formatting characteristics such as alignment, font color, and borders.
 

 29. 

The design of text. 
 

 30. 

Determines the height of characters as measured in points.
 



 
         Start Over