Follow-Up: Excel 2016 – Advanced
Über den Vortrag
Der Vortrag „Follow-Up: Excel 2016 – Advanced“ von Sonic Performance ist Bestandteil des Kurses „Forecasting Data in Excel 2016 (EN)“.
Quiz zum Vortrag
Which of the following are differences between data tables and scenarios?
- Scenarios change the original values in the associated worksheet cells and data tables do not.
- Scenarios can account for more than two variables and data tables cannot.
- Scenarios are a type of what-if analysis and data tables are not.
- Scenarios can account for more than one variable and data tables cannot.
Which of the following statements are true regarding two-variable data tables?
- You can use them to evaluate a formula for any number of different values for each input cell.
- They display results directly in worksheet cells.
- They can determine potential outcomes for multiple formulas simultaneously.
- They can evaluate outcomes for either one or two variables.
How is the Goal Seek feature different from the other types of what-if analysis tools?
- You use it when you know the desired outcome.
- It uses iterative calculations to arrive at a solution.
- You use it to determine the final outcome.
- It can change values associated with a calculation.
Which of the following are options when creating a Forecast Sheet?
- Line chart
- Column chart
- Area chart
- Scatter chart
Diese Kurse könnten Sie interessieren
Dozent des Vortrages Follow-Up: Excel 2016 – Advanced
Sonic Performance
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
