Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter:a. Convert the balance sheet into a format that is suitable for a pivot table by transposing the data using Get & Transform. Don’t forget to enter the word “Date” above the dates.b. Build a pivot table from the data showing Total Assets by Quarter. Add a pivot chart showing how total assets have grown over time.c. Create a calculated field that shows the current ratio in the pivot table, and format the numbers with two decimal places.d. Create a pivot chart that shows the current ratio over time. Has Alphabet’s liquidity deteriorated or improved over this period?e. Now, use a Timeline to filter the pivot table so that it only shows 2015 to 2016. Now show only 2012 to 2013. Is there a difference in the trend of the current ratio in the two time periods?

Answer rating: 100% (QA)

a To transpose the data using Get Transform Power Query 1 Open the Alphabet Financialsxlsx workbook in Excel 2 Select the data range of the balance sh... View the full answer