1. You have a list of European stocks that are priced in euros. Where can you go to format the prices in euros in Excel?

The Number menu under the Home ribbon

The Currency menu under the Formulas ribbon

The Number menu under the Data ribbon

The Currency menu under the Data ribbon

2. You need to use the Goal Seek feature in Excel. Where is this located?

Under What-If Analysis in the Insert ribbon

Under What-If Analysis in the Data ribbon

Under Functions in the Insert ribbon

Under Functions in the Data ribbon

3. You have a table of stocks and their corresponding stock prices. You would like a quick summary of statistics such as median stock price, mean stock price, and standard deviation. What is the best tool to help you find this data?

The AVERAGE, MEDIAN, and STDEV functions in the Insert ribbon

The Descriptive Statistics feature under Data Analysis in the Data ribbon

The What-If Analysis feature in the Data Ribbon

4. Suppose that you have a list of stocks, and for each stock you have its beta and P/E ratio. You want to calculate the correlation between the stocks' betas and P/E ratios. Where can you find the correlation feature in Excel?

Under Data Analysis in the Data ribbon

Under What-If Analysis in the Data ribbon

Under Descriptive Statistics in the Data ribbon