08 Aug Data validation and how to program Excel
recreate ALL the Exhibits (from 2-1 to 2-10). Be careful to submit the correct worksheet.
*Separate each exhibit on its own sheet, in other words, your workbook must have 10 tabs (or sheets).
In this HW, you will learn to build the:
Income statement
Balance sheet
Cash flow statement
- Create common size statements
- Group data to hide information
- Data validation and how to program Excel to choose 1 of two options (see Exhibit 2-10)
