Bao Vong is the sales manager for Murray Medical, a medical device manufacturer with headquarters in Morristown, New Jersey. Bao is analyzing the performance of account representatives and the sales of the company's medical devices. She asks for your help in using Excel tables to complete the analysis.

Question

Go to the Account Representatives worksheet, which lists details about Murray Medical account representatives and their clients, sales, and evaluations. Format the completed account representatives data (range A10:129) as a table with headers using Dark Green, Table Style Medium 3 so that Bao can summarize and filter the data. Use AccountReps as the name of the table. How to do this in excel

Answer 1

To format the account representatives data as a table in Excel, follow these steps:

1. Select the range A10:129, which includes all the data for the account representatives.
2. Go to the "Insert" tab on the Excel ribbon.
3. Click on the "Table" button in the Tables group.
4. In the Create Table dialog box, make sure the range is correct and check the box for "My table has headers."
5. In the Table Style options, choose "Dark Green, Table Style Medium 3."
6. Click OK.

Now the range A10:129 should be formatted as a table with headers using the Dark Green, Table Style Medium 3. The table will automatically be named AccountReps.

Bao can now easily summarize and filter the data in the table for her analysis.