Last answered:

11 Mar 2022

Posted on:

10 Mar 2022

0

Introduction to Excel Course Exam Question 27

Hi,

On course exam Q27, can you explain it in more detail how I should use data table?

I understand that data table has to be used, but not sure how should I select a reference :(

I will look forward to hearing back from you!

2 answers ( 0 marked as helpful)
Instructor
Posted on:

11 Mar 2022

0

Hello Yongjun,
Good to hear from you!
We have shown you how to create a sensitivity table in the following lesson:
https://learn.365datascience.com/courses/introduction-to-microsoft-excel/perform-sensitivity-analysis-with-excel-s-data-tables-functionality/
Please take a look and try to create a table in this case.
Best,
Ned

Posted on:

11 Mar 2022

0

image.png
Hi,
Can you teach me which value I should put on the green box above?
I have tried 'Enterprise value' but it does not work :(

Thanks!

Submit an answer