Week 6 Assignments

Back
Home
Next
Print formulas for all spreadsheet assignments
Pg 162 to 163 Job 10-1 Create Trip Package Cost Worksheet
 
Pg 164-165 Job 10-2 Price trips Using Goal Seek step 2 formula for Profit margin percent is =(Total income – Total costs)/Total income
 
Pg 166 Job 10-3 Create Profit Margin Report
 
Pg 167 to 168 Job 10-4 Work with Scenarios
 
Pg 171 to 172 Job 10-6 Alphabetize and Filter Lists (Task 1 and 2)
 
Pg 174 to 175 Job 11-1 Design Customer Evaluation Form
 
Pg 176 to 177 Job 11-2 Create Data Entry Worksheet
 
Pg 178 to 179 Job 11-3 Analyze Feedback Data
 
Pg 180 to 181 Job 11-4 Refine and Expand Data Analysis
 
Pg 182 to 184 Job 11-5 Add Conditional Formatting and Create Charts