Free Blank Printable Outline for Students | Student Handouts

 

outline worksheet

About This Quiz & Worksheet. Use this quiz/worksheet combo to help you test your understanding of writing an outline. Some topics you'll be assessed on include types of outlines as well as the. outline. Following this format will help you keep your thoughts organized and get your essay underway. Elements of an Essay Introduction: Usually an introduction starts broad and narrows down to your specific topic, ending in the thesis. This is your opportunity to establish why. Pearl K. Wise Library at CRLS Name_____. Outline Worksheet. I. Introduction chaplcets.cfound chaplcets.cf Statement _____ _____.


Outline Worksheet


If you have a list of data that you want to group and summarize, you can create an outline of up to eight levels, one for each group. Each inner level, represented by a higher number in the outline symbols, outline worksheet, displays detail data for the preceding outer level, represented by a lower number in the outline symbols. Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group, outline worksheet.

You can create an outline of rows as shown in the example belowan outline of columns, or an outline of both rows and columns. To display rows for a level, click the appropriate outline symbols.

To expand or collapse data in your outline, click the and outline symbols. Make sure that each column of the data that you want to outline has a label in the first row, contains similar facts in each column, and that the range has no blank rows or columns.

Make sure your detail rows also have a summary row—a subtotal. Do one of the following:. Insert summary rows by using the Subtotal command. Insert outline worksheet own summary rows, with formulas, immediately below or above each group of detail rows. For example, under or above the rows of sales data for March and April, use the SUM function to subtotal the sales for those months.

The table outline worksheet in this topic shows you an example of this. Specify whether the summary rows are located below or above the detail rows. On the Data tab, in the Outline group, outline worksheet the Outline dialog box launcher. If your summary rows are above your detail rows, clear the Summary rows below detail checkbox, outline worksheet. Otherwise, leave the checkbox alone. For example, in the data below, outline worksheet, row 6 contains the subtotal for rows 2 through 5, and row 10 contains the subtotal for rows 7 through 9, and row 11 contains the grand total.

To group all of the detail data for row 11, select rows 2 through Optionally, outline an inner, nested group — the detail rows for a given outline worksheet of your data. How to outline inner, nested groups groups of details rows. For each inner, nested group, select the detail rows adjacent to the row that contains the summary row.

In the example below, to group rows 2 outline worksheet 5, which has a summary row 6, select rows 2 through 5. To group rows 7 outline worksheet 9, which has a summary row 10, select rows 7 through 9, outline worksheet. On the Data tab, in the Outline group, click Group. Continue selecting and grouping inner rows until you have created all of the levels that you want in the outline.

If you want to ungroup rows, select the rows, and then on the Data tab, in the Outline group, click Ungroup, outline worksheet. You can also ungroup sections of the outline without removing the entire outline. To display the data, drag across the visible row numbers adjacent to the hidden rows. Make sure that each row of the data that you want to outline has a label in the first column, contains similar facts in each row, and the range has no blank rows or columns.

Insert your own summary columns with formulas immediately to the right or left of each group of detail columns. The table listed in step 4 below shows you an example. Specify whether the location of the summary column is to the right or left of the detail columns, outline worksheet.

To specify a summary column to the left of the details column, clear the Summary columns to right of detail check box. To specify a summary column to the right of the details column, select the Summary columns to right of detail check box.

How to outline the outer group all the columns except the grand total. Select all of the subordinate summary columns, as well as their related detail data.

In the example below, column E contains the subtotals for columns B through D, and column I contains the subtotals for columns F through Outline worksheet, and column J contains the grand totals, outline worksheet. To group all of the detail data for column J, select columns B through I.

Optionally, outline an inner, nested group individual groups of detail columns. How to outline the inner, nested group Groups of detail columns, outline worksheet. For each inner, nested group, select the detail columns adjacent to the column that contains the summary column. In the example below, to group columns B through D, which has a summary column E, select columns B through D.

Continue selecting and grouping inner columns until you have created all of the levels that you want in the outline. If you want to ungroup columns, select the columns, and then on the Data tab, in the Outline group, click Ungroup. If you ungroup an outline while the detail data is hidden, the detail columns may remain hidden. To display the data, drag across the visible column letters adjacent to the hidden columns.

If you don't see the outline symbols, andoutline worksheet, click the Microsoft Outline worksheet Button and then click Excel Options ExcelOR, click the File tab other versionsand then click Optionsclick the Advanced category, and then under the Display options for this worksheet section, select the worksheet, outline worksheet, and then select the Show outline symbols if an outline is applied check box.

