Ed has created a worksheet of sales projections, and the numbers change daily. He would like all projected sales figures over 25,000 to display in purple. What is the easiest way to accomplish this?
Sort the range of sales figures every day to see which are the highest, then apply formatting manually.
Use the AutoFilter feature to only display sales over 25,000 and manually apply formatting to these rows.
There is no easy way; Ed must look at each figure and manually apply formatting as appropriate.
Apply conditional formatting to the projected sales figures.
A group of cell format settings (such as font, size and color) which can be applied to a cell is called a(n):
Cell group
Format tab
Format group
Cell style
Which number format does not allow you to control how negative numbers display?
Currency
Custom
Fixed
Accounting
In which of the following locations can you find commands for changing the orientation of text in a cell?
On the Page Layout tab in the Page Setup group
On the Insert tab in the Text group
On the Margins tab of the Page Setup dialog box
On the Home tab, in the Alignment group
When using the Format Cells dialog box to add borders to a cell, you can specify which of the following?
Color of the line
Diagonal lines
Style of the line
You can specify all of these items.
Which feature temporarily changes the appearance of selected cell(s) to the format that your mouse is currently pointing to on the Ribbon?
Gallery View
Format Painter
Format Manager
Live Preview
Jim wants to delete not only data in a cell but also the formatting and comments. One way to do this is to:
Click the backspace button.
Click delete, delete comments, then manually reformat the cell.
Click the delete button.
Click Clear All on the ribbon.
Which tab of the Format Cells dialog box would you use to change the background color of a cell?
Number
Indentation
Font
Fill
What is the difference between clicking the Format Painter once and clicking it twice?
When you click it once, you clear the formatting attributes of the cell, whereas when you click it twice, you restore the formatting attributes of the cell to their original state.
When you click it once, you can apply formatting attributes to only one other cell or cell range, whereas when you click it twice, you replace the contents of the target cell with the contents of the source cell.
When you click it once, you can apply formatting attributes to only one other cell or cell range, whereas when you click it twice, you clear all the formatting from the target cell or cell range.
When you click it once, you can apply the formatting attributes to only one other cell or range, whereas when you click it twice, you can apply the formatting attributes to as many cells or cell ranges as you want until you turn it off.
Bill needs to print his worksheet for a meeting, but he doesn’t have a color printer. He doesn’t want the colored, conditional formatting to make his cells too dark when printing it, so decides he wants to turn off this feature on just the one sheet he is printing. How should he do this?
Click the undo button enough times to reverse all the effects of conditional formatting.
Click Clear, Clear Formats.
Copy the sheet and change the fill color to white.
Click the Conditional Formatting arrow, point to clear rules, then click clear rules from entire sheet.
If you want to apply the Strikethrough effect to the text in a cell, you can use:
You can use any of these methods to apply the Strikethrough effect to text in a cell.
the Strikethrough style in the Styles group.
the Strikethrough button in the Font group.
the Font dialog box.
Mary has extended text that she wants contained in one cell without making the column wider. What should she do?
Avoid using the cells to the right of the cell so all the text will still appear.
Make the affected cell wider.
Use the smallest font possible.
Use the wrap text feature.
The feature that combines more than one cell into one larger cell is called:
Wrap text
Cell group
Cell style
Merge cells
Show Results
Sort the range of sales figures every day to see which are the highest, then apply formatting manually.
Use the AutoFilter feature to only display sales over 25,000 and manually apply formatting to these rows.
There is no easy way; Ed must look at each figure and manually apply formatting as appropriate.
Apply conditional formatting to the projected sales figures.
A group of cell format settings (such as font, size and color) which can be applied to a cell is called a(n):
Cell group
Format tab
Format group
Cell style
Which number format does not allow you to control how negative numbers display?
Currency
Custom
Fixed
Accounting
In which of the following locations can you find commands for changing the orientation of text in a cell?
On the Page Layout tab in the Page Setup group
On the Insert tab in the Text group
On the Margins tab of the Page Setup dialog box
On the Home tab, in the Alignment group
When using the Format Cells dialog box to add borders to a cell, you can specify which of the following?
Color of the line
Diagonal lines
Style of the line
You can specify all of these items.
Which feature temporarily changes the appearance of selected cell(s) to the format that your mouse is currently pointing to on the Ribbon?
Gallery View
Format Painter
Format Manager
Live Preview
Jim wants to delete not only data in a cell but also the formatting and comments. One way to do this is to:
Click the backspace button.
Click delete, delete comments, then manually reformat the cell.
Click the delete button.
Click Clear All on the ribbon.
Which tab of the Format Cells dialog box would you use to change the background color of a cell?
Number
Indentation
Font
Fill
What is the difference between clicking the Format Painter once and clicking it twice?
When you click it once, you clear the formatting attributes of the cell, whereas when you click it twice, you restore the formatting attributes of the cell to their original state.
When you click it once, you can apply formatting attributes to only one other cell or cell range, whereas when you click it twice, you replace the contents of the target cell with the contents of the source cell.
When you click it once, you can apply formatting attributes to only one other cell or cell range, whereas when you click it twice, you clear all the formatting from the target cell or cell range.
When you click it once, you can apply the formatting attributes to only one other cell or range, whereas when you click it twice, you can apply the formatting attributes to as many cells or cell ranges as you want until you turn it off.
Bill needs to print his worksheet for a meeting, but he doesn’t have a color printer. He doesn’t want the colored, conditional formatting to make his cells too dark when printing it, so decides he wants to turn off this feature on just the one sheet he is printing. How should he do this?
Click the undo button enough times to reverse all the effects of conditional formatting.
Click Clear, Clear Formats.
Copy the sheet and change the fill color to white.
Click the Conditional Formatting arrow, point to clear rules, then click clear rules from entire sheet.
If you want to apply the Strikethrough effect to the text in a cell, you can use:
You can use any of these methods to apply the Strikethrough effect to text in a cell.
the Strikethrough style in the Styles group.
the Strikethrough button in the Font group.
the Font dialog box.
Mary has extended text that she wants contained in one cell without making the column wider. What should she do?
Avoid using the cells to the right of the cell so all the text will still appear.
Make the affected cell wider.
Use the smallest font possible.
Use the wrap text feature.
The feature that combines more than one cell into one larger cell is called:
Wrap text
Cell group
Cell style
Merge cells
Show Results