Please Help! Project: fix it $6\mathrm{.}6$

this project, you will work with spreadsheets designed for planning a charity event. In order to determine if

he party will meet its fundraising goal, the guest list analysis and expense calculations must be corrected.

kills needed to complete this project:

Analyzing Complex Formulas Using Evaluate Formula $($Skill $6\mathrm{.}22)$ No single budget item should be more than $$3,000.$

a$.$ Add data validation to cells C$2$:C$16$ on the Week Before, $1$ Month Before, and $2$ Months Before

worksheets to require decimal values less than $3,000.$ Ignore blank cells.

b$.$ Add the following error alert to the cells with data validation: Budget must be less than

$3,000.$

Check for and fix any accessibility issues.

Before saving the file, protect all the worksheets so no changes can be made and protect the wo

so the structure cannot be modified.

Save and close the workbook.

Rounding with Functions $($Skill $6\mathrm{.}2)$

Extracting Text with RIGHT, LEFT, and MID $($Skill $6\mathrm{.}1)$

Using SUMIF and SUMIFS $($Skill $6\mathrm{.}4)$

Using COUNTIF and COUNTIFS $($Skill $6\mathrm{.}6)$

Using AVERAGEIF and AVERAGEIFS $($Skill $6\mathrm{.}5)$

Using Database Functions $($Skill $6\mathrm{.}20)$

Calculating Totals with SUMPRODUCT $($Skill $6\mathrm{.}3)$

Finding Data with MATCH and INDEX $($Skill $6\mathrm{.}19)$

Calculating the Number of Payments with NPER $($Skill $6\mathrm{.}17)$

Using the IFS Function $($Skill $6\mathrm{.}13)$

Open the start file EX$2019-$FixIt$-6-6$ and resave the file as:

$[$your initials$]$EX$-$FixIt$-6-6$

If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of

the workbook so you can modify the workbook.

$.$ Throughout this project, use the Evaluate Formula feature to analyze any formulas you have difficulty

troubleshooting.

Fix the following errors in the Guest List worksheet. Use cell references and named ranges where

appropriate. All the named ranges you might need have been defined for you. Refer to the Named Ranges

Reference sheet for a description of each defined name.

a$.$ In cell K$13,$ the formula to create the GuestID should use the first two characters from cell B$13$

combined with the first three characters from cell E$13.$ Fix the formula to have the result be $Ci417.$

Copy the formula to the remaining cells in the column.

b$.$ In cell E$3,$ the formula to calculate the number of tables should result in a whole number only. Be sure

to round the number up so you aren't left with a guess without a seat.

c$.$ The formula in cell E$4$ should calculate the total number of guests from the city listed in cell D$4.$

d$.$ The formula in cell E$5$ should calculate the number of single guests attending from the city listed in cell

D$5.$