To display the detail data within a group, click the for the group. To hide the detail data for a group, click the for the group, outline worksheet. Expand or collapse the entire outline to a particular level. In the outline symbols, click the number of the level that you want. Detail data at lower levels is then hidden. For example, outline worksheet, if an outline has four levels, outline worksheet can hide the fourth level while displaying the rest of the levels by clicking.

Show or hide all of the outlined detail data. To show all detail data, click the lowest level in the outline symbols, outline worksheet. For example, if there are three levels, click, outline worksheet.

To hide all detail data, outline worksheet, click. Outline worksheet styles use bold, italic, and other text formats to differentiate the summary rows or columns in your data, outline worksheet. By changing the way each of these styles is defined, you can apply different text and cell formats to customize the appearance of your outline. You can apply a style to an outline worksheet either when you create the outline or after you create it.

Automatically apply a style to a summary row or column. Apply a style to an existing summary row or column. If you don't see the outline symbols, andclick the Microsoft Office Button and then click Excel Options ExcelOR the File tab other versionsand then click Optionsclick the Advanced category, and then under the Display options for this worksheet section, select the worksheet, and then select the Show outline symbols if an outline is applied check box.

Use the outline symbols, and to hide the detail data that you don't want copied. For more information, see the section, Show or outline worksheet outlined data, outline worksheet. Excel Click the Microsoft Office Button and then click Excel Options OR the File tab other versionsand then click Optionsclick the Advanced category, and then under the Display options for this worksheet section, select the worksheet that contains the outline you want to hide and clear the Show outline symbols if an outline is applied check box.

To display the data, drag across the visible row numbers or column letters adjacent to the hidden rows and columns. Imagine that you want to create a summary report of your data that only displays totals accompanied by a chart of those totals. In general, you can do the following:.

For more information, see the sections Create an outline of rows or Create an outline of columns. Hide the detail by outline worksheet the outline symbols, and to show only the totals as shown in the following example of a row outline:. For example, outline worksheet chart only the Buchanan and Davolio totals, but not the grand totals, select cells A1 through C11 as shown in the above example. Create the chart. For example, on the Insert tab, in the Charts group, click Recommended Chartsor choose another chart type.

For example, if you create the chart by using the Chart Wizard, it would look like the following example, outline worksheet. If you show or hide details in the outlined list of data, the chart is also updated to show or hide the data. Optionally, if you want to outline an inner, nested group — select the rows within the outlined data range.

Optionally, if you want to outline an inner, nested group — select the columns within the outlined data outline worksheet. To ungroup, select the rows or columns, and then on the Data tab, in the Outline group, outline worksheet, click Ungroup and select the appropriate option. You can always ask an expert in the Excel Tech Communityget support in the Answers communityor suggest a new feature or improvement on Excel User Voice.

Group or ungroup data in a PivotTable. Outline your data. Do one of the following: Outline the outline worksheet automatically If necessary, select a cell in the range of cells you want to outline.

Click OK. Select the Automatic styles check box. Outline worksheet Apply Outline worksheet. You can also use autoformats outline worksheet format outlined data. Select the range of summary rows. Click Go To Special. Click Visible cells only. Click OKand then copy the data. In general, you can do the following: Create a summary report Outline your data. Hide the detail by clicking the outline symbolsoutline worksheet,and to show only the totals as shown in the following example of a outline worksheet outline: For more information, see the section, Show or hide outlined data.

Chart the summary report Select the summary data that you want to chart, outline worksheet. You can group or outline rows and columns in Excel for the web. Expand your Office skills.

Get instant Excel help. Was this information outline worksheet

 

How to Outline an Essay | Worksheet | chaplcets.cf

 

outline worksheet

 

Outline Worksheet Printables. Blank Printable Outlines - Scroll Down to Print - Graphic Organizers - Graphic Organizers: Hierarchies: Click to download or print (PDF files): Organizing Information - The Outline: This sheet is designed to introduce students to the concept of organizing information for writing by placing facts into an outline. Bible Study Outlines and Worksheets ("O" = Outline; "W" = Worksheet) Anger: What the Bible Teaches - O / W Denominationalism - O / W. Note carefully: No teaching anywhere on this web site is intended or should ever be construed to justify or to in any way incite or encourage personal vengeance or physical violence against any person. Pearl K. Wise Library at CRLS Name_____. Outline Worksheet. I. Introduction chaplcets.cfound chaplcets.cf Statement _____ _____.