True or False, the pivot table’s main advantages are: 1) its ability to efficiently assemble reports and 2) the flexibility to quickly adjust column, row, values or filter. 

Choose the end point you would reference on FMP to retrieve sales of Amazon.  

On the INDEXMATCH tab using LOOKUP assignment.xlsx, what was the volume (column F) on the day when the minimum share price was reached (cell L9)?    

Based on the information provided in the table below and an IF formula that returns the number 1 IF the 3-yr performance is above 10% AND the expense ratio is less than 0.65% otherwise the IF statement returns the number 0 (Question 2). How many 1’s were returned in column D. A B C D 1 Fund ticker Expense ratio 3-yr performance 2 DODWX 0.63% 17.6% 3 HAVLX 0.68% 12.77% 4 OFAIX 0.60% 10.10% 5 MABAX 0.55% 5.40% 6 NOLVX 0.57% 7.09% 7 POAGX 0.64% 14.56%

On the HLOOKUP_VLOOKUP tab using LOOKUP assignment.xlsx, provide the value the VLOOKUP formula return for the BASE terminal growth (g) scenario (cell B17)?   ANSWER FORMAT = x.xx NOT x% DO NOT WORRY IF CARMEN ADDS ZEROS AFTER YOUR ANSWER

Use the following information to answer the next 4 questions. Assume 2010 is the base year. Assume there are only two goods in this economy, helmets and bicycles. GoodQuantity2010 Price per Unit2015 Price per UnitHelmets40$27$32Bicycles10$150$200

What is the basket price for 2010?

Match the statements with the relevant problem of inflation.

What is the CPI for 2010?

6. Show using the definition , for some vector , that: a) b)