Excel
Which tab/group combination contains the tool to have text appear at an angle within the cell?
Home/alignment
Sort
To arrange a list of words or numbers in ascending or descending order
File Tab
explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.
worksheet
A 'page' of an Excel workbook, accessible by the tabs at the bottom
Cell range
A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)
Border
A line or box that frames a cell.
Input message
A message that appears when the cell becomes active; can be used to specify the type of data the user should enter in that cell.
Excel table
A range of data you can treat as a distinct object in a worksheet.
Accounting Number Format button
Adds dollar signs and two decimal places to selected data
Fill Months
Auto Fill option that fills destination area with series of months
source area
Cell being copied
Merge & Center button
Centers cell contents over multiple cells
Conditional formatting
Changes formatting of a cell that meets a certain rule
chart
Conveys a visual representation of data
Text or numbers in a cell.
Data
Normal View
Default view in Excel
Formula Bar
Displays the contents stored in the active cell
Paste Options button
Immediately displays when you click the Paste button
Banded rows
In an Excel table, rows of alternating colors that make data easier to read.
font style
Indicates how the characters are emphasized
Drag-and-Drop method
Lets you move or copy data from one cell to another without using the Clipboard
Another name for a worksheet.
Spreadsheet
Data label
Text associated with a data value.
Primary sort field
The first sort field
Title Bar
The title bar text changes to display the name of the active document. Located at the top of the document
Chart Title
The title or name of chart usually identifying what data depicts, most often found at center top of chart area
zoom in
To magnify the appearance of a worksheet or chart
select
To make a cell active
Whenever you format data as a table, it will automatically include
filters
text
includes letters, numbers, symbols, and spaces
COUNTBLANK function
tallies the number of blank cells in a range
cell
the intersection of column and row
Cells a1:c5 in sheet 1 are created and named sales; how would a cell on sheet 2 reference the range?
(sales)
Unhide Row Tool
-ll-
What text qualifier tells Excel that the cell contains a formula
=
Zoom Slider
A bar in the lower-right corner of an Office program window that you can use to increase or decrease the size of the document on screen.
Selection box
A box surrounding an object that lets you move or resize the object.
Format painter
A button on the Ribbon that, when selected, copies a format from one cell range to another.
AutoSum
A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAX
Financial function
A category of Excel functions that calculate values from loans and investments.
Date function
A category of Excel functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900.
Combination chart
A chart that combines two or more chart types in a single graph.
Embedded chart
A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.
Text data
A combination of letter, numbers and some symbols.
Link
A connection between the files that allows data to be transferred from one file to the other.
Theme
A designed collection of formatting options that include color, graphics, and background images.
Click and Type
A feature that allows you to double-click a blank area of a document to position the cursor in that location, with the appropriate paragraph alignment already in place.
Scrollbar
A feature that allows you to scroll up and down or left and right in order to view portions of your work area
Spelling checker
A feature that check the words in a document against the program's built-in dictionary and helps you avoid typographical errors.
Category field
A field used to group the values in a PivotTable.
Sort field
A field you use to order data.
Average
A function that identifies the numeric average of a set of values in a column or a row
Autosum
A function to add a set of values in a column or a row
PivotChart
A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields.
Range
A group of worksheet cells, which can be adjacent or nonadjacent. (AKA a cell range)
Personal Macro Workbook
A hidden workbook named Personal. xlsb that opens
row
A horizontal arrangement of cells, organised by number
HTML (Hypertext Markup Language)
A language used to write Web pages.
Gridlines
A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axis.
Border
A line that prints along the side of a table cell or around the outside of selected text.
Formula
A mathematical function that contains cell addresses and mathematical operators
Error alert
A message that appears if a user tries to enter a value in the cell that does
Chart sheet
A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.
Manual page break
A page break that you insert anywhere on a page.
Exploded pie chart
A pie chart with one slice moved away from the pie as if someone were taking the piece out of the pie.
Function
A predefined formula that performs calculations using specific values called arguments.
Plot area
A rectangular area containing a graphical representation of the values in the data series.
Cell Range
A rectangular group of adjacent cells
External reference
A reference to a cell or range in a worksheet in another workbook.
Total row
A row at the end of an Excel table that is used to calculate summary statistics for the columns in the table.
Status Bar
A row of information related to the current program. It is usually located at the bottom of a window. Not all windows will have one.
Chart Sheet
A separate sheet in a workbook that stores a chart.
Data validation
A set of rules that determine what users can enter in a specific cell or range.
Conditional format
A setting that applies formatting only when a cell's value meets a specified condition.
Adjacent range
A single rectangular block that includes a group of contiguous cells.
Fill handle
A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents of the selected cells to adjacent cells.
Microsoft Excel 2007
A spreadsheet program you use to display, organize, and analyze numerical data.
Resizing handle
A square or dot on a selection box that lets you change and object's width and height.
Arithmetic operator
A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.
Default template
A template that creates the blank Book1 workbook that opens when you start Excel, The default template contains no text or formulas, but it includes all the formatting available in every new workbook
Insert Function
A toolbar button that displays functions by category that will assist you in writing the formula.
Landscape orientation
A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page.
Macro virus
A type of virus that uses a program's own macro programming language to distribute the virus.
Field name
A unique label that describes the contents of the data in a column, also called a column header.
Diagram
A visual representation of data to help readers better understand relationships among data
Defined name
A word or string of characters associated with a single cell or a range; also called a range name.
The correct way to display the range from A1 through C5 and formulas is
A1:C5
The correct syntax to make the contents of cell f23 always match the contents of cell d5 is to
Add the function "=d5" in cell f23
SUM function
Adds all the numbers in a range of cells
worksheet
Allows data easily to be summarized and charted
Cell Format
Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.
Collapse Arguments
Allows you to shrink the function dialogue box in order to choose cells for your function.
Workspace
An Excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom magnifications, and other settings.
Table style
An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row).
Relative Reference
An adjustable/changeable cell reference
Compound interest
An amount for which the interest paid is calculated on the principal and any previous interest payments that have been added to that principal.
Field
An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state); in Excel, each column represents a field.
Spreadsheet
An electronic file used to organize data and perform calculations
standard properties
Associated with all Microsoft Office files and include author, title, subject
insertion point
Blinking vertical line that indicates where next character typed will display
Auto Fill Options
Button that allows you to copy values with/without formatting or the format only
Anything typed into a cell.
Cell Content
Nonadjacent range
Cell range that is comprised of two or more separate adjacent ranges.
Radar Chart
Compares a collection of values through several data sets.
Criteria filter
Conditions you specify for a filter.
font
Defines appearance and shape of letters and numbers
relative reference
Each adjusted cell reference
The keyboard shortcut to define a cell as absolute is
F4
After reviewing tracked changes, they will no longer appear in your workbook.
False
Workbook
File consisting of one or more worksheets
underline
Format that underlines only the characters in a cell, not the entire cell
An equation that performs mathematical calculations on values in a worksheet.
Formula
NOW function
Function that will display the current system date and time
The default format that Excel applies to numbers is the:
General Formet
Chart
Graph that provides a visual representation of the workbook data.
Select Column
Highlight an entire column
Select Row
Highlight an entire row
format
How you make a worksheet easier to read and understand
relative cell reference
Instructs Excel to adjust cell references as it copies to destination area
[Ctrl][Home]
Moves cell pointer to cell A1
ScreenTip
Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing.
Clicking on the zoom indicator will
Open the zoom dialog box
Arguments
Parameters added to a function that help in evaluating data, or performing calculations
Insert Row/Column
Placing a new, blank row or column in the spreadsheet.
destination area
Range of cells receiving the copy
Which toolbar contains most of the commands that you'll need in Excel 2013?
Ribbon
The labels along the lower border of the Excel window that identify each worksheet.
Sheet Tabs
Bubble Chart
Shows patterns between two or more sets of data. The size of the data marker is determined by the 3rd value.
Doughnut Chart
Shows relative values of different categories to the whole. Displast multiple sets of data.
fill handle
Small black square located in the lower-right corner of the active cell
Comparison operator
Symbol that indicates the relationship between two values.
Series values
The actual data displayed in a chart.
Cell reference
The address of a cell indicating its column and row location.
Principal
The amount of money being loaned.
Sheet tab
The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.
Cell reference
The column letter and the row number. Ex: B12
Find
The command to locate specific letters and numbers in a workbook.
Replace
The command to overwrite letters and numbers in a workbook with another entry.
Median
The middle value in data.
y-axis
The vertical line on a graph
The data that displays in the Formula Bar is referred to as the:
Underlying Value
splitting
Unmerging a cell
Letters
Used to identify columns in a spreadsheet
Numbers
Used to identify rows in a spreadsheet
fill color
a background color appearing behind the data in a cell
Column Heading
a column letter above the grid that identifies each column
workbook
a file containing related worksheets
AutoSum
a function that automatically adds selected cells
data series
a group of related data points
Series
a predictable list of sequential numbers, dates, times, or text
table array
a range containing a lookup table
Cell Label
ability to use name box to name a range of cells/cell
table
an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis
trendline
an object used to depict trends and forecast future data
subordinate
belonging to a lower or inferior class or rank; secondary
SUBTOTAL function
calculates an aggregate for values in a range or a database
surreptitious
clandestine; furtive, secretive
Text Color
color that the text appears in in a cell
If you want to put your data into alphabetical order by last name, you could use the
command.
MAX function
displays the highest value in a range
Page Break
displays the location of the different page breaks within the worksheet
autofill
enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells
Xlsx
file extension used for Microsoft Excel 2013 documents-identifying the type of program used to create it
conditional formatting
highlights or emphasizes cells that meet certain conditions
cell address
identifies a cell by column letter and row number
subtle
not immediately obvious; abstruse
vertical alignment
positions data between the top and bottom cell margins
=AVERAGE(range)
returns the average (mean) of a range
=SUM(range)
returns the sum total of (adds up) a range
stimulation
something that arouses or causes something to happen
column index number
the argument in a VLOOKUP function that identifies which lookup table column from which to return a value
filtering
the process of displaying only records that meet specific conditions
semi selection (pointing)
the process of using the mouse pointer to select cells while building a formula
data label
the value or name of a data point
synthesize
to join, to integrate
Ascending order
to sort data in A>Z order
Move Tool
used to place a selection in a new location
Column
vertical group of cells named with a letter
strenuous
very remanding; requiring great exertion
When making an absolute cell reference, you'll need to include at least one
$ (dollar sign)
point
1/72 of an inch
Pie chart
A chart in the shape of a circle (like a pie) that shows data values as percentage of the whole.
Line chart
A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.
Worksheet protection
A setting that limits users' ability to modify the worksheet's contents, structure, or formatting.
Custom template
A workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting.
A cell surrounded by a black border and ready to receive data is the:
Active Cell
active cell
Area in which you can enter data, surrounded by a heavy border
When you create a formula, you'll always start by typing the ________ sign.
B. = (equals)
horizontal split bar
Bar going across the middle of a split screen
Increase Indent
Button used to move the contents of a cell to the right two spaces
mixed cell reference
Cell with only one dollar sign before the column or row
Font size
Determined by point size, which is a unit of measurement equal approximately to 1/72 of an inch.
Orientation
Direction in which contents of page will print
Formula AutoComplete
Displays an alphabetical list of functions from which you can choose
Cell
Intersection of a column and a row
Dialog box launcher
Item of the Ribbon that opens a dialog box or task pane
absolute cell reference
Keeps the same cell reference as it copies a formula from one cell to another
Print area
Selected portion of a worksheet to be printed.
range
Series of two or more adjacent cells in a column or row
Descending order
Sorts text in reverse alphabetically from Z to A, numbers from largest to smallest, and dates from newest to oldest.
Sheets Tab
Tabs that appear at the bottom of the workbook window,which displays the name of each worksheet
Drilling Technique
Taking the content from one sheet and pasting it to multiple sheets at one time.
Data
Text or numbers in a cell
Drag and drop
To move an item (either text or a graphic) by selecting it and dragging it with the mouse.
Clear
To remove
Delete
To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.
Descending order
To sort data in Z>A order
gridline
a horiztonal or vertical line that extends from the horizontal or vertical axis through the plot area
legend
a key that identifies color, gradient, picture, texture, or pattern fill assigned to each series in a chart
MEDIAN function
calculates the midpoint value in a set of values
Resize
change the size of
value axis
displays incremental values to identify the values of the data series
Status Bar
displays information about the current document
Name Box
displays the active cell address
formula bar
displays the content in the active cell
TODAY function
displays the current date
NOW function
displays the current date and time
sheet tab
displays the name of a worksheet within a workbook
name box
identifies the address of the current cell
HLOOKUP function
looks up a value in a horiztonal lookup table where the first row contains the values to compare with the lookup table
pie chart
shows each data point in proportion to the whole data series as a slice in a circular pie
bubble chart
shows relationships among three values by using bubbles
stock chart
shows the high, low, and close prices for individual stocks over time
Equal Sign
Used to indicate the start a formula
column chart
displays data comparisons vertically in a chart
surface chart
displays trends using two dimensions on a continuous curve
area chart
emphasizes magnitude of changes over time by filling in the space between the lines with a color
wrap text
enables a label to appear on multiple lines within the current cell
sparkline chart
Shows trends and variations in a range of data within a single cell
The steps to build a function in a cell are
Click on formula tab, chose insert function, enter required elements
Formula prefix
Equal sign preceding a formula
Worksheet
the workspace made up of columns and rows where you enter data to create an electronic spreadsheet
Mixed reference
Cell reference that contains both relative and absolute references, for example B$4.
To create a new worksheet
Click the Insert Worksheet tab, or Right-click on a worksheet tab and select Insert
A vertical group of cells in a worksheet
Column
Surface Chart
Compares three sets of values in a 3-D chart.
Area Chart
Compares values from different categories. Similar to a line chart except the areas under the line contain a fill color.
When printing pages, to keep the top 2 rows of data on every page
Page layout tab, print titles, and select rows to repeat
Ctrl
The key presses to select non adjacent cells of data to create a chart
Cell Address
The name of a cell; contains both the column and row reference
Series name
The name of the data series.
Scroll Bars
The navigation buttons are located on the bottom of the vertical and horizontal scroll bar to move up, down, left or right in the typing area
Portrait
The orientation of a document where the page is taller than it is wide.
Landscape
The orientation of a document where the width is greater than the height.
cell
The place data is entered; the intersection between a row and a column
Freeze
The process of keeping rows and/or columns you select visible in the workbook window as you scroll the worksheet.
Sort
The process of rearranging data in a certain order, such as ascending or descending.
Filter
The process of temporarily hiding records that do not meet the specific criteria.
Scale (n)
The range of values that spans along an axis.
Active cell
The selected cell in the worksheet; indicated with a dark border.
Custom list
The sequence you specify to sort data.
Alignment
When data is entered into a cell, the default alignment is labels to the left and values to the right
PMT function
calculates the periodic payment for a loan with a fixed interest rate and fixed term
SUM function
calculates the total of values contained in two or more cells
Absolute Reference
cell reference that points to a specific cell and does not change when copied ($B$4)
radar chart
compares aggregate values of three or more variables represented on axes starting from the same point
multiple data series
compares two or more sets of data in one chart
bar chart
compares values across categories using horiztontal bars
single data series
compares values for one set of data
superficial
concerned with or comprehending only what is apparent or obvious shallow
plot area
contains a graphical representation of values in a data series
Header
content appearing at the top of each printed page
table style
controls the fill color of the header row, columns, and records in a table
order of precedence
controls the sequence in which Excel performs arithmetic operations
print area
defines the range of data to print
Orientation
describes the direction of the page or the paper you will print on (landscape or portrait)
IIF function
evaluates a condition and returns one value if the condition is true and another value if the condition is false
To continue a series of dates, you can click and drag the
fill handle
Freeze Panes
allows the user to select specific rows or columns that remain visible when scrolling in the worksheet
Conditional formatting
allows you to automatically apply formatting to cells based on their values
field
an individual piece of data, such as a last name
formula autocomplete
displays a list of functions and defined names as you enter a function
stringent
imposing rigorous standards of performance; severe
Conditions Statements
in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.
sizing handle
indicated by faint dots on the outside border of the selected chart, enables you to adjust the size of the chart
relative cell reference
indicates a cell's relative location from the cell containing the formula; changes when the formula is copied
To select the contents of the entire worksheet
Click on the heading box above row 1 and left of column A, OR Ctrl + A
font color
Defines the color of characters
enter
Key that can be used in place of the Paste button
HOME
Key that selects the cell at the beginning of a row with the active cell
Ascending order
Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
Sparklines
Argument
Specifies the numbers, text, or cell references used by a function to calculate a value.
font size
Specifies the size of characters
Report filter
Filters the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.
number sign
Formula error messages always begin with this
nested IF
IF function within an IF function
Range reference
Identification of a cell range using the upper-left and lower-right corners of the rectangular selection of cells.
Rows
Identified by numbers on the left side of the spreadsheet. (Horizontal)
Active Cell
Highlighted worksheet cell that is ready for data entry
Insert mode
Excel inserts the character and moves all characters to the right
Overtype mode
Excel replaces the character to the right of the insertion point
name box
Next to the formula bar, the place a cell's name or cell reference is specified
formula bar
Next to the name box, a cell's data or formula is displayed here when you select the cell
Constant values consisting of only numbers.
Number Values
volatile function
Number that the function returns is not constant
Horizontal (category) axis
On the horizontal axis, or x-axis, are the data series' category values, or x values.
Name box
Part of the Excel program window that displays the active cell address
When copying and pasting data, which paste option should be used to insert the data but not the original style
Paste special, paste
You can use the
Print Selection option to print a specific range in a worksheet.
If you are printing a worksheet and want the headings to appear on every page, click the
Print Titles command.
Graph
Provides a visual representation of the workbook data.
Quick Access Toolbar
Provides access to commonly used tasks like saving or printing a document, undo,redo, and new
Major tick mark
The indication of the major units of increment on the x- or y-axis.
Minor tick mark
The indication of the minor units of increment on the x- or y-axis.
Cell
The intersection of a column or row in a worksheet.
Cell
The intersection of a row and a column
Simple interest
The type of interest in which the interest paid is equal to a percentage of principal for each period that the money had been lent.
Point
The unit used to measure the size of the characters in a font.
Points
The unit used to measure the size of the characters in a font.
Column
The vertical reference in a spreadsheet
x axis
a horiztonal line that borders the plot area to provide a frame of reference for measurement
input area
a range of cells containing values for variables used in formulas
3-D chart
adds a third dimension to each data series, creating a distorted perspective of the data
A predesigned workbook you can use to create a new project quickly is called a(n)
template
Fill Color
the background of the cell
active cell
the current cell, indicated by a dark border
column width
the horiztonal measurement of a column
breakpoint
the lowest value for a series or specific category of the lookup table
Fill Handle
this is the name of the small black square that displays in the bottom right corner of the active cell
surpass
to be or go beyond, as in degree or quality; exceed
stigmatized
to characterize or brand as disgraceful or ignominious
Select
to choose or highlight a row, column, cell or range
stymie
to hinder or obstruct
You can use Document Inspector
to remove personal information from a workbook.
Bar chart
A column chart turned on its side, so each length is based on its value.
Validation rule
A statement that defines criteria for the data that can be stored in a cell or range.
Formula
Equations with symbols for math operations. Example =B6+B7+B8+B9
What character can be placed in front of data to force excel to treat it as text?
'
Record
A collection of related fields that are grouped together, in Excel, each row represents a record.
Automatic color
A color option that uses the Windows default text and background color values.
Worksheet
A blank page in a spreadsheet file
XY scatter chart
A chart that shows the patterns or relationship between two or more sets of values.
Workbook
A file containing multiple spreadsheets
Workbook
A file that contains one or more spreadsheets
Theme font
A font associated with a particular design theme and used for headings and body text.
Sans serif font
A font that does not have the small horizontal lines (called serifs) at the tops and bottoms of letters.
Serif font
A font that includes small horizontal lines (called serifs) at the tops and bottoms of letters.
Hyperlink
A link in a file, such as a workbook, to information within that file or another file that, when clicked, switches to the file referenced by the hyperlink.
Editing mode
A mode in which you can edit part of an entry rather than the entire contents of a cell.
Number data
A numerical value that can be used in a mathematical calculation.
Cursor
A representation on the screen of the mouse pointer location
Style
A saved collection of formatting options - number formats, text alignment, font size and colors, borders, and background fills - that can be applied to cells in a worksheet.
Font
A set of characters that uses the same typeface, style, and size.
Order of precedence
A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second and so forth.
Comment
A text box that is attached to a specific cell in a worksheet in which you can enter notes.
Mini toolbar
A tool bar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands, such as font, font size, styles, color, alignment, and indents that may appear in different groups or tabs on the Ribbon.
fill
A tool in Excel that allows you to copy down or across from an existing cell to enter formulas or data into other cells
Spreadsheet
A tool used in business for budgeting, inventory management, and decision making fir analyzing and reporting information.
View short-cuts toolbar
A toolbar located at the right end of the status bar that contains tools for switching between views of document content and changes the display magnification
Quick Access Toolbar
A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.
Portrait orientation
A type of page orientation in which the page is taller than it is wide (like a typical business letter.)
column
A vertical arrangement of cells, organised by letter
Template
A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.
Planning analysis sheet
A worksheet that includes questions to help you define the purpose and objective of a workbook.
Expand Arguments
Allows you to expand the function dialogue box in order to adjust the arguments in your function.
PivotTable
An interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.
text
Any set of characters containing letters, hyphens, or spaces
Formula Bar
Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is
Auto Fill
Copy Cells
Auto Fill option that fills destination area but does not create a series
Fill Formatting Only
Auto Fill option that fills destination area using format of source area
Fill Without Formatting
Auto Fill option that fills destination area with contents without formatting
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
AutoFit
vertical split bar
Bar going up and down the middle of a split screen
formula
Beginning with an 'equals sign', a calculation or function that can be entered into a cell
splitting
Breaking the Excel window into four panes
Copy button
Button used to copy contents and format of a source area to the Office Clipboard
Decrease Indent
Button used to move the contents of a cell to the left two spaces
Paste button
Button used to paste a copy of the Office Clipboard contents
The intersection of a column and a row.
Cell
Another name for a cell reference.
Cell Address
merging cells
Creating a single cell by combining two or more cells
What answer would Excel give if you typed =3+6*2 into a cell?
D. 15
Fill Series
Default Auto Fill option that Excel uses to fill an area
General number format
Default number format that automatically displays number, for the most part, the same way you enter them.
Fill color list arrow
Displays background color options for a cell
Non-theme font
In Excel, a font that can be used no matter what theme the workbook has.
Leader line
In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force Excel to place a data label far from its slice.
Fill handle
Lets you copy cell contents or continue a series of data into a range of selected cells
Page break
Location in a worksheet that determines where a new page begins.
Active cell
Location in the worksheet that will displays typed data that will be affected by a command
* (Shift 8)
Multiplication symbol used in an Excel formula
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
Name Box
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
Operators
A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:
Quick Analysis Tool
sensitivity analysis
Scrutinizing the impact of changing values referenced by a formula in a cell
Margo would like to have the contents of cell F12 turn red if the value falls below 12, what steps should she take?
Select Cell F12, choose home tab/cells/conditional formatting
What is the sequence to use to change the format of data in a cell
Select cell, choose home tab, cells grouping, format
format symbol
Symbols that assign a format to numbers as they are entered
Chart title
Term that appears above the plot area and describes the contents of the plot area and the data series.
Footer
Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation.
Header
Text that appears at the top of every page in a document or every slide in a presentation.
bold
Text that has a darker appearance than normal text
Label
Text, symbols, dates, or numbers not used in calculations
Theme color
The 12 colors that belong to a workbook's theme.
Data series
The Chart Wizard organizes data sources into a collection, where each data series is a range of data values that is plotted as a unit on the chart.
workbook
The Excel document that holds all the worksheets
Perspective
The illusion that some parts of the 3-D chart are farther away from you than others.
Primary value axis
The axis in a column chart that displays the primary values associated with the heights of each column.
Secondary value axis
The axis in a column chart that displays the secondary values associated with the heights of each column.
Formula bar
The bar located above the workbook window in which the contents of a cell are displayed.
Name box
The box located on the far left of the Formula bar in which the cell reference to the active cell is also displayed.
Name Box
The box that contains the cell address
Excel Help Button
The button located at the right end of the ribbon and labeled with a question mark (?), that provides access to the Excel Help system
Cell Reference
The column letter and the row number. Example: B12
Workbook
The file in which Excel stores an electronic spreadsheet.
PMT function
The financial function to calculate the amount paid into an investment or loan during each payment period.
When a cell that contains a function is selected the formula bar will display
The formula
Data marker
The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in the pie charts, and the points used in XY (scatter) charts.
Category values
The group or category to which a series value belongs.
x-axis
The horizontal line on a graph
Row
The horizontal reference in a spreadsheet
Mode
The most common value in data.
Header row
The row of field names.
Secondary sort field
The second sort field.
arithmetic operations
The simple mathematical functions: plus, minus, multiplied by, and divided by
Margin
The space between the page content and the edges of the page.
Source file
The workbook that contains the data when two files are linked.
Destination file
The workbook that receives the data when two files are linked; sometimes referred to as the dependent file.
Active workbook
The workbook you are currently using.
Active sheet
The worksheet currently displayed in the workbook window.
Sort
To arrange data in alphabetical or numerical order.
Formatting
To change the appearance, not the data, of your workbook.
Truncate
To cut off, or hide, the part of an entry that does not fit in a cell.
goal seeking
To determine the value of a cell on which the formula depends
Autofit
To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.
Autofit
To make a column or row as it needs to be to fit the data contained in the cell, Determines the best width for a column or the best height for a row, based on its contents.
Merge and Center
To make one cell out of several highlighted cells and then center the content of that cell
Cut
To remove data from a cell and place it on the Office Clipboard.
zoom out
To shrink the appearance of a worksheet or chart
Chart
a graphic representation of values used to identify trends and contrasts in data
formula
a combination of cell references, operators, values, and/or functions used to perform a calculation
record
a complete set of data for an entity
spreadsheet program
a computer application used to create a modify spreadsheets
category label
a text that describes a collection of data points in a chart
Slicers
are basically just filters
mixed cell reference
contains a relative and an absolute cell reference; the absolute part does not change but the relative part does change
nonadjacent range
contains multiple ranges of cells
chart area
contains the entire chart and all of its elements
Footer
content appearing at the bottom of each printed page
MIN function
displays the lowest value in a range
absolute cell reference
indicates a cell's specific location; does not change when the formula is copied
How does a user define a cell name (A1) as an absolute reference
$A$1
How do you change the order of the worksheets in a workbook?
Click on a worksheet and drag-and-drop it to the position that you want it in
Tabs
Demonstrate the access to the various groups of commands on the ribbons, Excel includes 8 tabs on the Ribbon.
When the data in a workbook is larger than can be printed on a single page, excel prints:
Depends on the user preference
Row
Horizontal groups of cells named with a number
What layout is similar to the print review
Page layout
A mouse pointer shaped like a hand when on a cell means
You can grab and move the cell contents
Function
special formulas that do not use operators to calculate results. A shortcut formula Ex: sum(B6:B9)
logical test
an expression that evaluates true or false
argument
an input, such as a cell reference or value, that i neededto complete a function
Page layout view
In Excel, a view that shows how the worksheet will be laid out on the pages sent to the printer.
Column heading
In Excel, the part of the worksheet that identifies each column by a different letter.
sparkline
a miniature chart contained in a single cell
The small black square in the lower right corner of a selected cell.
Fill Handle
Formula view
Excel view in which cell formulas are displayed rather than the values returned by the formulas.
lookup table
a range that contains data for the basis of the lookup and data to be retreived
range
a rectangular group of cells
format painter
Used to quickly copy a cell's format to another cell
syntax
a set of rules that governs the structure and components for entering a function properly
fill handle
a small black square at the bottom-right corner of a cell
function screen tip
a small popup description that displays the arguments for a function as you enter it
structured reference
a tag or use of a table element as a reference in a formula
y axis
a vertical line that borders the plot area to provide a frame of reference for measurement
To open a new Excel workbook
Click on file (Backstage) tab, select new, choose blank workbook
To select the contents of columns A through C
Click on the column header for A and drag to the column header for C
The steps to create a new file based on a template are
Double-click a template file, and Open Excel, click File, click New, select template to use
Mary has three worksheets that she would like to label as summary, detail and look up. She should
Double-click each tab and type over the highlighted text, or Right-click each one and choose rename, then enter the appropriate name
When copying cells that have formulas with relative references, the formula will work
If the data for the new location is in the same relative location
Ctrl+c
Keyboard shortcut for copy
Ctrl+v
Keyboard shortcut for paste
Ranges can be defined by
Naming the upper left cell : lower right cell
What group of tools on the home tab allow a user to switch the format of numbers
Number
Landscape and portrait are
Orientations
Cell address
The intersection of a row and column
function
a predefined formular that performs a calculation
output area
a range of cells containing results based on manipulating the variables
worksheet
a spread sheet that contains formulas, functions, values, text, and visual aids
chart
a visual representation of numerical data
If you wanted to filter data to exclude a certain word or phrase, you could use a(n)
advanced text filter
Goal Seek
allows you to work backward to find the desired input value
spreadsheet
an electronic file that containsa grid of columns and rows containing related data
Workbook
an excel file with one or more worksheets
total row
appears as the last row of a table to display summary statistics, such as a sum
Row
appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window
Column
appears vertically in a worksheet and is identified by letters at the top of the worksheet window
sorting
arranges records in a table by the value in fields within a table
stilted
artificially formal; contrived
subjective
based on or influenced by personal feelings, tastes, or opinions.
AVERAGE function
calculates the arithmetic mean or average of the values contained in two or more cells
stacked column chart
places stacks of data in segments on top of each other in one coloumn, with each category in the data series represented by a different color
horizontal alignment
positions data between the right and left cell margins
pv
present value of the loan
category axis
provides descriptive group names for subdividing the data series
In order to share a workbook online, you must first
save it to your OneDrive
exploded pie chart
separates one or more pie slices from the rest of the pie chart
XY scatter chart
shows a relationship between two variables
doughnut chart
shows values as percentages of the whole but may contain more than one data series
supplement
something added to complete a thing, make up for a deficiency, or extend or strengthen the whole
100% stacked column chart
stacks data in one column per category, with each column having the same height (100%)
COUNTA function
tallies the number of cells in a range that are not empty
COUNT function
tallies the numbers of cells in a range that contain values
Pie Chart
A chart used to visually display the parts of a whole as percentages, a circular chart divided into triangular areas proportional to the percentages of the whole
relative cell reference
A code that points to a particular cell, which changes depending where that code is entered; for example, it may point to a cell that is one column to the left and one row above the cell where the formula is entered
absolute cell reference
A code that points to a unique cell, independently of where that code is entered; dollar signs are used to 'lock' the column and row
Group
A collection of buttons for related commands on the Ribbon.
A range of cells is
A collection of individual cells
Worksheet group
A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group.
Standard color
A color that is always available regardless of the workbook's theme.
Custom color
A color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.
Pixel
A colored dot that, when combined with other pixels, forms a picture or graphics display; stands for picture element.
A small red triangle in a cell indicates
A comment associated to the cell
Data bar
A horizontal bar added to the background of a cell whose length reflects the cell's value.
IF function
A logical function that returns one value if the statement is true and returns a different value if the statement is false.
Formula
A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done.
Operator
A mathematical symbol that you use to combine values and then return a single value.
Screen Tip
A note that appears on the screen to provide information about a button, tracked change, or comment, or to display footnote or endnote. Also displays the text that will appear if you choose to insert a date or AutoText entry.
Value
A number entered into a spreadsheet cell that will be used for calculations
Thumbnail
A small representation of an item, such as an image, a page of content, or a set of formatting, obtained by scaling a snapshot of it. They are typically used to provide visual identifiers for related items.
Template
A spreadsheet already set up for a specific purpose
Excel application
A spreadsheet written or tailored to meet the user's specific needs; typically includes reports and charts, a data entry area, a custom interface, as well as instructions and documentation.
Spreadsheet
A program that allows you to use rows and columns of data to manage, predict, and present information.
Macro
A series of stored commands that can be run whenever you need to perform that task.
Locked property
A setting that determines whether changes can be made to a cell.
Workbook protection
A setting that limits users' ability to make changes to the
Column chart
A type of chart that displays values in different categories as columns; the height of each column is based on its value.
Column header
A unique label that describes the contents of the data in a column.
Ribbon
A user interface design that organizes commands into logical groups, which appear on separate tabs. The Ribbon includes tabs that have access to various groups and commands according to the task being performed.
Date data
A value in a recognized date format.
Time data
A value in a recognized time format.
Accent
A variation on an Excel theme color.
The type of cell reference that refers to cells by their fixed position in a worksheet is:
Absolute
Insert Tab
Allows you to add various items into a document; such as pages, tables, charts, illustrations, links to Internet sites or other documents, headers, footers,text and symbols
AutoFill
An Excel tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the copy and past commands.
Live preview
An Office feature that shows the results you would achieve in your file, such as the effects of formatting options on a document's appearance, if you click the option to which you are pointing.
What-if analysis
An approach using an electronic spreadsheet in which you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change.
Ribbon
An area at the top of the Excel 2010 window where almost all the capabilities of Word are available to help you use the program efficiently.
Optional argument
An argument that is not necessary for the function to calculate a value (if an optional argument is not included, Excel assumes a default value for it.)
Digital signature
An electronic version of a signature that provides a way to authenticate a workbook; also called a digital certificate.
Column Chart
An image used to compare different groups of data to each other through the use of vertical columns of different lengths
Spelling button
Checks for apparent misspellings in a worksheet
[Delete]:
Clears the contents of selected cells
Data source
Any file that contains the data you want to retrieve.
Cancel box
Cancels an entry by tapping or clicking
The area along the bottom of a chart that identifies the categories of data is the:
Category Axis
Absolute reference
Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.
The graphic representation of data in a worksheet.
Chart
surface chart
Chart used to compare data from three columns in a three-dimensional manner
line chart
Chart used to illustrate changes in data over time
pie chart
Chart used to show the contribution of each piece of data to the whole
Numbers, text, dates, or times of day that you type into a cell.
Constant Value
When using fill down, which is NOT an option
Copy without formatting
AutoCorrect feature
Corrects common mistakes when you complete a text entry in a cell
According to the order of operations, which operation is performed first in the following equation: =D1/5+1*D3/(D3-D2)?
D3-D2
document properties
Details about a file such as the project author, title, and subject
Data definition table
Documentation that lists the fields to be maintained for each record and a description of the information each field will include.
Worksheet
Each workbook is made up of individual worksheets, or sheets, containing formulas, functions, values, text, and graphics.
When a chart is selected, what tabs will appear in the chart tools contextual menu
Format, layout, design
An element in the Excel window that displays the value or formula contained in the active cell is the:
Formula Bar
Tom would like to show only some rows in his worksheet and would like to choose the row using the data in a column
He should filter the data using the criteria
Which options are not available in the page layout tools
Header and Footer
Frank would like to fill a list with the days of the week but wants to leave a blank column between each day. He should
Highlight the first day and a blank cell to the right, use the fill handle to the right
Page break preview
In Excel, a view that displays the worksheet as it is divided up into pages. Anything outside of the print area is grayed out.
Print title
In Excel, information that prints on each page.
Row heading
In Excel, the part of a worksheet that identifies each row by a different number.
Module
In VBA, a collection of sub procedures.
Sub procedure
In VBA, all of the actions performed in a macro.
Value field
In a PivotTable, a field that contains summary data.
Relative reference
In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. If you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula.
requirements document
Includes a needs statement, source of data, and summary of calculations
Cell
Individual locations on a spreadsheet
hard copy
Information that exists on a physical medium such as paper
PAGE DOWN
Key that selects the cell down one worksheet window from the active cell
PAGE UP
Key that selects the cell up one worksheet window from the active cell
Legend
Labels that identify the different data series in a chart.
automatically updated properties
Properties that include system file properties
A feature that outlines cells in color to indicate which cells are used in a formula is called:
Range Finder
F4 key
Rather than retyping a formula, you can switch reference in editing mode by selecting the cell reference and pressing the F4 key.
3-D Reference
Refers to the same cell or range in multiple worksheets in the same workbook. The reference specifies not only the range of rows and columns, but also the range of worksheet names in which the cells appear. (Example: WorksheetRange!CellRange )
To insert a comment into a cell
Right-click in the cell select insert comment
What tab/group combination is used to change the type of chart used
Right-click on the chart and select change chart type, OR Chart tool tab
To change the color of a worksheet tab
Right-click on the tab and choose tab color, or Click on the worksheet tab, click Home, click Format, choose Tab Color
A horizontal group of cells in a worksheet
Row
Which function would you use to add the values of several cells?
SUM
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
Select All Box
To move the contents of cell B4 to F10
Select B4, roll over the edge of the cell and drag the cell to F10, OR Select B4, right-click and select Cut, click on F10, right-click Paste
Frank would like to move the contents of column F in between the A and B columns he should
Select column F, choose cut, click on the column header for B and choose insert cut cells
Creating a chart follows these basic steps
Select data, choose chart, adjust format
Juan is creating a worksheet that has each week in the month of January in cells B2-B5. How can he put the Label "January" above the cells and center it
Select the cells above the weeks choose merge and center
To resize a column to fit the data automatically
Select the column and choose home/cells/ format autofit, OR Go between the column to be sized and the next column and double click
Julia would like to rearrange her data so that it is in order by the first column
Select the data, choose sort, select first column
To reference the data from cell b5 on sheet 1, a different sheet in the same workbook the syntax is
Sheet1!(b5)
Stock Chart
Shows stock market data like highs, lows, opening price and closing price.
Name Box
Shows the address of the active cell Ex: A1
date stamp
Shows the date a workbook was created or the time period it represents
Insertion Point
Shows various forms based on the function being performed and the location to which the mouse is pointing. When you are inserting text, it is an I-beam.
The fill data handle looks like
Small black plus sign
Merge Cells
Takes two or more cells and combines them into one.
File Tab
The File Tab explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.
Active Cell
The cell ready for data entry
Chart area
The entire chart and all the elements contained in the chart or graph, such as the title and legend.
AutoComplete
The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.
Fill handle
The small black square in the bottom right corner of as cell that allows you to fill adjacent cells with a repeated formula
Typeface
The specific design of a set of printed characters, including letters, numbers, punctuation marks, and symbols.
Normal view
The view that renders the workbook and worksheets for the computer screen.
Vertical (value) axis
The y-axis where, for example, data values, such as sales values, are plotted.
When the mouse pointer turns into 2 parallel lines with arrows in opposite directions it means:
There is a hidden row/column
Scale (v)
To change the size of a graphic to make it fit into a document.
Merge
To combine the main document with a data source.
Rename sheet
To rename a sheet in a workbook. Right click the sheet tab ,click rename.
Refresh
To update
Text string
Two or more text characters.
Custom margins
Used to center the spreadsheet both horizontally and vertically on a printed page.
Legend
Used to identify the format of the data marker used for each series in a chart. Used if the chart contains more than one data series.
Insert Function dialog box
Used to search for a particular function.
IF function
Used when you want to assign a value to a cell based on a logical test
drag and drop
Using touch or the mouse to move or copy cells
Another name for a constant value.
Value
Data label
Value or name assigned to individual data points.
assumptions
Values in cells that you can change to determine new values for formulas
Font style
Various ways that fonts can be displayed, such as regular, italic, bold, or bold italic; a special attribute applied to the characters of a font.
Workbook window
Window in which a workbook is displayed; also called worksheet window.
An Excel file that contains one or more worksheets
Workbook
On startup, Excel displays a new blank:
Workbook
What is the correct hierarchy?
Workbook, worksheet, cell
Filter
a condition that data must meet to be included in a selection - a way of limiting data in a list
color scale
a conditional format that displays a particular color based on the relative value of a cell's contents to other selected cells
icon set
a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range
nested function
a function that contains another function embedded inside one or more of its arguments
chart title
a label that describes a chart
axis title
a label that describes either the category axis or the value axis
Border
a line that indicates a boundary of a cell or range
border
a line that surrounds a cell or range
Row Heading
a number at the far-left side of a row that can be clicked to select the entire row of cells
value
a number that represents a quantity or amount
data point
a numerical value that describes a single value on a chart
The Subtotal command will automatically
group, outline, and summarize your data.
clustered column chart
groups or clusters similar data in columns to compare data across categories
page break
indicates where data starts on a new printed page
synergy
interaction of two or more agents or forces so that their combined effect is greater than any individual part
symbiosis
interdependent relationship
lookup value
is a reference to a cell containing a value to look up
freezing
keeps rows and/or columns visible as your scroll through a sheet
When reading a chart, you should refer to the
legend to see which color is used to represent each data series.
Freezing panes allows you to
lock row(s) or column(s) in place
VLOOKUP function
looks up a value in a vertical lookup table and returns a related result from the lookup table
strident
loud, harsh, grating, or shrill; discordant
supine
lying on the back or having the face upward
Grouping worksheets allows you to
make changes to multiple worksheets at once
To combine several adjacent cells into one large cell, you will need to
merge cells
If you want to display a date in a certain way (such as Friday, March 1, 2013), you can adjust the
number format
range
numbers and/or cell references, separated by commas (discrete) or by a colon (continuous)
circular reference
occurs when a formula directly or indirectly refers to itself
suspension of disbelief
temporarily and willingly setting aside our beliefs about reality in order to enjoy a story
rate
the periodic interest rate (ex. monthly)
Cell Alignment
the position in which text is placed within a cell
print order
the sequence in which pages print
nper
the total number of payment periods
row height
the vertical measurement of a row
Selection Tool
thick white cross
succumb
to submit to an overpowering force or yield to an overwhelming desire; give up or give in
substantiate
to support with proof or evidence; verify
Cell Value
what is typed into a cell-contained with in
range name
word or string of characters that represents one or more cells
One advantage of sparklines is that
you can keep them very close to their source data