Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

Add a Table to Summarize Research Results

Playback Speed:
Transcript

In this extension, you will add a sheet to summarize the results of the data you researched about different careers. This sheet will make your research easier to understand and evaluate.

In this extension, you will: Add a new sheet and name both sheets, Copy and paste your original column headers into your new sheet, Copy and paste your career titles into your new sheet, Copy and paste the averages data into your new sheet, And format the new sheet.

To begin, add a new sheet. Give each sheet a brief, clear name to describe the information it contains.

Copy the headers from your original Career Research table and paste them on the next sheet.

Copy the name of each career you researched and paste it under the “careers” header in your new sheet.

Now copy the rows that contain the averages of the data for each career and select the “paste special” option to paste them into your new sheet. “Paste special” gives you control of how content is displayed when pasted from the clipboard. It allows you to paste text without copying formulas or formatting.

Use the “paste special” option and paste in only the cell values.

Finally, update the formatting of these rows by copying and pasting the formatting from your original sheet.

You’ve now created a sheet that makes it easier to compare the different career paths you’ve chosen to research. As you add more careers and new research categories to your original research sheet, you can add your final results to this sheet, as well. Now, it’s your turn: Add a new sheet and name both sheets, Copy and paste your original column headers into your new sheet, Copy and paste your career titles into your new sheet, Copy and paste the averages data into your new sheet, And format the new sheet.

Choose an Extension
Format Your Spreadsheet

Use formatting tools such as borders, shading, and text color to further organize the information in your spreadsheet.

Create a Chart to Compare Job Outlooks

Create a chart to compare the projected growth rates of one of the careers you researched.

Add a Table to Summarize Research Results

Add a table to summarize the data you researched about different careers.