Excel 2007

Created by lrippy84 

Upgrade to
remove ads

159 terms · 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

Ribbon

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

workbook

An excel file--can contain several worksheets

worksheet

contains data laid out in rows or columns

sheets

what each workbook is made up of

chart sheet

contains an excel chart that provides a visual representation of spreadsheet data

spreadsheet

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

cell

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

truncate

To shorten by or as if by cutting off

AutoComplete

helps make entering repetitive text easier

pixel

a single point on a computer monitor or printout

point

1/72 of an inch, row heigts are expressed in ______

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

clear

removes the data but leaves the blank cells

delete

removes both data and cells

cell range

a group of cells

range

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

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

formula

an expression that returns a value. in most cases, this is a number

operators

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.

function

a named operation that returns a value. used to simplify formulas, reducing what might be a long expression into a compact statement.

sum

quickly inserts excel functions that summerize all the values in a column or row using a single statistic

autosum

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.

find

command to locate numbers and text in the workbook

replace

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

Excel

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

scaling

reduces the width and height of the printout to fit the number of pages specified by shrinking the text size as needed.

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

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.

font

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.

typeface

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.

points

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.

merge

one way to align text over several columns or rows. to combine several cells into one cell.

border

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.

style

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.

legend

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.

header

text printed in the top margin of each page

footer

text printed in the bottom margin of each page

margin

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.

median

middle data value when in order

mode

most common values in the data, most often used with data that has only a few possible values.

syntax

set of rules which specifies how the function should be written

arguements

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

nested

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

autofill

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

principle

amount of money being loaned

interest

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.

chart

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

legend

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

perspective

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

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set