To answer question
1, sort the table by "Units" to note the product with highest unit sales is Super Clean Spray Fresh. Now sort the table by "$ Change" to note the product with highest $ Change is Deluxe Spray Orange; hence click in
FALSE button.
To answer question
2, sort the table by "Fragrance" to note a positive % Change in units of every orange scented product sold; hence click in
TRUE button.
To answer question
3, sort the table by % Change in Dollar Sales to find that Mrs. Grime Spray Unscented experienced a 3.8% growth in dollar sales and a 2.5% decline in unit sales from 2009 to 2010; hence click in
FALSE button.
To answer question
4, sort the table by "Average Price" to find Super Clean Aerosol Fresh as the highest-priced product in 2010, which was $0.05 dearer in 2009, whereas the next highest-priced product in 2010 were cheaper in 2009; hence click in
TRUE button.
Note: We don't really need to sort the table by any column to answer questions 1 and 4 here, because in Table Analysis, if a question is about the highest or the least of any column, it's easy to spot, hence no need to sort by the column and waste time on real day.
