EXCEL Tutorial 1

spread sheet

a collection of text & numbers laid out in a rectangular grid

microsoft excel 2010

a computer program used to enter, analyze and present qualative data

adjacent range

a group of cells in a single block of cells

arithmatic operators

a mathematical symbol representing the operations of addition, subtraction, multiplication, division or exponetion

operators

a mathematical symbol used in a formula to combine different values - resulting in a single value that is displayed within the cell

pixel

a single point on a computer moniter or print out

point

a unit of measure equal to approx.

date

a value in a recognized date formate

time data

a value in a recognized time format

what-if analysis

an approach in which you change 1 or more values in a spread sheet & then assess the effect those changes have on the calculated value

text data

any combination of letters, #'s and symbols that form words & sentences

number data

any numerical value that can be used in mathematical calculation

select all button

used to select all of the cells in the active worksheets

sheets

worksheet

sheet tab scrolling buttons

button used to scroll the list of sheet tabs in the worksheet

view buttons

buttons that change how the worksheet content is displayed - normal view, page layout, page break preview

name box

displays the cell reference of the active cell

formula bar

displays the value or formula entered in the active cell

row headings

the #'s along the left side of the worksheet window that identify the different rows in the worksheet

sheet tab

the area @ the buttom of the worksheet that identifies the sheet by name

active cell

the cell currently selected in the active worksheet

active sheet

the cell currently selected in the active worksheet

cell refrence

the column & row location that identifies a cell within a worksheet

non adjacent range

the combination of 2 or more distinct adjacent ranges

auto complete

the feature that helps make enetering repetitive text easier; type text into active cell excel displays text that beings with the same letters as a previous entry in the same column

cell

the intersection of a single row/column.

column heading

the letters along the top of the worksheet that identify the different columns in the worksheet

range reference

the location & size of a cell range

edit mode

the mode in which you can edit cell contents

drag & drop

the technique to move a cell or range by selecting it positioning the pointer over the bottom border of the selection & than dragging the selection to a new location

auto fitting

to eliminate empty space by matching the row height or column width to it's tallest or longest cell entry

truncated

to hide from view

cutting

to place cell contents into a computer memory or on the clipboard- contents then can pasted from clipboard into a new location in the worksheet

delete

to remove both the data & the cells from the worksheet

clear

to remove, such as data from a worksheet where the data had been or a filter

auto sum

(sum button) a button that inserts excel functions to sum average, or count all the values in a column or row or display the min/max value in a column or row

cell range

(range) a group of cells which can either be adjacent or non adjacent

text string

2 or more text characters

planning analysis sheet

a series of questions that help you think about the workbook's purpose & how to achieve the desired results

order of precedence

a set of predefined rules used to determine the sequence in which operators are applied in the calculation

chart sheet

a sheet that contains only the chart & no worksheet cells

work books

excel stores spreadsheets in files

spell checker

feature that verifies the words in an active worksheet against the programs dictionary