15 What is the function of Trace Precedents? Trace cells that are depended on the selected...

Transcribed Image Text:

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 return is 6%? Review Later $1,538.46 $1,673.52 $1,886.79 $1,494.52 Forecast the accounts receivable using the following annual information. Receivable days assumption 42 Payable days assumption 51 Forecasted revenue 72,000 Forecasted cost of goods sold 64,000 Days in period 365 8,000 8,285 7,364 6,714 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 return is 6%? Review Later $1,538.46 $1,673.52 $1,886.79 $1,494.52 Forecast the accounts receivable using the following annual information. Receivable days assumption 42 Payable days assumption 51 Forecasted revenue 72,000 Forecasted cost of goods sold 64,000 Days in period 365 8,000 8,285 7,364 6,714