a button that provides access to workbook-level features and program setting
Quick Access Toolbar
a collection of buttons that provide one-click access to commonly used commands, such as Save, Undo, and Repeat
a bar that displays the name of the active workbook and the excel program name
The main set of commands organized by task into tabs and groups
the letters that appear along the top of the worksheet window to identify the different columns in the worksheet
a window that displays an excel workbook
vertical scroll bar
a tool used to scroll up or down through the workbook window
horizontal scroll bar
a tool used to scroll left and right through the workbook window
controls for magnifying and shrinking the content displayed in the active workbook window
buttons used to change how the worksheet content is displayed-Normal, page layout, or page break preview view
tabs that display the names of the worksheets in the workbook
sheet tab scrolling buttons
buttons to scroll the list of sheet tabs in the workbook
the number that appears along the left of the worksheet window to identify the different rows in the worksheet
select all button
a button used to select all of the cells in the active worksheet
the cell currently selected in the active worksheet
a box that displays the cell reference of the active cell
a bar that displays the value or formula entered in the active cell
the sheet currently displayed in the workbook window
the workbook that is curently being used
active workbook window
window in which the active workbook is displayed
An excel file--can contain several worksheets
contains data laid out in rows or columns
what each workbook is made up of
contains an excel chart that provides a visual representation of spreadsheet data
a collection of text and numberslaid out in a rectangular grid
change in one or more values in a spreadsheet and asses the effect those changes have on the calculated value
where rows and columns interesect
the location of a cell in a worksheet identified by its column letter and row number, this is also known as the cell's address.
planning analysis sheet
a series of questions that help you think about the purpose of the workbook and how to acheive your desired results
displays the content of the active cell and, shows any formulas used to create calculated values
a combination of letters, numbers, and some symbole that form words and sentences. often refered to as text string because it contains a string of text characters
a string of text characters
any numerical value that can be used in a mathmatical calculation
commonly recognized formats for date values
commonly recognized for time values
To shorten by or as if by cutting off
helps make entering repetitive text easier
a single point on a computer monitor or printout
1/72 of an inch, row heigts are expressed in ______
eliminates any empty space by matching the column to the width of its longest cell entry or the row to the height of its tallest cell entry
removes the data but leaves the blank cells
removes both data and cells
a group of cells
a group of cells
a single rectangular block of cells A1:G5
consists of two or more adjacent ranges A1:A5
indicates the location and size of the cell range.
drag and drop
dragging the range and dropping it in its new location
places the cell contents into computer memory or on the clipboard. the contents can be pasted from the clipboard into a new location in the worksheet
an expression that returns a value. in most cases, this is a number
combine different values, returning a single value that is then displayed in the cell. how a formula is written
the most commonly used operators. perform addition, subtraction, multiplication, division, and exponentation.
order of precedence
set of predefined rules used to determine the sequence in which operations are applied in a calculation.
a named operation that returns a value. used to simplify formulas, reducing what might be a long expression into a compact statement.
quickly inserts excel functions that summerize all the values in a column or row using a single statistic
quickly inserts excel functions that summerize all the values in a column or row using a single statistic
ways to edit the contents of a cell.
command to locate numbers and text in the workbook
command that matches numbers or text and replaces it with other text
editing tool that verifies the words in the active worksheet against the programs dictionary.
shows the contents of the worksheet
page layout view
shows how the worksheet will appear on the page or pages sent to the printer
page break preview
displays the location of the different page breaks within the worksheet
the page is taller than it is wide. (default)
the page is wider than it is tall
a computer program used to enter, analyze, and present quantitative data
a view of the workbook contents that displays formulas instead of the resulting values
reduces the width and height of the printout to fit the number of pages specified by shrinking the text size as needed.
a collection of formating that specifies the fonts, colors, and graphical effects used throughout the workbook. you can choose different ones of these from a list, or create your own
shows the effects of formating options on the workbooks appearencebefore you apply them. lets you see and evaluate different formats as you develop your workbook.
a set of characters that employ the same type face
such as times new roman, have extra decorative strokes at the end of each character.
sans serif fonts
such as arial, do not include decorative strokes
associated with a particular theme and used for headings and body text in the workbook.
default theme. uses cambria for headings and the theme font calibri for body text.
specific design used for characters, including letters, numbers, punctuation marks, and symbols.
use this when you dont want to associate a font with a particular design. text formated with this retains its appearence no matter what theme is used with the workbook.
italic, bold, bold italic, and special effects, such as underline, strikethrough, and color text
used to increase or decrease the size of the test.
what font sizes are measured in. approximately 1/72 of an inch.
12 colors belonging to the workbooks theme. 4 colors are used for text and backgrounds, six colors are used for accents and highlights, and two colors are used for hyperlinks. designed to work well together and to remain readable in all color combos.
dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple. always available regardless of the workbooks theme. you can also open an extended palete of 134 colors.
can be created by specifying a mixture of red, blue, and green color values, making available 16.7 mil colors.
uses your windows default text and background color values, usually black text on a white background.
appears when you select text and contains buttons for commonly used text formats.
general number format
by default, numbers appear in this format, which for the most part, displays numbers exactly as you enter them.
one way to align text over several columns or rows. to combine several cells into one cell.
provides options for adding cell borders. a line that separates one area from another
copies the formating from one cell or range to another cell or range without duplicating any of the data.
a collection of formating
applies formating only when a cells value meets a specified condition
a horizontal bar added to the background of a cell to provide a visual indicator of the cells value.
a key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted.
select the cells you want to print. can cover an adjacent or nonadjacent range
prints as much on a page and then inserts a ______ to continue printing the remaining content on the next page.
manual page breaks
specifys exactly where the page breaks occur
repeat information such as the company name by specifying rows or columns in the worksheet. info that prints on each page.
text printed in the top margin of each page
text printed in the bottom margin of each page
space between the page content and the edges of the page
a range of data as a distinct object in a worksheet
formats the entire table as a single unit
makes text easier to read
always interpreted in relation or relative to the location of the cell containing the formula
marked with a dollar sign before each column and row designation. references that are fixed.
contains both relative and absolute references
you can switch the reference in editing mode by selecting the cell reference and pressing this key.
middle data value when in order
most common values in the data, most often used with data that has only a few possible values.
set of rules which specifies how the function should be written
the numbers, text, or cell references used by the function to return a value. always seperated by a coma
not required for the function to return a value, but can be included to provide more control over the returned value
functions can be placed inside another function
insert function dialog box
organizes all of the functions by catagory and allows you to search for functions that perform particular calculations
copies content and formats from a cell or range into an adjacent cell or range.
small black square in the lower right corner of a selected cell or range. excell copies the formulas and formats from the original cell into the adjacent range
function that works with values that are only true or false
logical function that returns one value if the statement is true and returns a different value if the statement is false
a symbol that indicates the relationship between two values
function in which the worksheet will always display the current date
calculate the payments for any type of loan
calculate values from loans and investments
amount of money being loaned
the amount charged for lending the money
interest paid is equal to a percentage of principle for each period that the money has been lent
interest paid is calculated on the principle and any previous interest payments that have been added to that principle.
visual representation of a set of data (also called graph)
range that contains the data you want displayed in the charts
range of values that is plotted as a single unit on the chart. each has 3 components: a series name, the series values, and the catagory values
identifies the series
actual data displayed in the chart
groups or catagories that the series values belong to.
chart in the shape of a circle that shows data values as a percentage of the whole
chart is placed in a worksheet next to its data source
the entire sheet contains only the chart and no worksheet cells
enables you to move or resize a chart
changes the width and height of a chart
rectangular box containing the chart and all of the other chart elements
discriptive label or name for the chart, usually appears at the top of the chart area
the part of the chart that contains the graphical representation of all the data series in the chart
represents each data value or data series
rectangular are that labels the markers or symbols used in the chart.
text associated with a data value
added to labels to connect them to their corresponding slices, the line portion of a leader connecting the shoulder to an arrowhead.
exploded pie charts
moves one piece away from the pie as if someone were taking a piece out of the pie
controls how fast the chart appears to recede from the viewers eye
displays values in different catagories as columns; the height of each column is based on its own value.
column chart turned to its side so each bar length is based on its value.
verticle (value) axis
displays the values associated with the heights of each column
primary value axis
one axis, usually the one on the left
secondary value axis
the other axis is called this
major tick mark
acts like the lines on a ruler, making it easier to read the scale. each value has one.
minor tick marks
further devides the space between the major tick marks. used in some axes.
a range of values that spans the verticle axis
extend the tick marks across the plot area
horizontal (catagory) axis
displays the catagories associated with each data value.
compares values from several catagories with a sequential order, such as dates and times that occur at evenly spaced intervals
a chart that combines two or more chart types in a single graph. to create: select a data series in an existing chart, and then apply a new chart type to that series, leaving only the other data series in its original format
XY scatter chart
shows the patterns or relationship between two or more sets of values. often used in scientific studies and statistical analysis