SPREADSHEET SBA 2016 GUIDELINES
Download the latest Masqueraders2 spreadsheet file from your Edmodo Backpack, open it and use the instructions below to continue your work. REMEMBER TO SAVE THE SPREADSHEET AS YOU COMPLETE EACH NUMBERED TASK.

Masqueraders3

1. Save Masqueraders2 as Masqueraders3 2. Perform the instructions at (a) to (c) on your SBA project sheet. 3. To perform instruction (d) do the following: a. In the first section, highlight from the First Name or Last Name column heading (whichever comes first) to the Total Payment (US$) heading then down to the second to last row. b. Access the Data menu i. Select Sort ii. Select Total Payment JA$ from the drop-down list beside ‘Sort by’. iii. Select Descending (i.e. Largest to Smallest) then OK. c. Repeat steps (a) and (b) (i) – (iii) for the second section. 4. To perform instruction (e) do the following: a. In the third section, highlight from the First Name or Last Name column heading (whichever comes first) to the Total Payment (JA$) heading then down to the second to last row. b. Access the Data menu i. Select Sort ii. Select Last Name from the drop-down list beside ‘Sort by’. iii. Select Ascending (i.e. A to Z). iv. Click the ‘Add Level’ button v. Select Total Payment (JA$) from the drop-down list beside ‘Then by’. vi. Select Ascending (i.e. Smallest to Largest) then OK. c. Repeat steps (a) and (b) (i) – (v) for the fourth section. 5. To perform instruction (f) do the following: a. Highlight the summary table. b. Insert Chart c. Select either a bar or column chart. d. Give your chart an appropriate title. (This would be the purpose of the chart as stated in the instruction on your SBA project sheet. Do NOT begin title with words such as “The”). e. Label the x-axis and y-axis appropriately. f. Place the