Question

5. You need to format a block of financial information so that the figures are showing the correct currency symbol. How can you do this? Select all options that apply. Click on the Number Format drop-down in the Number group on the Home Ribbon and choose Currency. The currency symbol will need to be typed in the cell with the numbers. Right click on the cell and choose Format Cells. Click on the currency symbol in the Number group on the Home Ribbon. 6. You are creating a spreadsheet to track new stock. Each product that you are listing will be assigned a category code which will simply be two letters. You can see that Column G is not wide enough to fully display the heading Sales Category. As the entries underneath the heading will only ever be two letters, you do not want to widen the column. How can you format the heading so that both words will be visible? Sales Category E F G H I Item Sales Cate Amount Use the Wrap Text feature. Use the Merge Cells Feature. Use the Center button in the Alignment group on the Home Ribbon.

          5. You need to format a block of financial information so that the figures are showing the correct currency symbol.
How can you do this? Select all options that apply.
Click on the Number Format drop-down in the Number group on the Home Ribbon and choose Currency.
The currency symbol will need to be typed in the cell with the numbers.
Right click on the cell and choose Format Cells.
Click on the currency symbol in the Number group on the Home Ribbon.
6. You are creating a spreadsheet to track new stock. Each product that you are listing will be assigned a category
code which will simply be two letters. You can see that Column G is not wide enough to fully display the heading
Sales Category. As the entries underneath the heading will only ever be two letters, you do not want to widen the
column. How can you format the heading so that both words will be visible?
Sales Category
E F G H I
Item Sales Cate Amount
Use the Wrap Text feature.
Use the Merge Cells Feature.
Use the Center button in the Alignment group on the Home Ribbon.

5. You need to format a block of financial information so that the figures are showing the correct currency symbol.
How can you do this? Select all options that apply.
Click on the Number Format drop-down in the Number group on the Home Ribbon and choose Currency.
The currency symbol will need to be typed in the cell with the numbers.
Right click on the cell and choose Format Cells.
Click on the currency symbol in the Number group on the Home Ribbon.
6. You are creating a spreadsheet to track new stock. Each product that you are listing will be assigned a category
code which will simply be two letters. You can see that Column G is not wide enough to fully display the heading
Sales Category. As the entries underneath the heading will only ever be two letters, you do not want to widen the
column. How can you format the heading so that both words will be visible?
Sales Category
E F G H I
Item Sales Cate Amount
Use the Wrap Text feature.
Use the Merge Cells Feature.
Use the Center button in the Alignment group on the Home Ribbon.

Added by Gary B.

Question

Please give Ace some feedback