Required information To complete this exercise, you will need to download and Install Tableau on your computer. Tableau provides free Instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here [The following Information applies to the questions displayed below.] Abernathy Company's accounting department has finished preparing the master budget for this year. The chief financial officer (CFO) would like your assistance in creating data visualizations that she can use to better explain the master budget to the company's senior management team. More specifically, the CFO would like you to prepare some data visualizations that depict trends in sales, net income, cash collections, current assets, and operating cash flows. Download the Excel file, which you will use to create your Tableau visualizations. Upload the Excel file Into Tableau by doing the following: 1. Open the Tableau Desktop application. 2. On the left-hand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel." 3. Choose the Excel file and click "Open." 4. Since the only worksheet in the Excel File is "Abernathy Company" it will default as a selection with no further import steps needed Create a line chart that includes a total of two lines. The first line will depict monthly trends in operating cash flows and the second line will depict net Income: • Double click on "new sheet" at the bottom of the workbook and change the name of the newly created to "Net Income vs. Operating Cash Flows" • On the left-hand side under "Dimensions" (sometimes labeled as Tables), double-click on "Month ended" . On the left-hand side under "Measures", double click on "Net Income" On the left-hand side under "Measures", double click on "Operating Cash Flows" In the upper right-hand corner, click on "Show Me" and choose "Dual lines" in the far-right column fifth row down. • Note this will default to showing only the year. We want to see a monthly trend, therefore in the "Columns" area you will see a green pill that says "YEAR(Month ended)", click on the [-] in that pill • This will modify the pill from years to quarters, click the [-] once more to go to "MONTHS" Right click on the right Y-axis and choose "Synchronize Axis" Format the title of the x-axis by right-clicking on the x-axis and clicking "Edit axis" • At the bottom of the window that appears within the "Axis Titles" section replace "Month of Month Ended" with "Month" • Uncheck the box "Automatic" that is beside "Subtitles" • Your visualization should appear as follows: Net Income vs. Operating Cash Flows Required: (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 5a. Which of the following statements is true based on the line chart that you just created? ?Each month's net Income is always lower than its operating cash flows. ?Each month's net Income is always higher than its operating cash flows. ?Each month's net Income always equals its operating cash flows. ? In some months the net income is higher than the operating cash flows and in other months the opposite is true. 5b. Which of the following statements is true based on the line chart that you just created? ?The net Income peaks in August and the operating cash flows peak in September. The net Income and operating cash flows both peak in September. ?The net Income and operating cash flows both peak in August. ?The net Income peaks in September and the operating cash flows peak in August. 5c. Which of the following statements is true based on the line chart that you just created? ?The operating cash flows are negative for each of the first seven months of the year. ?The operating cash flows lag net income. ?The net Income lags operating cash flows. ?The operating cash flows are greater than zero for each of the last five months of the year.