Before using the Subtotal command, you must first sort the data. On the Subtotals worksheet, sort the data by Employee and further sort by Category, both in alphabetical order. 4 3 You want to subtotal the data to calculate expenses by employee. Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by employee.

Jameson manages a well-known cell phone company. this company has been voted as having the best cell-phone service. consumers appreciate the fact that they can call from almost anywhere in the world and the service still gets through. jameson knows that the company's product far surpasses that of the competition. one thing has been bothering him, though. in order to put so many resources into ensuring the best service, jameson has cut back on employees at the firm's customer call center. recently, consumers have begun complaining about long wait times when they call in with a problem or concern. although its cell phone service is still considered one of the best, customer satisfaction with the firm's customer service has plummeted. jameson does not understand why consumers are getting so upset. he believes the exceptional cell phone service more than makes up for long waiting periods and other issues with its customer service. "after all," he says, "they can't have it all. if i invest more in customer service, that means less investment on ensuring the quality of our product offering."refer to scenario. jameson has asked you, a marketing consultant, to give him advice. he cannot understand how a cell-phone company with the best product offering in the cell-phone service industry could get such low satisfaction ratings simply because the customer service is not up to par. you suggest that jameson has a narrowly defined view of the company's product offering. you tell jameson that successful marketers should define their products as what they

Sam and diane are completing their federal income taxes for the year and have identified the amounts listed here. how much can they rightfully deduct? • agi: $80,000 • medical and dental expenses: $9,000 • state income taxes: $3,500 • mortgage interest: $9,500 • charitable contributions: $1,000.

En major recording acts are able to play at the stadium. if the average profit margin for a concert is $175,000, how much would the stadium clear for all of these events combined?