Answer :
Microsoft Office Excel uses various types of cell referencing, one of them is the mixed cell reference.
The formula to calculate the total admission fee is: =F5 * $B14
About mixed cell reference
- The mixed cell reference allows the formulas to remain unchanged when copied to another cell.
- The syntax of the mixed cell reference is $cell-name
From the complete question, the total admission fee is the product of cell F5 and cell B14
So, the formula to calculate the total admission fee is:
=F5 * $B14
When the above formula is entered in cell i5, the appropriate value will be computed and displayed.
The dollar sign ($) in front of B14 implies that, B14 uses a mixed cell referencing style
Read more about cell reference at:
https://brainly.com/question/6777570