QUESTION

Text
Image


15 What is the function of Trace Precedents? Trace cells that are depended on the selected cell Trace cells that contain a formula Trace cells that referenced in other cells in the worksheet Trace cells that provide data to the formula in the selected cell
22 Which Excel function will you use to highlight all the cells containing formulas in the worksheet? Review Later Trace Precedents Data Validation - Formulas Data Table - Formulas Go To Special - Formulas
23 What is the present value of a cash inflow of $\$ 2,000$ five years from now if the required rate of Review Later return is $6 \%$ ? $\$ 1,538.46$ $\$ 1,673.52$ $\$ 1,886.79$ $\$ 1,494.52$
Forecast the accounts receivable using the following annual information. \begin{tabular}{|l|r|} \hline Receivable days assumption & 42 \\ \hline Payable days assumption & 51 \\ \hline Forecasted revenue & 72,000 \\ \hline Forecasted cost of goods sold & 64,000 \\ \hline Days in period & 365 \\ \hline \end{tabular} 8,000 8,285 7,364 6,714

Public Answer

PFARBO The First Answerer