Working with Number Group Commands - Exercise

Contact Us or call 1-877-932-8228
Working with Number Group Commands - Exercise

Working with Number Group Commands

Duration: 10 to 15 minutes.

In this exercise, you will use commands found on the Number group to continue formatting the profit & loss statement for Dave's Lemonade Stand.

  1. Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Working with Number Group Commands.xlsx from your Excel2013.1/Exercises folder.
  2. Format the profit & loss statement for Dave's Lemonade Stand so that it looks like the below:

Solution:

  1. Open or go to the specified file.
  2. Select cells B1:E1:
  3. On the HOME tab, in the Number group, click the Dialog Box Launcher:
  4. In the Format Cells dialog box, in the Number tab, select Date in the Category box and choose the "Mar-12" format from the Type box and click OK:
  5. Select cells B3:E4:
  6. On the HOME tab, in the Number group, click the Comma Style command:
  7. On the HOME tab, in the Number group, click the Decrease Decimal command:
  8. Save the workbook.
Next