Finance and Excel Quiz

What happens to portfolio risk when you add perfectly negatively correlated assets?

• Risk increases

• Risk decreases significantly

• Risk stays the same

• Risk becomes zero immediately

If monthly returns have a standard deviation of 0.05, what is the annual standard deviation?

• 0.60

• 0.17

• 0.05

• 0.25

Which data cleaning approach is best for a dataset with 80% missing values?

• Use mean imputation

• Remove the rows

• Replace with zeros

• Keep as is

What's the dimension of a variance-covariance matrix for a portfolio with 5 assets?

• 1x5

• 5x1

• 5x5

• 25x1

Which chart type is best for comparing revenue across different company divisions?

• Line chart

• Bar chart

• Scatter plot

• Area chart

What happens when you multiply a 2x3 matrix by a 3x4 matrix?

• Results in a 3x3 matrix

• Results in a 2x4 matrix

• Results in a 4x2 matrix

• Not possible

Which function would you use to count cells that meet multiple conditions?

• COUNT

• COUNTA

• COUNTIF

• COUNTIFS

What's the best way to handle outliers in financial data?

• Always remove them

• Always keep them

• Investigate and document decision

• Multiply by zero

Which Excel function returns the k-th largest value in a range?

• MAX

• LARGE

• TOP

• HIGHEST

What's the primary advantage of using Data Tables in Excel?

• Better formatting

• Faster calculations

• Automatic updates with input changes

• Smaller file size