a. Newman has just set up a pivot table in Excel, which identified Neumanium's sales by product by month. Newman did not use an Excel table when defining the range of data for his pivot table. While reviewing the results, Newman realized that one row of data was missing from his spreadsheet. Which of the following will enable Newman to correct the pivot table? Add the missing information in a new row at the bottom of the pivot table data range. Add the missing information in a new row at the bottom of the pivot table data range and refresh the data. Add the missing information in a new row at the bottom of the pivot table data range and create a new pivot table. b&c each work equally well. None of the above will work. b. c. d. e. . a b. Which of the following is incorrect regarding roll-forwards? Roll-forwards can be used to present changes in the number of customers from one year to the next. Roll-forwards can be used to present changes in revenue and operating income from one year to the next. The time period used in a roll-forward must always be one year. A roll-forward is a summary of all activity in a period that connects a beginning of period number with an end of period number. a and care incorrect c. d. e. 1. Which of the following reflects the characteristics of Eversource Energy? Eversource Energy, a Fortune 500 company based in Connecticut, Massachusetts and New Hampshire, operates New England's largest energy delivery system. Eversource purchases energy and then resells and delivers the energy to 3.7 million electric and natural gas business and residential customers. Eversouce operates in a highly regulated industry. Gross profit margin R&D as a percentage of revenue SG&A as a percentage of revenue Deferred Revenue Cash Flow from Operating Activities a. High High Low Average collection period (days sales outstanding) Medium Medium Medium Very Low Very Low None None b. Low C. Medium None Medium None None High Low Low Very Positive Very Positive Negative Negative Very Positive d. High None Low Medium e. Low High 2. The Kramer Corporation has forecasted its unit sales by product, its expected selling price by product and its expected gross profit margin by product. Which of the following excel functions will enable the total expected gross profit dollars to be calculated in the least amount of keystrokes and mouse clicks? Product Gizmo Gadget Thingumajig Doodad Units Sold 1,100 1,600 900 3,600 Expected $ 122] $ 132 $ 142 $ Selling Price Expected Gross 60% 62% 66% 55% Profit Margin 85