4.2 Introduction

This case contains challenges that focus on sports.

This case contains the following challenges:

• Triple Race: This challenge will calculate the total time for a triple race (5K, 10K, Half marathon), calculate the pace in both kilometers and miles per hour, then calculate if the runner would qualify for a full marathon.

• Race Results: This challenge will calculate the total time for a triple race (5K, 10K, Half marathon), then use Time and Text functions to create a string with details for each runner. The data is then copied to a new worksheet, and the unwanted data and records for runners that didn’t complete all three parts are removed, leaving the data ready to export to the owner.

• Soccer Offsides Penalty: This challenge uses Boolean functions to determine whether a player should be called for an offsides penalty.