Response Questions Part A TOC A) H Show Formula How You Do It On Excel: the formula in cell H1 should contain the TODAY function. A B C D E G Media Hub Audio Books Date: United States Price per book: $ B) Show For mula How You Do It On Excel: cells in the range 15:05 should contain the auto-filled values. - G H I K L M N Media Hub Audio Books United States Price per book $ 8.95 8.95 O Date: Download Projections Total May 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Scence fiction 11 Self-help 12 Total January 2,193 999 2,405 2,397 1,873 1,027 10,884 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 April 2,215 803 3,011 2,769 1,874 8,820 3,626 10,443 11,065 7,520 4,252 45,726 Increase downbads to 14,000 n December 11,432 Increase downloads by 3% per month 11,432 1,006 11678 Total 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self heb 22 Total January 19,62735 8,851.55 21,524.75 21,453.15 16,763.35 9,191.65 $97,411.80 Sales January - April February March 2 0,423.90 19,063.50 9 ,272.20 7 .142.10 24,952.60 2 0,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 April 19,824.25 7.186.85 26,948.45 24,782.55 16,772.30 9 ,003.70 $ 104,518.10 78,939.00 32,452.70 93, 464.85 99,081.75 67,304.00 38,055.40 $ 409,247.70 C) Show For mula How You Do It On Excel: the Subhead cell style should use the Black, Text 1 font color; the White, Background 1, Darker 5% fill color; and the Italic font style. H I J K L M N O Media Hub Audio Books United States G Date: Price per book: $ 8.95 Download Projections May Increase downbads to 14,000 in December 11,432 14,000 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Science fiction 11 Self-help 12 Total January 2,193 989 2,405 2,397 1,873 1,027 10,894 Downloads: January - Apri 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 April 2,215 803 3,011 2,769 1,874 1,006 11,678 Total 8,820 3,626 10,443 11,065 7,520 4,252 45,726 Increase downloads by 3% per month 11,432 15 Book Type 16 Adventure 17 Lterary 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 7142.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 April 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
