EXCEL CHAPTER 5!!!!!!!!!!!!!

steps to sorting data

1. Click any cell in the column you want to sort by. 2. On the Data tab, in the Sort & Filter group, click the button for the sort order you want:

how to define data as a table

1. Click any cell in the data range. 2. On the Home tab click the Format as Table button to display the Table Styles gallery. 3. Click the style you want to use for your table

analyzing data with goal seek

1. On the Data tab, in the click the What-If Analysis button, and then click Goal Seek... 2. Enter the outcome cell in the Set cell box. 3. Enter the input cell in the By changing cell box. 4. Click OK. *The Goal Seek Status box appears. Click OK to accept the solution and change the value in the input cell or click Cancel to return the input cell to its original value.

steps to filtering data

1. On the Home tab, in the Editing group, click the Sort & Filter button. 2. Click the Filter button to enable filtering. An arrow will appear in each cell of the heading row just as if the data were formatted as a table

adding total rows to tables

1. On the Table Tools Design tab, click the Total Row check box. 2. In the Total row at the bottom of the table, click the cell where you want to add the calculation. 3. Click the arrow, and select a function. Excel inserts the formula for you.

creating a pivot chart from a pivot table

1. Select any cell in the PivotTable. 2. On the PivotTable Tools Analyze tab click the PivotChart button 3. Select a chart type from the Insert Chart dialog.

steps to apply quick styles and colors to charts

1. Select the chart. 2. On the Chart Tools Design tab, click the style you want to use (the More button shows all of the Quick Styles available) 3. To change the color scheme, on the Chart Tools Design tab, click the Change Colors button and select the color scheme you want.

steps to insert a bar chart

1. Select the data you want to include in the bar chart. 2. On the Insert tabclick the Insert Column or Bar Chart button. 3. Click the chart type you want to insert into the worksheet

steps to insert a column

1. Select the data you want to include in the column chart. 2. On the Insert tab, click the Insert Column or Bar Chart button. 3. Click the chart type you want to insert into the worksheet.

steps to inserting a line chart

1. Select the data you want to include in the line chart. 2. On the Insert tab click the Insert Line Chart button. 3. Click the chart type you want to insert into the worksheet. **If Excel does not display the time categories along the x axis, switch the data series and the categories. On the Chart Tools Design tab click the Switch Row/Column button

steps to inserting a pie chart

1. Select the data you want to include in the pie chart. 2. On the Insert tab, click the Insert Pie Chart button. 3. Click the chart type you want to insert into the worksheet.

steps

1. Select the data you want to visualize as Sparklines. 2. Click the Quick Analysis Tool button, and then click the Sparklines tab. 3. Click the button for the Sparkline type you want.

Goal Seek

Excel's ________ function lets you enter a desired value (outcome) for a formula and specify an input cell that can be modified in order to reach that goal.

input cell

Goal Seek changes the value of the ______ incrementally until the target

filter

If your worksheet has many rows of data, you may want to ______ the data to show only rows that meet criteria you specify.

graphic data markers

In a chart, the data points (the values selected in the worksheet) are transformed into __________

data series

Related data points, usually in the same row or column, are grouped into a ________

right

The Quick Analysis Tool button appears near the lower ______ corner of the selected range.

robust

When data is defined as a table, Excel provides a _________ tool set for formatting and analyzing the data

table

a series of adjacent cells

Quick Styles

apply combinations of fonts, line styles, fills, and shape effects.

chart area

area that encompasses the entire chart including the plot area and optional layout elements, such as title and legend.

plot area

area where the data series are plotted.

Bar charts

charts where the categories are displayed on the vertical axis, and the data point values are plotted along the horizontal axis.

data markers can be

columns, bars, pie pieces, lines, or other visual elements

Line charts

feature a line connecting each data point—showing the movement of values over time. *work best when data trends over time are important.

chart

graphic that represents numeric data visually

slicer

is a visual representation of filtering options.

Data tables

provide a quick what-if analysis of the effects of changing one or two variables within a formula.

Sorting

rearranges the rows in your worksheet by the data in a column or columns.

Sparklines

represent a series of data values as an individual graphic within a single cell

Pie charts

represent data as parts of a whole & work best when you want to evaluate values as they relate to a total value

2 ways to sort data

sorts text in alphabetical order *A-Z, numbers smallest to largest, dates oldest to newest sorts text in reverse alphabetical order *Z-A, numbers largest to smallest, and dates newest to oldest

PivotTable

special report view that summarizes data and calculates the intersecting totals. ** do not contain data themselves

legend

tells you which data point or data series is represented by each color in the chart

chart title

text box above or overlaying the chart

Column charts

work best with data that are organized into rows and columns like a table.