![]() ![]() ![]() |
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 |