Let's investigate the functions of chapter 6 - TEACH someone else how to use a function from our chapter 6 reading! Advanced functions are required. Here's a list of possible functions to use: XLOOKUP(), VLOOKUP(), HLOOKUP(), PMT(), AVERAGEIFS(), SUMIFS(), IFS(), COUNTIFS()