In the spaces provided record any named cells tables

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online