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