Use the following information to help answer Exercises G$\mathrm{.}36-$G$\mathrm{.}41$ require the use of Excel, Tableau, or other software in the revenue cycle audit. This case is loosely based on Florida State University $($FSU$)$ Football ticket revenues. Many of the facts and all of the transaction$-$level data are fictitious, however. You have access to five Excel databases obtained from your client for use in auditing Football Ticket Revenue for the $2018$ football season. Detailed information about the client and data dictionaries, along with the required datasets, can be found below.

Required Data Files:

Data Dictionary $-$ Semiole Spirit Detailed Information

Unsold tickets by game

Season ticket sales revenue

Champion$$s club ticket revenue

Single game ticket sales by game

Issued tickets by game