Question
1. 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
1. 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. Dont 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 Alphabets 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started