Page > of Excel Basics C 14 Total A B D 1 Smythe Books 2 For the year ended December 31 3 4 Sales Dollars 5 E-Book children's $ 274,600 6 E-Book fiction $ 208,200 7 E-Book nonfiction $ 609,100 8 Hardcover children's $ 179,850 9 Hardcover fiction $ 886,500 10 Hardcover nonfiction $ 603,400 11 Paperback children's $ 318,700 12 Paperback fiction $ 1,369,200 13 Paperback nonfiction $ 679,300 $ 5,128,850 15 16 17 Royalties Sales Dollars Royalty Rate Total Royalties 18 Total E-Book 25% 19 Total Hardcover 10% 20 Total Paperback 5% 21 Note: A royalty is the amount of money paid to the author for books that have been sold. 22 23 Sales by Genre Sales Dollars 24 Total Children's 25 Total Fiction 26 Total Nonfiction 27 28 Hardcover compared to Paperback: 29 Difference in total sales dollars 30 Difference in total royalties 31 32 E-Book compared to Paperback: 33 Difference in total sales dollars 34 Difference in total royalties Page of 2 Requirements: 1. Indicate the unique address (cell reference) for the cell that contains the sales data for Hardcover nonfiction. 2. Indicate the unique address (cell reference) for the cell that contains the total sales data. 3. Indicate the unique address (cell reference) for the cell that contains the E-book royalty rate. 4. Write out the formula you would input into Cell B18. 5. Write out the formula you would input into Cell B19. 6. Write out the formula you would input into Cell B20. 7. Write out the formula you would input into Cell D19. 8. Write out the formula you would input into Cell B24. 9. Write out the formula you would input into Cell B25. 10. Write out the formula you would input into Cell B26. 11. Write out the formula you would input into Cell B29. 12. Write out the formula you would input into Cell B34