Excel Exam

Select the range A1:K1 and apply the Heading 1 cell style

1. Home tab 2. Styles 3. Cell Styles

In cell H4, calculate the donation amount by multiplying the Streaming Revenues amount by the percentage in cell I1, using absolute references as needed.

=$G4*$I$1

In cell B20, enter a function to calculate the average attendance for the year 2018.

=AVERAGE(F5:F11)

In cell B17, enter a function that will count the number of locations the Job Fair was held in 2018.

=COUNT(F5:F11)

In cell I5, enter a formula to calculate the total admission fees collected for the 2018 Altamonte Springs Job Fair using a mixed cell reference for cell B14.

=F5*B$14

In cell H5, enter a formula that will calculate the percentage of attendees that went to the Altamonte Springs job fair in 2018. Use relative cell references and copy the formula to the range H6:H11

=F5/$F$12

In cell I4, calculate the profit by subtracting the donation from the streaming revenues.

=G4-H4

In cell I4, enter a formula to calculate the Projected Second Quarter. Enter a formula to multiply the First Quarter value by 1 plus the projected increase.

=H4*(1+$B$12)

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference.

=IF(K5>=$H$18,"Goal Met", "Review")

In cell B23, enter a function to calculate the maximum attendance for the year 2018

=MAX(F5:F11)

In cell B22, enter a function to calculate the minimum attendance for the year 2018.

=MIN(F5:F11)

In cell B16, enter a function to calculate the total attendance for the years 2014 through 2018 using the totals in the range B12:F12.

=SUM(B12:F12)

In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array

VLOOKUP(H14,A5:H11,8,FALSE)