Bonus Exercise 1 Overview: Calculate Trip Cost

Duration: 30 minutes

In this bonus exercise, you will learn how to use Excel-like formulas to add cost calculations for a travel request. Our goal here is to use a per diem rate multiplied by number of days, added to the estimated airfare cost to get an estimated total trip cost.

2.1: Creating Calculations

Learn to add automated calculations to your table.

2.2: Test the Calculations

Ensure that the calculations are working as expected.