Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.

Question

Please help me with these questions:

Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, and other goods throughout the United States. Padma oversees the contractors the company hires to research, write, and edit content for the website, including product descriptions and answers to customer questions. She is organizing information about the contractors in an Excel workbook, and asks for your help in updating and analyzing the data.
Switch to the Contractors worksheet. Unfreeze the top row of the worksheet.
Padma wants to sort and filter the contractor data. Format the range A4:G52 as a table with headers using Blue-Gray, Table Style Medium 9. Use Contractors as the name of the table.
Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.
A new contractor started last week, and Padma wants to include her data with the other contractors. Insert the record shown in Table 1 to the end of the Contractors table at row 53.
Table 1: New Record for the Contractors Table
ID First Last Specialty Start Year Pay Category Eval Rating
c5496 Mai Vang Garden and home 2022 1 3

davidmacago · Answer

Click on Contractors tab at the bottom. Click on View tab. Then, click on Freeze Panes dropdown and select Unfreeze. Alternatively, you can search "unfreeze" from the search option which is at the top most section.
Select A4:G52 and go to Home tab. Under styles group, click Format as Table and choose Blue-Gray, Table Style Medium 9. For the name of table, select any celles of the table and Table Design tab will appear. Select it and on the left hand side you'll see Table Name where u can enter "Contractors"
Click in ID or any cell in the table. Table Design tab will appear--click it. Check First Column option. To resize it to its best fit. Mover your cursor between column A and B and double click.
Go to row 53. Copy given data (all of em) Select all the cell of the 53 row where the table cells are supposed to be. Right click and chose paste option which says match destination formatting.

Video instructions:

Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.

Answers

Post your answer

Recommended Books