Excel

SUM Function

277 - Totals a series of cells

Input Area (Page 449)

A range in a worksheet that contains values that you can change.

Bold

Argument names:(457) is required.

Line Chart

Displays category data on the horizontal axis and value data on the vertical axis. Appropriate to show continuous data to depict trends over time, such as months, years, or decades.(508)

Median Sum

Finds the midpoint value, which is the value that one half of the data set is above or below. =MEDIAN(A2:A14)

Range

Is a group or block of cells in a worksheet that have been selected or highlighted.

Sum Function

Totals the value in two or more cells and displays the result in the cell containing the function. = SUM(A2:A14)

Formula

a combination of cell references, operators, values, and/ or functions used to perform a calculation. (pg. 448)

Display cell formulas(387-388)

in order to show a cells' formula, press the control and tilde "~" key. this shows the formula that was used for that box

switch data

is used to create the horizontal axis and the legend

Print Area

range of cells that will print(559); select the range you want to print, click print area in page setup group and then select print area (423)

Use references in formula why?

referencing these cells on your formulas, instead of typing the value of the cell to which you are referring, keeps your formulas accurate if the values change. (384-85)

Chart Styles Button

right side of the chart, and shows a collection of formatting that controls the color of the chart area, plot area, and data series. (Styles such as flat, 3-D, or beveled.) Pg.537

Print Order

the sequence in which the pages are printed (560)

Cell address

the unique identifier of a cell, starting with the column letter and then the row number. Example: the intersection of column A and row 9 is cell A9. (Page 376)

Copy and paste excel data(410)

you can copy and paste excel data to other things such as Word or PowerPoint. after copying the excel information, you can choose how to paste it by pressing the paste special option

Freeze Panes

(557) keeps both rows and columns above and to the left of the active cell visible as you scroll through a worksheet.

Unfreeze Panes

(557)Once you freeze columns, click on the view tab, and in the window group to unfreeze columns. The Unfreeze Panes option should be where the the Freeze Panes once was.

Selecting Range using name box pg 406-pg 407

(A range is a group of adjacent or contiguous cells.) Select range by clicking in the name box, you then type the range address for example like A15:C:13. Finally, press enter.

Spreadsheet

(Page 374) An electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.

Wrap text

(Page 415) Use this feature to make data appear on multiple lines by adjusting the row height to fit the cells content within the column width.

Chart

506 Is a visual representation of numerical data that compares data and helps reveal trends or patterns to help people make informed decisions. Effective charts depicts data in a- clear easy to interpret manner contains enough data but not enough to overwhelm audience

XY Scatter Chart

515 - Shows a relationship between two numerical variables using their X and Y coordinates.

Embed chart on same sheet as data source

A chart sheet contains a single chart only; you cannot enter data and formulas on a chart sheet. pg.517.

Bar Chart

A chart type that compares values across categories using horizontal bars. In a bar chart the horizontal axis displays values and the vertical axis displays categories. 508 and 513

Pie Chart

A chart type that shows each data point in proportion to the whole data series as a slice in a circle. A pie chart depicts only one data series. 508 and 514

Print Preview

A feature that allows you have an idea how the file will look when it is printed. page 92

Data Series

A group of related data points that display in row(s) or column(s) in a worksheet. Page 1087

Legend

A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart (page 506)

Fill handle

A small green square at the bottom-right corner of a cell used to copy cell contents, texts, or number patterns to adjacent cells. When dragged it enables auto fill which enables you to copy the contents of a cell or range.Pg.386-387

Order of Precedence

Also known as Order of Operations, which is Parenthetical Info. (data) , then Exponentiation (^) , then Multiplication (*) , then Division (/) , then Addition (+) , and finally Subtraction (-).

Data Label

Are descriptive labels that show the exact name or value of a point. They are not displayed by default. page 525

Most common used chart types

Column: Displays values in vertical columns where the height represents the value: the taller the column, the larger the value. Categories display along the horizontal (category) axis. Bar Graph: Displays in horizontal bars where the width represents the value; the wider the bar, the larger value. Categories display along the vertical (category) axis. Line: Displays category data on the horizontal axis and value data on the vertical axis. Appropriate to show continuous data to depict trends over time, such as months, years, or decades Pie: Shows proportion of individual data points to the sum of all those data points. (Page 508)

