Practice Lab Friday March 3

• In this lab you will continues to work with AirlineOperations application.
• Open the SAME file you worked during Graded lab on Wed. Creat new sheet, call it, March3

• Create a Button:
  • Enter Clear Selections in the Text input field.
  • On the Action Tab: Click the Add button, select the Clear All option from the Action list on the right, and click on OK
  • Make a few selections and then click the Button you created above and observe the Action

• Create a Gauge Chart to display the percentage of occupied seats compared to those that were available on each flight. Title the chart: Load Factor %.
  • Expression: Sum ([# Transported Passengers]) / Sum ([# Available Seats])
  • Label: Load Factor %
  • At Presentation Tab: Min and Max values will be 0.5 and 1 respectively
  • Add 2 more segments
  • Segment 1:Lower Bound: 0.5, Color: Red
  • Segment 2:Lower Bound: 0.625 Color: Orange
  • Segment 3:Lower Bound: 0.75, Color: Yellow
  • Segment 4:Lower Bound: 0.85, Color: Green
  • On the Presentation tab, select: Show Scale, Show Labels on Every Major Unit, Hide Segment Boundaries, and Hide Gauge Outlines.
  • Set the value of Show Scale to 6 Major Units, set the value of Show Labels on Every to 1 Major Unit
  • Number Format: Integer and Show in Percent (%).
• Make selection and compare results on the Gauge and other charts that display Load Factor