Response Questions Part A To C A) Show For mula How You Do It On Excel: cell H8 should be formatted using the Subhead cell style. B) Show Formula How You Do It On Excel: the range H7:07 should contain a linear trend. C) Show For mula How You Do It On Excel: the range H9:09 should contain a projection based on a growth series. E F H I J K L M N O un AwNN D Media Hub Audio Books United States G Date: Price per book: $ 8.95 Download Projections May Apri 2,215 803 3,011 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Solence fiction 11 Self-help 12 Total 14,000 Downloads: January - April February March 2,282 2,130 1,036 798 2,788 2,239 2,655 3,244 1,869 1,904 1,095 1,124 11,725 11,439 January 2,193 989 2,405 2.397 1,873 1,027 10,884 Total 8,820 3,626 10,443 11,065 7,520 4,252 45.726 Increase dowbads to 14,000 n December 11,432 Increase downloads by 3% per month 11,432 2,769 1,874 1,006 11,678 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total January 19,627.35 8,851.55 21,524.75 21,453.15 16,763.35 9,191.65 $97,411.80 Sales: January - Apri February March 20,423.90 19,063.50 9,272.20 7.142.10 24,952.60 20,039.05 23,762.25 29,033.80 16,727.55 17,040.80 9 ,800.25 10,059.80 $ 104,938.75 $ 102,379.05 Apri 19,824.25 7,186.85 26,948.45 24,782.55 16,772.30 9,003.70 $ 104,518.10 Total 78,939.00 32,452.70 93,464.85 99,031.75 67,304.00 38,055.40 $ 409,247.70 Response Questions Part A To C A) Show For mula How You Do It On Excel: cell H8 should be formatted using the Subhead cell style. B) Show Formula How You Do It On Excel: the range H7:07 should contain a linear trend. C) Show For mula How You Do It On Excel: the range H9:09 should contain a projection based on a growth series. E F H I J K L M N O un AwNN D Media Hub Audio Books United States G Date: Price per book: $ 8.95 Download Projections May Apri 2,215 803 3,011 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Solence fiction 11 Self-help 12 Total 14,000 Downloads: January - April February March 2,282 2,130 1,036 798 2,788 2,239 2,655 3,244 1,869 1,904 1,095 1,124 11,725 11,439 January 2,193 989 2,405 2.397 1,873 1,027 10,884 Total 8,820 3,626 10,443 11,065 7,520 4,252 45.726 Increase dowbads to 14,000 n December 11,432 Increase downloads by 3% per month 11,432 2,769 1,874 1,006 11,678 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total January 19,627.35 8,851.55 21,524.75 21,453.15 16,763.35 9,191.65 $97,411.80 Sales: January - Apri February March 20,423.90 19,063.50 9,272.20 7.142.10 24,952.60 20,039.05 23,762.25 29,033.80 16,727.55 17,040.80 9 ,800.25 10,059.80 $ 104,938.75 $ 102,379.05 Apri 19,824.25 7,186.85 26,948.45 24,782.55 16,772.30 9,003.70 $ 104,518.10 Total 78,939.00 32,452.70 93,464.85 99,031.75 67,304.00 38,055.40 $ 409,247.70