chart bar

Displays category data on the horizontal axis and value data on the vertical axis. Appropriate to show continuous data to depict trends over time, such as months, years, or decades. (pg. 508)

Values Axis (506)

Displays incremental numbers identify the worksheet values (such as numbers of jobs or revenue) used to create the chart

Quick analysis

Displays when you select a range of cells and position the mouse pointer over that selected range and is displayed in the bottom-right corner of the selected area.The Quick analysis tool enables you to use analytical tools like charts to quickly examine data.Pg.507-508

Data Point

Each cell containing a value is called a data point.(506)

Automatic page break

Excel inserts an automatic page break whenever it runs out of room.

Embed sheet on data source

Excel inserts the chart as an embedded object in the current worksheet , often to the right side of, but sometimes on top of and covering up, the data.

Alt+Enter (page.379)

If a long text label does not fit well in a cell, you can insert a line break to display the text label on multiple lines within the cell. To insert a line break while you are typing a label, press Alt+Enter where you want to start the next line of text within the cell.

Repeat column or row headings

If you want to print the titles at the top of each page select the row(s) that contain the labels or titles in the Rows to repeat at top box to display $5:$5. To do the same for the rows labels at the left side of each page, select the column(s) that contain the labels or titles in the Columns to repeat at the left box to display $A$A. (pg560)

Axis Titles

Labels that describe the category and value axes. You can display axes titles, such as Millions of Dollars or Top 7 Computer Job Titles, to clarify the axes. Axis titles are not displayed by default (525). "Excel does not include axis titles by default; however, you can display titles. When you click Chart Elements and click the triangle on the right side of Axis Titles, you can select Primary Horizontal and Primary Vertical. The horizontal axis title displays below the category labels, and the rotated vertical axis title displays on the left side of the value axis. After including there titles, you can click the respective title, type the text for the title, and then press Enter (527).

A new workbook book contains how many sheets

Pg 374 A workbook contains one new sheet by default.

Hide Column or Row (Page 400)

Right click a column or row to hide it from view.

Word

Simplify entering ranges in formulas (386)

Category Label

Text that describes a collection of data points in a chart. Page 1086

Required arguments for SUM

The SUM is a function that contains one required argument that represents a range of cells to add. pg.459

Column width p.264

The horizontal measurement of a column in a table or a worksheet. in, excel it is measure in the number of characters or pixels. when creating a chart a tables columns are automatically evenly spaced. columns size can be adjusted by using the pointer on the border and text can be wrapped.

Freezing Rows and Columns (557)

The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.

Output area

The region in the worksheet to contain formulas dependent on the values in the input area. (Page 377)

Ctrl + Enter

This function can be used to keep the current cell the active cell (page 390)

Create Chart

To create a chart select the and click the analysis button Click charts in the quick analysis gallery position the mouse over the recommended thumbnail to see the type of chart you can select for the data. Click the thumbnail of the chart you want to create.

Sheet tabs

To rename a worksheet-- double click a sheet tab, type as new name, press enter. To change the color of a worksheet tab—Click sheet tab, click format in cells group on one tab, choose Tab color palette, and click on the color. To insert—click new sheet, then insert, arrow in cells group on home tab and select insert sheet. A worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data. (pg 395, 375, 396)

Chart Elements

