WK1 Excel is Fun Workbook.xlsm -Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW OFFICE TAB ACROBAT Split 1 T9 View side by side Hide Synchronous ScrollingSwitch Ruler Formula Bar Normal Page Break Page CustomGridlines Headings Macros Zoom 100% Zoom to! New Arrange Freeze Preview Layout Views Workbook Views Selection Window All Panes Unhide Unhide 131-Reset Window Position "Windows Reset Window Position Windo Show Zoom Window Macros M31 dWK1 Excel is Fun Workbook.xlsm 4 20,527 40,66346,39831,802 41,11542,22152,93619,412 52,83353.879 5 51,50053,360 18,407 33,099 13,06334,761 41,98351,034 24,45626,970 6 45,25621,315 15,10313,33037,96454,84938,53038,939 16,25044,911 7 34,78820,66636,01933,587 46,34924,60436,651 24,834 30,191 35,117 8 34,03417,822 40,27331,79522,175 28,69851,11649,923 47,916 18,273 37,065 21,700 28,515 22,040 25,10342,83340,231 37,742 44,545 27,536 10 Criteria Total Number of Observations: Highest Price Lowest Price Average Price Sum (Total Revenue) Count Cars more than $30,000 Sum total Revenue for Cars more than $30,000 Standard Deviation for the population Highest Price 12 13 14 15 16 17 18 19 20 Tom 21 Pham 22 Tom 23 Pham 24 Sioux 25 Sioux 26 Tom 27 Pham 28 Pham 30000 30000 COUNTA: "Count words", "Count non-empty cells Count SalesRep SalesRep Sales $288.00 $306.00 $162.00 346.00 $174.00 $56.00 $80.00 $86.00 $340.00 Criteria Count Sum 200 >=174 Tom Great thar Greater than or equal to Less than 31 WK1 Excel is Fun Workbook.xlsm -Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW OFFICE TAB ACROBAT Split 1 T9 View side by side Hide Synchronous ScrollingSwitch Ruler Formula Bar Normal Page Break Page CustomGridlines Headings Macros Zoom 100% Zoom to! New Arrange Freeze Preview Layout Views Workbook Views Selection Window All Panes Unhide Unhide 131-Reset Window Position "Windows Reset Window Position Windo Show Zoom Window Macros M31 dWK1 Excel is Fun Workbook.xlsm 4 20,527 40,66346,39831,802 41,11542,22152,93619,412 52,83353.879 5 51,50053,360 18,407 33,099 13,06334,761 41,98351,034 24,45626,970 6 45,25621,315 15,10313,33037,96454,84938,53038,939 16,25044,911 7 34,78820,66636,01933,587 46,34924,60436,651 24,834 30,191 35,117 8 34,03417,822 40,27331,79522,175 28,69851,11649,923 47,916 18,273 37,065 21,700 28,515 22,040 25,10342,83340,231 37,742 44,545 27,536 10 Criteria Total Number of Observations: Highest Price Lowest Price Average Price Sum (Total Revenue) Count Cars more than $30,000 Sum total Revenue for Cars more than $30,000 Standard Deviation for the population Highest Price 12 13 14 15 16 17 18 19 20 Tom 21 Pham 22 Tom 23 Pham 24 Sioux 25 Sioux 26 Tom 27 Pham 28 Pham 30000 30000 COUNTA: "Count words", "Count non-empty cells Count SalesRep SalesRep Sales $288.00 $306.00 $162.00 346.00 $174.00 $56.00 $80.00 $86.00 $340.00 Criteria Count Sum 200 >=174 Tom Great thar Greater than or equal to Less than 31
