TASK SUMMARY

Required Actions

Enable the Japanese language for authoring and proofing.

$$ On the P and L sheet, for cells D$3$:D$14,$ only allow values between $-10,000,000\mathrm{.}00$ and $100,000,000\mathrm{.}00.$ Include a warning message if an invalid value is entered that displays Value out of expected range. Contact SVP of Finance.

$x$ On the $P$ and $L$ sheet, prevent changes to cells $A3$:$C14$ to finance only. Require the password FinOnly to modify the range.

$$ Protect the workbook structure with the allowchanges password.

$$ On the Gross Profit sheet, forecast Sales for the next two years using a linear series with a growth rate of $125,000$ per quarter.

$$ On the Cycle Count sheet, audit results were combined but have duplicates. Use the appropriate command to remove duplicate listings.