Formula: Multiply, Subtract; Cell Referencing Using Excel to Account for an Accounting Change Student Work Area \begin{tabular}{ll} \( \qquad \multicolumn{1}{c}{ \) PROBLEM } & Required: Provide input into cells shaded in yellowin this template. Input the \\ HuangInc.,whichusesaperiodicsystem,changedfromtheweightedaveragecostformulatotheFiFOcostformulain2023.ThecompanysfinancialstatementsareexpectedtobereliablerequiredmathematicalformulasorfunctionswithcellreferencestotheProblemareaorworkareaasindicated. \end{tabular} and more relevant as a result of the change. The increase in the prior year's income before tax as a result of this change and the Prepare Huang's 2023 journal entry to record the change in accounting policy. tax rate follow: Increase in prior year's income before tax Income taxrate