Final

MIN (Minimum)

(minimum) statistical function will give you the lowest value in a range of values. =MIN(A3:A6)

cut

A cell or range of cells that is cut is removed from the workbook and stored for later use

Average

AVERAGE statistical function is used to calculate the average value of a group of values. Average is calculated by adding the values, and then dividing the sum by the number of values. A formula using the AVERAGE function looks like this: =AVERAGE(B3:D3)

Wide Margin

Adds more space at the top, bottom, left, and right sides.

theme fonts

Affects the fonts used for cell styles (including titles and headings). Changing the theme fonts does not limit the fonts available to you from the Font group on the Ribbon.

Alignment group

Align Left, Center, or Align Right Top Align, Middle Align, or Bottom Align

Long Date Format

Applies a longer format displaying the day of the week, and then the name of the month, the two‐digit date, and the four‐digit year (Monday, September 05, 1966).

Short Date Format

Applies a simple format displaying the one‐ or two‐digit number representing the month, followed by the one‐ or two‐digit number representing the day, followed by the four‐digit year (9/5/1966).

color scales

Color the cells according to one of the color scales (e.g., red to green [bad/low to good/high] or blue to red [cold/low to hot/high])

Highlight Cells Rules

Conditional formatting with Highlight Cells Rules allows you to define formatting for cells that meet specific numerical or text criteria (e.g., greater than a specific value or containing a specific text string). Use this type of conditional formatting when you want to highlight cells based on criteria you define.

theme effects

Controls the way graphic elements in your worksheet appear. Chart styles change according to the theme color and effects.

LOWER

Converts the text string to all lowercase letters. A formula using the LOWER function looks like this: =LOWER(E2)

UPPER

Converts the text string to all uppercase letters. A formula using the UPPER function looks like this: =UPPER(D2)

PROPER

Converts the text string to proper case (the first letter in each word is capitalized). A formula using the PROPER function looks like this: =PROPER(C2)

CountBlank

Counts the number of blank cells within a specified range of cells. Cells that contain a zero (0) are not considered blank. Use COUNTBLANK to find the number of rows missing values in a column. A formula using the COUNTBLANK function looks like this: =COUNTBLANK(E6:E17)

Counta

Counts the number of cells that are not blank within a specified range of cells. Use COUNTA if your cell range includes text data or a mix of text and numbers. A formula using the COUNTA function looks like this: =COUNTA(B6:B17)

Count

Counts the number of cells that contain numbers within a specified range of cells. A formula using the COUNT function looks like this: =COUNT(G6:G17)

Data Bars

Display a color bar (gradient or solid) representing the cell value in comparison to other values (cells with higher values have longer data bars)

icon sets

Display a graphic in the cell representing the cell value in relation to other values.

Top/Bottom Rules

Excel automatically finds the highest, lowest, and average values to compare values to, rather than asking you to enter criteria (as you do when using Highlight Cells Rules).

AutoSum

Excel enters the SUM function arguments using the most likely range of cells based on the structure of your worksheet. For example, if you use AutoSum at the bottom of a column of values, Excel will assume that you want to use the values in the column as the function arguments.

landscape orientation

If your workbook is wide, you may want to use landscape orientation instead, where the width of the page is greater than the height.

theme colors

Limits the colors available from the color palette for fonts, borders, and cell shading. Notice that when you change themes, the colors in the color palette change.

Narrow Margin

Reduces the amount of space at the top, bottom, left, and right sides, so more of your worksheet fits on each printed page.

Percentage

The Percentage option on the Number Format menu does not apply the same percent format as clicking the Percent Style button on the Ribbon. The Percentage option from the Number Format menu displays two digits to the right of the decimal.

Number

The default Number format shows two decimal places by default (so 43 displays as 43.00) but does not include commas

x-axis

The x axis goes from left to right. It is the horizontal axis. Typically, but not always, values are plotted against the y axis and categories are listed along the x axis.

y-axis

The y axis goes from bottom to top. It is the vertical axis.

grouping

This is convenient when you are setting up a series of worksheets with the same row or column headings. When sheets are grouped together, you can also change column widths and formatting, add formulas such as totals, or add headers and footers. Using grouping saves time and ensures that the sheets share a consistent format.

Normal Margin

Uses Excel's default margins: 0.75 inch for the top and bottom and 0.7 inch for the left and right.

Currency

With the Currency format, columns of numbers do not align at the $ and at the decimal as they do with Accounting Number Format. Instead, the Currency format places the $ immediately to the left of the number.

