12 What's the best way to center the heading text "Business Unit Revenue ($000)" across the cells in dark blue (B2-F2) for easier editing? LAB CD E F G A B C D Business Unit Revenue (5000) Business Unit Revenue (5000) Business 1 Business 2 Business 3 Business Business 2 Business 3 Consolidated $491 $463 $415 $435 Consolidated $491 $463 5415 $435 $393 $393 2014 2015 2016 2017 2018 2014 2015 2016 2017 2018 Select all cells in dark blue - Alignment - Merge & Center Move the text from cell B2 to D2 and adjust the length of the columns OOOO Select all cells in dark blue - Format Cells - Alignment - Horizontal: Center Across Selection Select all cells in dark blue - Format - Alignment - Align Center 13 When creating a waterfall chart for ABC Inc.'s 2018 net earnings, which of the data points do you need to set as totals? Select ALL correct answers. 2018 Net Earnings Waterfall (5000) $282 $452 $1861 Revenue COGS Gross Profit Salaries & Benefits Depre. & Amort. Interest Taxes Net Earnings Cash Flow and Cash Balance 2018 Productivity Rate Depreciation & amortization Taxes Interest Gross profit Revenue Cost of goods sold Salaries & benefits Net earnings 15 To create a bullet chart as shown below, you should first select the data and inserti 74.0% 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Stacked line chart Stacked bar chart Stacked column chart Histogram chart Stacked area chart