Excel 2007
Excel 2007 terms CIS110
Terms
undefined, object
copy deck
- name box
- a box that displays the cell reference of the active cell
- editing mode
- ways to edit the contents of a cell.
- gridlines
- extend the tick marks across the plot area
- font style
- italic, bold, bold italic, and special effects, such as underline, strikethrough, and color text
- absolute references
- marked with a dollar sign before each column and row designation. references that are fixed.
- syntax
- set of rules which specifies how the function should be written
- general number format
- by default, numbers appear in this format, which for the most part, displays numbers exactly as you enter them.
- nested
- functions can be placed inside another function
- scaling
- reduces the width and height of the printout to fit the number of pages specified by shrinking the text size as needed.
- series values
- actual data displayed in the chart
- arithmatic operators
- the most commonly used operators. perform addition, subtraction, multiplication, division, and exponentation.
- verticle (value) axis
- displays the values associated with the heights of each column
- format painter
- copies the formating from one cell or range to another cell or range without duplicating any of the data.
- 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.
- 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.
- resizing handle
- changes the width and height of a chart
- row headings
- the number that appears along the left of the worksheet window to identify the different rows in the worksheet
- sheet tab scrolling buttons
- buttons to scroll the list of sheet tabs in the workbook
- Ribbon
- The main set of commands organized by task into tabs and groups
- chart
- visual representation of a set of data (also called graph)
- delete
- removes both data and cells
- bar chart
- column chart turned to its side so each bar length is based on its value.
- vertical scroll bar
- a tool used to scroll up or down through the workbook window
- spelling checker
- editing tool that verifies the words in the active worksheet against the programs dictionary.
- sans serif fonts
- such as arial, do not include decorative strokes
- relative references
- always interpreted in relation or relative to the location of the cell containing the formula
- exploded pie charts
- moves one piece away from the pie as if someone were taking a piece out of the pie
- serif fonts
- such as times new roman, have extra decorative strokes at the end of each character.
- sheets
- what each workbook is made up of
- minor tick marks
- further devides the space between the major tick marks. used in some axes.
- zoom controls
- controls for magnifying and shrinking the content displayed in the active workbook window
- header
- text printed in the top margin of each page
- PMT function
- calculate the payments for any type of loan
- portrait orientation
- the page is taller than it is wide. (default)
- series name
- identifies the series
- banded rows
- makes text easier to read
- active workbook
- the workbook that is curently being used
- what-if analysis
- change in one or more values in a spreadsheet and asses the effect those changes have on the calculated value
- time data
- commonly recognized for time values
- pixel
- a single point on a computer monitor or printout
- truncate
- To shorten by or as if by cutting off
- range referance
- indicates the location and size of the cell range.
- IF function
- logical function that returns one value if the statement is true and returns a different value if the statement is false
- chart sheet
- the entire sheet contains only the chart and no worksheet cells
- secondary value axis
- the other axis is called this
- landscape orientation
- the page is wider than it is tall
- find
- command to locate numbers and text in the workbook
- sheet tabs
- tabs that display the names of the worksheets in the workbook
- font size
- used to increase or decrease the size of the test.
- Title Bar
- a bar that displays the name of the active workbook and the excel program name
- formula bar
- displays the content of the active cell and, shows any formulas used to create calculated values
- chart sheet
- contains an excel chart that provides a visual representation of spreadsheet data
- leader lines
- added to labels to connect them to their corresponding slices, the line portion of a leader connecting the shoulder to an arrowhead.
- 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.
- major tick mark
- acts like the lines on a ruler, making it easier to read the scale. each value has one.
- F4 key
- you can switch the reference in editing mode by selecting the cell reference and pressing this key.
- typeface
- specific design used for characters, including letters, numbers, punctuation marks, and symbols.
- interest
- the amount charged for lending the money
- manual page breaks
- specifys exactly where the page breaks occur
- page break
- prints as much on a page and then inserts a ______ to continue printing the remaining content on the next page.
- 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.
- formula view
- a view of the workbook contents that displays formulas instead of the resulting values
- view shortcuts
- buttons used to change how the worksheet content is displayed-Normal, page layout, or page break preview view
- theme
- 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
- active workbook window
- window in which the active workbook is displayed
- principle
- amount of money being loaned
- points
- what font sizes are measured in. approximately 1/72 of an inch.
- style
- a collection of formating
- 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.
- print area
- select the cells you want to print. can cover an adjacent or nonadjacent range
- nonadjacent range
- consists of two or more adjacent ranges A1:A5
- optimal arguements
- not required for the function to return a value, but can be included to provide more control over the returned value
- legend
- rectangular are that labels the markers or symbols used in the chart.
- XY scatter chart
- shows the patterns or relationship between two or more sets of values. often used in scientific studies and statistical analysis
- cutting
- 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
- 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
- embedded chart
- chart is placed in a worksheet next to its data source
- mini toolbar
- appears when you select text and contains buttons for commonly used text formats.
- adjacent range
- a single rectangular block of cells A1:G5
- line chart
- compares values from several catagories with a sequential order, such as dates and times that occur at evenly spaced intervals
- chart area
- rectangular box containing the chart and all of the other chart elements
- drag and drop
- dragging the range and dropping it in its new location
- office theme
- default theme. uses cambria for headings and the theme font calibri for body text.
- perspective
- controls how fast the chart appears to recede from the viewers eye
- horizontal scroll bar
- a tool used to scroll left and right through the workbook window
- operators
- combine different values, returning a single value that is then displayed in the cell. how a formula is written
- number data
- any numerical value that can be used in a mathmatical calculation
- median
- middle data value when in order
- cell
- where rows and columns interesect
- border
- provides options for adding cell borders. a line that separates one area from another
- autofill
- copies content and formats from a cell or range into an adjacent cell or range.
- comparison operator
- a symbol that indicates the relationship between two values
- conditional formating
- applies formating only when a cells value meets a specified condition
- font
- a set of characters that employ the same type face
- workbook
- An excel file--can contain several worksheets
- mode
- most common values in the data, most often used with data that has only a few possible values.
- data source
- range that contains the data you want displayed in the charts
- date data
- commonly recognized formats for date values
- selection box
- enables you to move or resize a chart
- page layout view
- shows how the worksheet will appear on the page or pages sent to the printer
- autosum
- quickly inserts excel functions that summerize all the values in a column or row using a single statistic
- replace
- command that matches numbers or text and replaces it with other text
- data marker
- represents each data value or data series
- Excel
- a computer program used to enter, analyze, and present quantitative data
- simple interest
- interest paid is equal to a percentage of principle for each period that the money has been lent
- theme font
- associated with a particular theme and used for headings and body text in the workbook.
- data bar
- a horizontal bar added to the background of a cell to provide a visual indicator of the cells value.
- Quick Access Toolbar
- a collection of buttons that provide one-click access to commonly used commands, such as Save, Undo, and Repeat
- column chart
- displays values in different catagories as columns; the height of each column is based on its own value.
- horizontal (catagory) axis
- displays the catagories associated with each data value.
- logical function
- function that works with values that are only true or false
- insert function dialog box
- organizes all of the functions by catagory and allows you to search for functions that perform particular calculations
- data label
- text associated with a data value
- formula
- an expression that returns a value. in most cases, this is a number
- active sheet
- the sheet currently displayed in the workbook window
- select all button
- a button used to select all of the cells in the active worksheet
- point
- 1/72 of an inch, row heigts are expressed in ______
- margin
- space between the page content and the edges of the page
- plot area
- the part of the chart that contains the graphical representation of all the data series in the chart
- Column headings
- the letters that appear along the top of the worksheet window to identify the different columns in the worksheet
- spreadsheet
- a collection of text and numberslaid out in a rectangular grid
- primary value axis
- one axis, usually the one on the left
- nomal view
- shows the contents of the worksheet
- merge
- one way to align text over several columns or rows. to combine several cells into one cell.
- mixed reference
- contains both relative and absolute references
- financial functions
- calculate values from loans and investments
- arguements
- the numbers, text, or cell references used by the function to return a value. always seperated by a coma
- automatic color
- uses your windows default text and background color values, usually black text on a white background.
- table style
- formats the entire table as a single unit
- custom color
- can be created by specifying a mixture of red, blue, and green color values, making available 16.7 mil colors.
- formula bar
- a bar that displays the value or formula entered in the active cell
- planning analysis sheet
- a series of questions that help you think about the purpose of the workbook and how to acheive your desired results
- footer
- text printed in the bottom margin of each page
- chart title
- discriptive label or name for the chart, usually appears at the top of the chart area
- active cell
- the cell currently selected in the active worksheet
- scale
- a range of values that spans the verticle axis
- compound interest
- interest paid is calculated on the principle and any previous interest payments that have been added to that principle.
- legend
- a key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted.
- print titles
- repeat information such as the company name by specifying rows or columns in the worksheet. info that prints on each page.
- AutoComplete
- helps make entering repetitive text easier
- autofitting
- 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
- order of precedence
- set of predefined rules used to determine the sequence in which operations are applied in a calculation.
- range
- a group of cells
- cell range
- a group of cells
- Workbook Window
- a window that displays an excel workbook
- page break preview
- displays the location of the different page breaks within the worksheet
- office button
- a button that provides access to workbook-level features and program setting
- catagory values
- groups or catagories that the series values belong to.
- worksheet
- contains data laid out in rows or columns
- clear
- removes the data but leaves the blank cells
- text string
- a string of text characters
- date function
- function in which the worksheet will always display the current date
- 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
- excel table
- a range of data as a distinct object in a worksheet
- sum
- quickly inserts excel functions that summerize all the values in a column or row using a single statistic
- 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
- 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
- pie chart
- chart in the shape of a circle that shows data values as a percentage of the whole
- function
- a named operation that returns a value. used to simplify formulas, reducing what might be a long expression into a compact statement.