159 terms

Excel 2007

Excel 2007 terms CIS110
office button
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
Title Bar
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
Column headings
the letters that appear along the top of the worksheet window to identify the different columns in the worksheet
Workbook Window
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
zoom controls
controls for magnifying and shrinking the content displayed in the active workbook window
view shortcuts
buttons used to change how the worksheet content is displayed-Normal, page layout, or page break preview view
sheet tabs
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
row headings
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
active cell
the cell currently selected in the active worksheet
name box
a box that displays the cell reference of the active cell
formula bar
a bar that displays the value or formula entered in the active cell
active sheet
the sheet currently displayed in the workbook window
active workbook
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
chart sheet
contains an excel chart that provides a visual representation of spreadsheet data
a collection of text and numberslaid out in a rectangular grid
what-if analysis
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
cell reference
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
formula bar
displays the content of the active cell and, shows any formulas used to create calculated values
text data
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
text string
a string of text characters
number data
any numerical value that can be used in a mathmatical calculation
date data
commonly recognized formats for date values
time data
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
cell range
a group of cells
a group of cells
adjacent range
a single rectangular block of cells A1:G5
nonadjacent range
consists of two or more adjacent ranges A1:A5
range referance
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
arithmatic operators
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
editing mode
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
spelling checker
editing tool that verifies the words in the active worksheet against the programs dictionary.
nomal view
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
portrait orientation
the page is taller than it is wide. (default)
landscape orientation
the page is wider than it is tall
a computer program used to enter, analyze, and present quantitative data
formula view
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
live preview
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
serif fonts
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
theme font
associated with a particular theme and used for headings and body text in the workbook.
office theme
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.
non-theme font
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.
font style
italic, bold, bold italic, and special effects, such as underline, strikethrough, and color text
font size
used to increase or decrease the size of the test.
what font sizes are measured in. approximately 1/72 of an inch.
theme colors
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.
standard colors
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.
custom color
can be created by specifying a mixture of red, blue, and green color values, making available 16.7 mil colors.
automatic color
uses your windows default text and background color values, usually black text on a white background.
mini toolbar
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
format painter
copies the formating from one cell or range to another cell or range without duplicating any of the data.
a collection of formating
conditional formating
applies formating only when a cells value meets a specified condition
data bar
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.
print area
select the cells you want to print. can cover an adjacent or nonadjacent range
page break
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
print titles
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
excel table
a range of data as a distinct object in a worksheet
table style
formats the entire table as a single unit
banded rows
makes text easier to read
relative references
always interpreted in relation or relative to the location of the cell containing the formula
absolute references
marked with a dollar sign before each column and row designation. references that are fixed.
mixed reference
contains both relative and absolute references
F4 key
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
optimal arguements
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.
fill handle
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
logical function
function that works with values that are only true or false
IF function
logical function that returns one value if the statement is true and returns a different value if the statement is false
comparison operator
a symbol that indicates the relationship between two values
date function
function in which the worksheet will always display the current date
PMT function
calculate the payments for any type of loan
financial functions
calculate values from loans and investments
amount of money being loaned
the amount charged for lending the money
simple interest
interest paid is equal to a percentage of principle for each period that the money has been lent
compound interest
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)
data source
range that contains the data you want displayed in the charts
data series
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
series name
identifies the series
series values
actual data displayed in the chart
catagory values
groups or catagories that the series values belong to.
pie chart
chart in the shape of a circle that shows data values as a percentage of the whole
embedded chart
chart is placed in a worksheet next to its data source
chart sheet
the entire sheet contains only the chart and no worksheet cells
selection box
enables you to move or resize a chart
resizing handle
changes the width and height of a chart
chart area
rectangular box containing the chart and all of the other chart elements
chart title
discriptive label or name for the chart, usually appears at the top of the chart area
plot area
the part of the chart that contains the graphical representation of all the data series in the chart
data marker
represents each data value or data series
rectangular are that labels the markers or symbols used in the chart.
data label
text associated with a data value
leader lines
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
column chart
displays values in different catagories as columns; the height of each column is based on its own value.
bar chart
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.
line chart
compares values from several catagories with a sequential order, such as dates and times that occur at evenly spaced intervals
combination chart
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