HELP: need help with excel formulas and assertions

This case involves the use of data analytics to audit football ticket revenues of Florida State University. Note: The transaction level data and many of the facts are fictitious. Detailed information is provided in a separate file. Questions should be answered utilizing Excel and all answers must be supported with the Excel files. The five databases provided in this exercise are as follows and are included in the Connect assignment posted on Blackboard:

Unsold tickets by game

Season ticket sales revenue

Champion$$s Club ticket revenue

Single game ticket sales, by game

Issued tickets, by game.

$$

$1.$ Complete the Connect question regarding IPE.

$$

$2.$Review single game ticket sales for duplicate listings.

The assertion for which you are gathering evidence is $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

The Excel function$($s$)/$formula$($s$)$ utilized to obtain the answer was $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Duplicate listings are as follows by game$($s$)$:

$$

$$

$3.$ Determine if there are missing tickets.

The assertion for which you are gathering evidence is $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

The Excel function$($s$)/$formula$($s$)$ utilized to obtain the answer was $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Missing tickets are as follows by game$($s$)$:

$$

$$

$4.$ Review season ticket sales for any issued in the subsequent accounting period.

The assertion for which evidence is being gathered is $\_\_\_\_\_\_\_\_\_\_\_.$

The Excel function$($s$)/$formula$($s$)$ utilized to obtain the answer was $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Season ticket sales issued in the subsequent period are as follows:

$5.$ For the purpose of cleansing the file, review the single game sales for characters in a numeric column.

$$

$6.$ The client has provided you with the following information which they have calculated based on the underlying accounting information:

Season tickets sold $($excluding Champion$$s Club$)28,630$

Champions Club seats sold$3,404$

Student tickets provided, per game$16,000$

Average number of complimentary tickets provided$1,400$

Average season ticket price$$ $$330$

$$

Prepare and document an estimate of football ticket revenue using only the summary estimates provided above by the client, as well as the client$$s single game total tickets issued summary. Use this calculation to test the reported sales revenue of $$26,726,864$ and answer the following questions:

a$.$ What is your best estimate of $2023$ football ticket revenue using the client$$s average ticket sales and prices provided in the case?

$$

b$.$ Based on the performance materiality of $$230,000,$ does $2023$ football ticket revenue appear to be fairly stated?

$$

$$

$7.$ The client provided you with certain calculations above. Are the calculations provided for the Season Tickets sold, Average # of complimentary tickets provided and the Average season ticket price sufficiently accurate for the purpose of the analytical procedure based on the underlying transaction level data?