G H F E Monthly Credit Card Payment Bank Cred 20500 Processing Fee Total Credit Card Value 0.004 Credit Car 0.24 Credit Card Payment Term Number o 2 2. Credit Card Payment Total Credit Card Amount Name this sheet I Name this sheet Lion Mode: Automatic Grade Out of Instructions Format the spreadsheet so it look professional (expand cells, use boarders, use proper number formats, Highlight headings - Centre the information and use wrap text where appropriate. Use cell styles and merage centre similar to what was done in the class where appropriate. Use any colour. Put dollar signs and percentage where appropriate Merge Centre A3: E8 and Insert the Wal-Mart Rewards card logo Merge and Center the Bi-Weekly Credit Card Payment and Monthly Credit Card Payment (3 cells) Q R Calculate the Processing fee (similar to a tax) and Total Credit car value for both Bi-Weekly and Monthly Calculate the Bi-Weekly Credit Card Payment using the appropriate formula Calculate the Monthly Credit Card Payment using the appropriate formula NINI 5 Calculate the Total Credit Card Amount for Bi-Weekly Credit Card Payment Calculate the Total Credit Card Amount for Monthly Credit Card Payment Calculate the Total Credit Card Amount for the Bi-Weekly Credit Card Payment Calculate the Total Credit Card Amount for the Monthly Credit Card Payment In cell B25 - calculate the difference between Bi-Weekly total Amount of the Credit Card and Monthly Amount of the Credit Card How much more or less are you paying? 5 In Cell B26 - calculate the difference between Bi-Weekly Total Amount of interest paid and Monthly Amount of interest paid. How much or or less are you paying