WorksheetsExcel Lesson 6 Quiz
Total questions: 10
Worksheet time: 5mins
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?
Adjust text orientation
Use the Center alignment command
Use the Merge & Center command
Apply a special character atrribute
How do you display the Mini toolbar?
Left-click a cell
Right-click a cell
Select Format>Mini toolbar
Select View>Mini toolbar
Which Paste Special option pastes only the result of a formula rather than the formula
itself?
Formulas
Values
Formats
Formulas and number formats
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?
Apply another style to the cell.
Use the Undo command.
Clear the cell's content.
Apply the Normal style to the cell
How do you remove a hyperlink?
Delete the cell.
Edit the cell's style.
Reformat the cell
Right-click the cell and select Remove Hyperlink
In which group on the HOME tab is the Clear Formats command located?
In the Editing group
In the Clipboard group
In the Font group
In the Cells group
When you point to defined styles in the Cell Styles gallery, you can see the
formatting that will be used when you apply each style.
True
False
Underlining a cell’s content is the same as adding a border.
True
False
When you delete cells in a worksheet, you remove one or more cells, forcing
other cells to move down or to the right.
True
False
Which of the following can you not copy using Format Painter?
Font color
Bold
Font size
Cell content