Cell Range

a contiguous group of cells. A cell range is identified by the address of the cell in the upper left corner of the range, followed by a colon, and then the address of the cell in the lower right corner of the range. The cell range B3:D5 includes cells B3, B4, B5, C3, C4, C5, D3, D4, and D5.

chart

a graphic that represents numeric data visually. In a chart, the values selected in the worksheet the data points, are transformed into graphic data markers.

Row

a horizontal group of cells. Rows are identified by numbers. For example, the third row is labeled with the number 3.

Print Area

a range of cells that you designate as the default print selection. If you have defined a print area for your worksheet, it will be the only part of the worksheet that prints.

Column

a vertical group of cells. Columns are identified by letters. For example, the fourth column is labeled with the letter D.

Accounting Number Format

aligns the $ at the left side of the cell, displays two places after the decimal, and aligns all numbers at the decimal point

Page Break Preview view

allows you to manipulate where page breaks occur when the worksheet is printed. You will work with Page Break Preview view when you learn about inserting page breaks.

redo

allows you to reverse the Undo command and restore the file to its previous state

Worksheet

an electronic ledger in which you enter data. The worksheet appears as a grid where you can enter and then manipulate data using functions, formulas, and formatting. Excel workbooks have one worksheet by default named Sheet1. You can rename, add, and delete worksheets as necessary.

Status Bar

appears at the bottom of the worksheet grid and can display information about the selected data, including the number of cells selected that contain data (count) and the average and sum (total) of the selected values (when appropriate).

Name Box

appears at the left side of the formula bar and displays the address of the selected cell. If a group of cells is selected, the Name box displays the address of the first cell in the group.

Functions

are preprogrammed shortcuts for calculating equations. Functions can simplify a straightforward computation such as figuring the total of a list of values. They can also calculate the answer to a complicated equation such as figuring the monthly payment amount for a loan.

Margin

blank spaces at the top, bottom, left, and right of a printed page. You may need to adjust the margins individually for each worksheet in your workbook to ensure they print exactly as you intend.

data markers

columns, bars, pie pieces or other visual elements in a chart that represent data point values

Find and Replace

commands that allow you to search for and replace data in your file. In Excel, these commands can be used to find and replace not only text but also numbers in values and formulas in a single worksheet or across an entire workbook.

Formula Bar

data entry area directly below the Ribbon and above the worksheet grid. Although you can type any data in the formula bar, the Insert Function button at the left side of the formula bar was designed to make it easier to create complex formulas.

Status Bar

displays whether you are in Ready or Edit mode and information about the selected cells (such as the number of cells selected, the sum of the values in the selected cells, or the average of the values in the selected cells)

Percent Style Format

displays zero places to the right of the decimal point.

Autofill

feature to fill a group of cells with the same data or to extend a data series. With AutoFill, you can copy the same value or formula to a group of cells at once

General Number Format

format right-aligns numbers in the cells but does not maintain a consistent number of decimal places (43.00 will appear as 43, while 42.25 appears as 42.25) and does not display commas (so 1,123,456 appears as 1123456)

VLOOKUP

function finds a value or cell reference in a cell range and returns another value from the same row. VLOOKUP requires you to specify the value you want to find, the cell range that contains the data, and the column that contains the value you want the function to return. =VLOOKUP(B2,Inventory,2,FALSE)

TODAY

function inserts only the current date =TODAY() - does not require arguments

NOW

function inserts the current date and time =NOW() - does not require arguments

CONCATENATE

function to combine the text values of cells. For example, if you have two columns for first name and last name, but you need a third column displaying the full name, you can use CONCATENATE to combine the values of the first two columns. =CONCATENATE(B2 ," ", A2)

Relative Reference

is a cell reference that adjusts to the new location in the worksheet when the formula is copied.

Absolute Reference

is a cell reference whose location remains constant when the formula is copied.

Mixed Reference

is a combination cell reference with a row position that stays constant with a changing column position (or vice versa).

cell style

is a combination of effects that can be applied at one time. Styles can include formatting such as borders, fill color, font size, and number formatting

Template

is a file with predefined settings that you can use as a starting point for your workbook.

Quick Analysis Tools

is a new feature in Excel 2013 to help you easily apply formatting, create charts, and insert formulas based on the selected data.

chart title

is a text box above or overlaying the chart. To change the title text, click the box to select it and edit the text directly in the text box. You can also type new text in the formula bar and then press ↵Enter.

