This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 21 Your answers to the following questions should reflect how you would build a spreadsheet to calculate the values shown in the example. In the spaces provided, record any named cells, tables or ranges used. Name Range Instructions: 1) In cell G11 calculate the monthly fee for the membership type and fitness class. 2) In cell H11 calculate the a subtotal and include the cost of the fitness test 3) In cell I11 calculate the age discount if applicable 4) In cell J11 calculate the cost of HST sales tax 5) In cell K11 calculate the total cost for the gym membership In the spaces provided, state the formulas you would use for each cell. G11
H11
I11
J11
K11 CS100 Review Package Winter 2011 Page 4 of 21 Rearranging Names: The following spreadsheet exercise is designed to help you review the concept of manipulating labels. Note: Each full name in column A has the same format;...
View Full
Document
 Spring '14

Click to edit the document details