a chart element is a component that completes or helps clarify the chart. Some chart elements, such as title, should be included in every chart. Other elements are optional. (525) Element Axes- Category axis labels, such as job titles, and the value axis quantities in increments in column, bar, and line charts. Axes display by default. Axis Titles- Labels that describe the category and value axes. Axis titles are not displayed by default. Chart Title- Label that describes the entire chart. It should reflect the purpose of the chart. The default is Chart Title. Data labels Descriptive labels that show exact value or name of data point. Data labels are not displayed by default. Data table- A grid that contains the data source values and labels. If you embed a chart on the same worksheet as the data source, you might not need to include a data tables. Only add a date table with a chart that is on your chart sheet. Error bars- Visuals that indicate the standard error amount, a percentage, or a standard deviation for a data point or marker. Error bars are not displayed by default. Gridlines- Horizontal or vertical lines that span across the chart to help people identify the values plotted by the visual elements, such as a column. Excel displays the horizontal gridlines for column, line, scatter, stock, surface, and bubble charts and vertical gridlines for bar charts. Gridlines may display by default, depending on the chart type. Legend- A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series. The legend is displayed by default for particular charts. Trendline- A line that depicts trends or helps forecast future data, such as estimating future sales or number of births in a region. You can add a trendline to column, bar, line, stock, scatter, and bubble charts. Excel will analyze the current trends to display a line indicating future values based on the current trend

Stacked column chart

a chart type that places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. (pg 511-512)

Border

a line that surrounds a cell or range of cells. Used to offset data from the rest of the worksheet. To apply a border, select cell or range you want, then click the Border arrow. To remove border, select No Border from Border menu. (pg. 416)

Workbook

a new workbook contains one worksheet. A workbook is a collection of one or more related worksheets contained within a single file.(pg 295, 375, 396)

Formula bar

an element in Excel that appears below the Ribbon and to the right of the Insert Function command. It shoes the contents of an active cell. You can enter or edit cell contents here or directly in the active cell. (Page 375)

Column Headings (375)

at the top, the "A", "B", "C", etc

chart filter

controls which data series and categories are visible in a chart. by default all the data you selected to create the chart are used to construct the data series and categories. however you can apply a chart filter to hide extraneous data(pg 538)

Formula AutoComplete

displays a list of functions and defined names that match the letters. (pg. 456)

today function

displays the current date in a cell. pg463

Number Format

displays the values as you originally entered them. There's multiple number formatting styles including General, Number, Currency, Comma, Date, Time, and many more. (pg. 416-417)

Auto fill

enables you to copy the contents of a cell or a range of cells be dragging the fill handle over an adjacent cell or range of cells (386-87)

Auto Complete (pg. 378)

feature that searches for and automatically displays any other label in that column that matches the letters you typed

Median Function

finds the midpoint value, which is the value that one half of the data set is above or below. (Ignores empty cells and cells containing N/A or text.) Pg.460

Gridlines (525)

horizontal or vertical lines that span across the chart to help people identify the values plotted by the visual elements, such as a column. Horizontal gridlines display for column, line, scatter, stock, surface, and bubble charts. Vertical gridlines for bar charts.

Manual Page Break (pg. 538)

if a page break occurs in a undesired place, drag the page break line to the desired location

page break

indicates where the data will start in another printed page. To identify where the automatic page breaks will occur, click Page Break Preview on the status bar or in the Workbook Views group on the View Tab. If the automatic page break occur in undesirable locations, you can adjust the page break.

y-axis

is a vertical border that provides a frame of reference for measuring data vertically, it is also located along with the x-axis in the plot area.-pg 506

Chart(pg.506)

is a visual representation of numerical data that compares data and helps reveal trends or patterns to help people make informed decisions

freeze top rows

keeps only the top visible as you scroll through a worksheet pg.557

Value(pg.379)

numbers that represent a quantity or measurable amount. Excel usually distinguishes between text and value data based on what you enter

chart sheet

similar to a line chart in that it shows trends over time; however, the area chart displays colors between the lines to help illustrate the magnitude of changes.A chart sheet contains a single chart only; you cannot enter data and formula on a chart sheet. If you leave the chart in the same worksheet, you can print the data and chart on the same page. if you want to print or view a full- sized chart, move the chart to its own chart sheet. pg 517

CountBlank Function

tallies the number of cells in a range that contain values you can use in calculations. (pg. 461)

definition

you can use semi selection a process of selecting a cell or range of cells for entering cell references as you create formulas. click the cell where you want to enter the formula type an (=) to start the formula click the cell or drag to select the cell range the values to create the formula type a mathematical operator press enter to create the formula