They need to be performed to get the file and submit it. Download the attached Excel 2010 file, e02cigym (do not open the file on eLC). Follow the instructions, show your final work to your Lab TA so he or she can score it, and Submit your file to this eLC Assignment Grading Rubric Item Points 1 Perform Preliminary Work a. Get, save and open the file b. Assign range name .2 C. Insert current date function .2 2 Calculate Cost, Annual Total, and Total Due a. Basic annual membership cost function 5 b. Annual total amount function .5 C. First client total amount d. Copy three formulas down 2 3 Determine the Down Payment and Balance a. First client down payment .5 b. Find and correct balance circular .2 reference c. Copy two formulas down 4 Calculate the Monthly Payment a. First client monthly payment 5 b. Copy formula down .2 C. Use mixed cell reference .2 5 Finalize the Workbook Totals on row 14 b. Summary statistics formulas C. Format cells d. Accounting Number format e. Set margins f. Footer g. Save and close. Grade and Submit. Total: Dr. Janine Elyse Aronson August 28, 2012