Working with Alignment Group Commands - Exercise

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

Working with Alignment Group Commands

Duration: 10 to 15 minutes.

In this exercise, you will use commands found on the Alignment 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 Alignment 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:Final Spreadsheet

Solution:

  1. Open or go to the specified file.
  2. Select cells B1:E1 and click the Center command:Center Selected Cells
  3. Select cells A3 and A4 and click the Increase Indent command:Increase Indent of Selected Cells
    1. Repeat for cells A7:A9.
  4. Select cell A5 and click the Wrap Text command:Wrap Text in Selected Cell
    1. Repeat for cells A10 and A11.
  5. Save the workbook.
Next