> > >

Excel MCQs

Which of the following is an example of how you would use a data table?

You're estimating loan payments and want to see combinations of different interest rates and principal amounts.

You're planning a small construction project that has 6 variable costs. You want to see different combinations of all these variables.

You have 1000 rows of invoices spanning 3 months and 5 products. You want a summary of product sales by month.

You want to know the rate of return on an investment when you know the present value and future value.

Answer

Correct Answer: You're estimating loan payments and want to see combinations of different interest rates and principal amounts.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it