Case-Based Critical Thinking Questions
Case 3-1
Column Chart Area Chart
Sarah has put together the same information in two different charts, shown in the figure above, to present to her boss. She is thinking through the pros and cons of each chart type.
-An area chart combines the features of a ____ by filling in the area below the line, and displaying the trend of values over time or categories.
Definitions:
Treynor-Black Model
A portfolio optimization model that adjusts for risk and incorporates passive and active components.
Active Portfolio
An Active Portfolio is a collection of investments actively managed by fund managers or investors, regularly making buy, sell, and hold decisions in an attempt to outperform the benchmark index.
Abnormal Returns
Returns on a stock or portfolio that differ significantly from the expected return based on the market or certain benchmarks.
Q19: When you _ a function, you include
Q44: The TRIM function removes all spaces in
Q59: #4<br>A)Data series<br>B)Chart title<br>C)Data table<br>D)X-axis labels<br>E)X-axis<br>F)Legend<br>G)Y-axis<br>H)Y-axis labels<br>I)Gridlines<br>J)Data point
Q61: Natalie's company has been going through a
Q80: If the Human Resources director wanted a
Q85: A function named IFWRONG can be used
Q88: In an INDEX function, the argument _
Q92: With a _ type of VLOOKUP, the
Q98: To create a chart in Excel, you
Q127: The _ symbol acts as a digit