Sign in

Sign in

Open in App**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

Related Questions

Copyright © 2023 StudyX Inc