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