WK1 Excel is Fun Workbook.xlsm Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW OFFICE TAB ACROBAT RulerFormula Bar Split Vicw Side by Side Hide Synchronous Scrolling Panes Unhide l -Reset Window Position Windows Normal Page Break Page custom Zoom 100% Zoom to | New Arrange Freeze Selection Window Switch Macros Gridlines Headings | All Preview Layout Views Workbook Views Show Zoom Window Macros D1 x fr Instructions: d WK1 Excel is Fun Workbook.xism B CD SR 2 Joe 3 Sue 4 Chin 5 Chin 6 Sue 7 Mo 8 Mo 9 Mo 10 Chin SalesData Instructions $338.00 1) Using Defined Names, Name the SalesRep column "SR" and the SalesData column "SalesData". $356.00 2 In the green cells create formulas that will count and sum based on the criteria $212.00 $396.00 $224.00 $106.00Chin $130.00>300 $136.00212 $390.00