theme

is a unified color, font, and effects scheme. When you apply a theme to the workbook, you ensure that all visual elements work well together, giving the workbook a polished, professional look.

footer

is text that appears at the bottom of every page, just above the bottom margin

header

is text that appears at the top of every page, just below the top margin

chart area

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

Dependent

is the cell containing a formula that references the value or formula in the selected cell.

Precedent

is the cell containing the formula or value the selected cell refers to

Normal View

is the typical working view. In Normal view, Excel shows the aspects of the worksheet that are visible only on-screen. Elements that are visible only when printed (like headers and footers) are hidden.

Merge Across

lets you merge cells in multiple rows without merging the rows together. The cells in each row will be merged together, keeping the data in the leftmost cell in each row, but still keeping each row separate.

Merge Cells

lets you merge cells together without centering the data. Like the Merge & Center command, Merge Cells will combine all the selected cells into one cell, keeping only the data in the uppermost left cell.

Name Manager

lists all the named ranges used in your workbook, the current value for each, the cells to which the name refers (including the sheet name), the scope of the name (whether it is limited to a specific worksheet or applies to the entire workbook), and comments (if there are any).

IF

logical function returns one value if a condition is true and another value if the condition is false. The IF function can return a numerical value or display a text string. =IF(C2>D2,"no","yes")

Font

or typeface, refers to a set of characters of a certain design. The font is the shape of a character or number as it appears on‐screen or when printed

Protected View

provides a read‐only format that protects your computer from becoming infected by a virus or other malware

Conditional formatting

provides a visual analysis of data by applying formatting to cells that meet specific criteria (conditions)

KD

refer to cells in other worksheets within formulas. For example, this formula will calculate the sum of cells B3:D33 from the KD worksheet: =SUM(KD!B3:D33)

Alignment

refers to how text and numbers are positioned within the cell both horizontally and vertically

orientation

refers to the direction the worksheet prints. It doesn't affect the way the worksheet looks on your computer screen. The default print setting is for portrait orientation

Page Layout view

shows all the worksheet elements as they will print. Page Layout view includes headers and footers. You will work with Page Layout view when you learn about headers and footers

Unmerge Cells

splits a merged cell back into its original cells. When the selected cell is a merged cell, clicking the Merge & Center button will also undo the merge.

MAX (Maximum)

statistical function will give you the highest value in a range of values. A formula using the MIN or MAX function looks like this: =MAX(A3:A6)

copy

stores a duplicate of the selected cell or range without changing the workbook

plot area

the area where the data series are plotted.

Column Selector

the box with the column letter at the top of the worksheet grid

Row Selector

the box with the row number at the left side of the worksheet grid

Cell

the intersection of a column and a row. A cell is identified by the cell address — its column and row position. For example, the cell at the intersection of column B and row 4 has a cell address of B4.

gridlines

the lines that appear on the worksheet defining the rows and columns. Gridlines make it easy to see the individual cells in your worksheet. By default, gridlines are visible on-screen when you are working in Excel, but they do not print.

headings

the numbers at the left of rows and the letters at the top of columns. By default, Excel displays the row and column headings on-screen to make it easy to identify cell references but they do not print.

Volatile Function

they are not constant. They update with the current date or date and time each time the workbook is opened. This is useful if you want to keep track of the last time the workbook was edited or opened. ie. NOW, TODAY

Fill color

to change the background color of cells

Format painter

to copy formatting from one part of your worksheet to another, rather than trying to recreate the exact combination of font color and size, number formatting, borders, and shading to reuse.

PMT

use to calculate loan payments. The PMT function is based upon constant payments and a constant interest rate. To calculate a payment using PMT, you need three pieces of information: the interest rate, the number of payments, and the amount of the loan. PMT(interest rate, number of loan payments, loan principal amount) = PMT(4%/12,36,2500)

Undo

used to insert copied or cut cells into a workbook

paste

used to insert copied or cut cells into a workbook

data points

values from a cell range plotted on a chart

General Horizontal alignment

when cells are formatted using the General horizontal alignment, Excel detects the type of content in the cell. Cells that contain text are aligned to the left, and cells that contain numbers are aligned to the right.

portrait orientation

when the height of the page is greater than the width (like a portrait hanging on a wall).

divide by zero error

which look like this in your worksheet: #DIV/0! (because Excel cannot calculate a value to display).

freeze

you can keep column headings and row labels visible as you scroll through your data.