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.