Excel Lesson 6 Knowledge Assessment

1.  You want to insert a cell into your worksheet. Which command so you use? 

• 1.  You want to insert a cell into your worksheet. Which command so you use? 
• The Format command in the Cells group on the HOME tab
• The Format Painter command in the Clipboard group on the HOME tab
• d.  The Format command in the shortcut menu when you right-click a cell

2.  You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which alignment option do you choose?

• a.  Center
• middle align
• justify
• distributed

3.  You want to fit a long column heading into a small space without changing the font size or column width. Which of the following is the best choice?

• a.  Adjust text orientation.
• b.  Use the Center alignment command.
• c.  Use the Merge & Center command.
• d.  Apply a special character attribute.

4.  How do you display the Mini toolbar?

• a.  Left-click a cell.
• b.  Right-click a cell.
• c.  Select Format > Mini toolbar.
• d.  Select View > Mini toolbar.

5.  Which of the following can you not copy using Format Painter?

• a.  Font color
• b.  Bold
• c.  Font size
• d.  Cell content

6.  Which Paste Special option pastes only the result of a formula rather than the formula itself?

• a.  Formulas
• b.  Values
• c.  Formats
• d.  Formulas and number formats

7.  You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

• a.  Apply another style to the cell.
• b.  Use the Undo command.
• c.  Clear the cell’s content.
• d.  Apply the Normal style to the cell.

8.  How do you remove a hyperlink?

• a.  Delete the cell.
• b.  Edit the cell’s style.
• c.  Reformat the cell.
• d.  Right-click the cell and select Remove Hyperlink.

9.  In which group on the HOME tab is the Clear Formats command located?

• a.  In the Editing group
• b.  In the Clipboard group 
• c.  In the Font group
• d.  In the Cells group

10.  Which of the following is not useful for changing the font size?

• a.   Font Size drop-down list
• b.   Increase Font Size button
• c.    Decrease Font Size button
• d.   Orientation button