Sunday, November 24, 2013

Excel Penny Puzzle and New Flag for Xytanium





Part 1)  In return for your valient service in battle during the war against the Flembots, King Coppernium gives you a choice for your reward. Option (A) is to receive 1 million dollars up front at the start of the month, this being the month of May. Option (B) is to receive 1 penny on May 1st, which doubles in value each day until the end of the month.With option B, you can't receive payment until May 31st. Which option would or should you choose?  Set up an Excel table and a formula to show why.


Also, create a line graph using Excel that shows the growth of the penny throughout the month of May.
It should look something like this:

Part 2)  Create the New Flag for Xytanium (a hypothetical new country on the map)!  Use Excel's graphic functions like changing color backgrounds and foregrounds, inserting shapes and text, inserting lines or pics with novel formatting (bevel, shadow, frames, etc.) functions.  Here's an example:



Remember to Save your work as an Excel Workbook file with your first and last name and then g-mail it to me as an attachment to  rwiegs@gmail.com 
Don’t forget to Cc yourself (send it to your own e-mail address as well).

If you have any questions about this assignment, please don't hesitate to ask!




No comments:

Post a Comment