Response Questions Part A TOD A) Show Formula How You Do It On Excel: In cell B6, enter a formula using the SUM function and a 3D reference to total the number of downloads of Adventure audio books in January (cell B6) in the United States, Canada, and Australia. B) Show Formula How You Do It On Excel: Copy the formula in cell B6 to calculate the number of downloads for the other types of books and months (ranges B7:B11 and C6:E11), pasting the formula only. C) Show Formula How You Do It On Excel: In cell B16, enter a formula using the SUM function and a 3D reference to total the sales of Adventure audio books in Jamuary (cell B16) in the United States, Canada, and Australia. D) Show Formula How You Do It On Excel: Copy the formula in cell B16 to calculate the sales for the other types of books and months (ranges B17:B21 and C16:E21), pasting the formula only. Media Hub Audio Books All Locations Downloads: January - April February March January Total 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Science fantasy 11 Self-help 12 Total Sales: January - April February March January Apri Total 14 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total 23 Total sales last year (Jan-Apr) 3 United States H I J K L M N O P Media Hub Audio Books United States G Date: Price per book $ 8.95 Download Projections May 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Science fiction 11 Self heb January 2,193 989 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 Aori 2215 803 3.011 2.769 1,874 1,006 11,678 Total 8,820 3,626 10,443 11,065 Increase dowbads to 14,000 in December 11,432 Increase downloads by 3% per month 11,432 7,520 4,252 45,726 13 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self heb 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 - April February March 2 0,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 1 7,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,77.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 Canada A B E F H I J K L M N O C D Media Hub Audio Books Canada G Date: Price per book: $ 9.95 + WN Apri 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Science fiction 11 Self-help 12 Total 10,000 January 968 689 1,205 1,097 773 707 5,439 Downloads: January - Apri February March 1,082 1,120 836 708 1,288 1,339 1,055 1,144 879 904 795 5,935 6,039 1,015 640 1,411 1,469 1,074 866 6,475 Download Projections May Increase downbads to 10,000 in December 5,972 Increase downloads by 3% per month 5,972 Total 4,185 2,873 5,243 4,765 3,630 3,192 23,888 824 14 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-heb 22 Total Sales: January - April January February March 9,631.60 10,765.90 11,144.00 6,855.55 8,318.20 7,044.60 11,989.75 12,815.60 13,323.05 10,915.15 10,497.25 11,382.80 7,691.35 8,746.05 8,994.80 7,034.65 7 ,910.25 8,198. 80 $ 54,118.05 $ 59,053.25 $ 60,088.05 Apri 10,099.25 6,368.00 14,039.45 14,616.55 10,686.30 8 ,616.70 $ 64,426.25 Total 41,640.75 28,586.35 52,167.85 47,411.75 36,118.50 31,760.40 $ 237,685.60 Australia A B E F H I J K L M N O C D Media Hub Audio Books Australia G Date: Price per book: $ 10.95 January Download Projections May Increase downbads to 5500 in December 652 Downloads: January - April February March 705 265 928 1,052 759 227 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Science fiction 11 Self-hep 12 Total 3,742 April 812 303 1,175 736 5,500 189 805 497 Total 2,928 984 3,960 2,495 3,370 1,232 14,969 Increase downloads by 3% per month 3,742 610 652 712 973 227 3,082 799 281 3,551 886 335 ,948 389 4,388 3 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total 23 January 7,139.40 2,069.55 8,814.75 5,442.15 7,796.40 2,485.65 $33,747.90 Sales: January - Apri February March 7,723.40 8,307.40 2,485.65 2,901.75 10,165.25 11,515.75 6,679.50 7,139.40 8,749.05 9,701.70 3,076.95 3 ,668.25 $ 38,879.80 $ 43,234.25 April 8,891.40 3,317.85 12,866.25 8,059.20 10,654.35 4,259.55 $ 48,048.60 Total 32,061.60 10,774.80 43,362.00 27,320.25 36,901.50 13,490.40 $ 163,910.55 Response Questions Part A TOD A) Show Formula How You Do It On Excel: In cell B6, enter a formula using the SUM function and a 3D reference to total the number of downloads of Adventure audio books in January (cell B6) in the United States, Canada, and Australia. B) Show Formula How You Do It On Excel: Copy the formula in cell B6 to calculate the number of downloads for the other types of books and months (ranges B7:B11 and C6:E11), pasting the formula only. C) Show Formula How You Do It On Excel: In cell B16, enter a formula using the SUM function and a 3D reference to total the sales of Adventure audio books in Jamuary (cell B16) in the United States, Canada, and Australia. D) Show Formula How You Do It On Excel: Copy the formula in cell B16 to calculate the sales for the other types of books and months (ranges B17:B21 and C16:E21), pasting the formula only. Media Hub Audio Books All Locations Downloads: January - April February March January Total 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Science fantasy 11 Self-help 12 Total Sales: January - April February March January Apri Total 14 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total 23 Total sales last year (Jan-Apr) 3 United States H I J K L M N O P Media Hub Audio Books United States G Date: Price per book $ 8.95 Download Projections May 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Science fiction 11 Self heb January 2,193 989 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 Aori 2215 803 3.011 2.769 1,874 1,006 11,678 Total 8,820 3,626 10,443 11,065 Increase dowbads to 14,000 in December 11,432 Increase downloads by 3% per month 11,432 7,520 4,252 45,726 13 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self heb 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 - April February March 2 0,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 1 7,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,77.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 Canada A B E F H I J K L M N O C D Media Hub Audio Books Canada G Date: Price per book: $ 9.95 + WN Apri 5 Book Type 6 Adventure 7 Literary 8 Mystery 9 Romance 10 Science fiction 11 Self-help 12 Total 10,000 January 968 689 1,205 1,097 773 707 5,439 Downloads: January - Apri February March 1,082 1,120 836 708 1,288 1,339 1,055 1,144 879 904 795 5,935 6,039 1,015 640 1,411 1,469 1,074 866 6,475 Download Projections May Increase downbads to 10,000 in December 5,972 Increase downloads by 3% per month 5,972 Total 4,185 2,873 5,243 4,765 3,630 3,192 23,888 824 14 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-heb 22 Total Sales: January - April January February March 9,631.60 10,765.90 11,144.00 6,855.55 8,318.20 7,044.60 11,989.75 12,815.60 13,323.05 10,915.15 10,497.25 11,382.80 7,691.35 8,746.05 8,994.80 7,034.65 7 ,910.25 8,198. 80 $ 54,118.05 $ 59,053.25 $ 60,088.05 Apri 10,099.25 6,368.00 14,039.45 14,616.55 10,686.30 8 ,616.70 $ 64,426.25 Total 41,640.75 28,586.35 52,167.85 47,411.75 36,118.50 31,760.40 $ 237,685.60 Australia A B E F H I J K L M N O C D Media Hub Audio Books Australia G Date: Price per book: $ 10.95 January Download Projections May Increase downbads to 5500 in December 652 Downloads: January - April February March 705 265 928 1,052 759 227 5 Book Type 6 Adventure 7 Lterary 8 Mystery 9 Romance 10 Science fiction 11 Self-hep 12 Total 3,742 April 812 303 1,175 736 5,500 189 805 497 Total 2,928 984 3,960 2,495 3,370 1,232 14,969 Increase downloads by 3% per month 3,742 610 652 712 973 227 3,082 799 281 3,551 886 335 ,948 389 4,388 3 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total 23 January 7,139.40 2,069.55 8,814.75 5,442.15 7,796.40 2,485.65 $33,747.90 Sales: January - Apri February March 7,723.40 8,307.40 2,485.65 2,901.75 10,165.25 11,515.75 6,679.50 7,139.40 8,749.05 9,701.70 3,076.95 3 ,668.25 $ 38,879.80 $ 43,234.25 April 8,891.40 3,317.85 12,866.25 8,059.20 10,654.35 4,259.55 $ 48,048.60 Total 32,061.60 10,774.80 43,362.00 27,320.25 36,901.50 13,490.40 $ 163,910.55