Excel Tutorial 1
planning analysis sheet
A series of questions that help you think about the workbook's purpose and how to achieve the desired results. (EX 8)
order of precedence
A set of predefined rules used to determine the sequence in which operators are applied in a calculation. (EX 30)
chart sheet
A sheet that contains only the chart and no worksheet cells. (EX 5)
pixel
A single point on a computer monitor or printout. (EX 16)
Microsoft Excel 2010
A spreadsheet program used to enter, analyze, and present quantitative data. (EX 1)
search string
A string of characters to locate. (EX 40)
replacement string
A string of characters to use in place of the search string. (EX 40)
date data
A value in a recognized date format. (EX 9)
time data
A value in a recognized time format. (EX 9)
formula view
A view of the worksheet that displays formulas instead of the resulting values. (EX 46)
arithmetic operator
An mathematical symbol representing the operations of addition, subtraction, multiplication, division, or exponentiation. (EX 30)
AutoSum
A button that inserts Excel functions to sum, average, or count all the values in a column or row, or display the minimum or maximum value in a column or row. (EX 23)
formula
A mathematical expression that returns a value. (EX 22)
operator
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. (EX 30)
function
A named operation that returns a value; used to simplify formulas. (EX 34)
formula bar
The bar located below the Ribbon that displays the value or formula entered in the active cell. (EX 2)
Select All button
The button used to select all of the cells in the active worksheet. (EX 2)
view buttons
The buttons that change how the worksheet content is displayed—Normal view, Page Layout view, or Page Break Preview. (EX 23)
active cell
The cell currently selected in the active worksheet. (EX 3)
cell reference
The column and row location that identifies a cell within a worksheet; for example, the cell reference B6 refers to the cell located where column B intersects row 6. (EX 6)
nonadjacent range
The combination of two or more distinct adjacent ranges. (EX 23)
AutoComplete
The feature that helps make entering repetitive text easier; as you type text into the active cell, Excel displays text that begins with the same letters as a previous entry in the same column. (EX 11)
column headings
The letters along the top of the worksheet that identify the different columns in the worksheet. (EX 3)
range reference
The location and size of a cell range. (EX 24)
cell
The intersection of a single row and a single column. (EX 3)
active sheet
The sheet currently displayed in the workbook window. (EX 2)
Page Break Preview
The view of the worksheet that displays the location of each page break. (EX 43)
Page Layout view
The view that shows how the worksheet will appear when printed. (EX 43)
cut
To place cell contents into computer memory or on the Clipboard; the contents can then be pasted from the Clipboard into a new location in the worksheet. (EX 28)
text string
Two or more text characters. (EX 9)
workbook
An Excel file containing a collection of worksheets and chart sheets. (EX 2)
sheet tab scrolling buttons
Buttons used to scroll the list of sheet tabs in the worksheet. (EX 2)
spelling checker
A feature that verifies the words in the active worksheet against the program's dictionary; you can replace or ignore the words it flags as misspelled. (EX 22)
adjacent range
A group of cells in a single rectangular block of cells. (EX 23)
cell range
A group of cells, which can be either adjacent or nonadjacent. (EX 22)
what-if analysis
An approach in which you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. (EX 4)
Name box
The box located at the left side of the formula bar that displays the cell reference of the active cell. (EX 2)
row headings
The numbers along the left side of the worksheet that identify the different rows in the worksheet. (EX 2)
portrait orientation
The page orientation where the page is taller than it is wide. (EX 44)
landscape orientation
The page orientation where the page is wider than it is tall. (EX 44)
autofit
To eliminate empty space by matching the row height or column width to its tallest or longest cell entry. (EX 17)
spreadsheet
A collection of text and numbers laid out in a rectangular grid. (EX 4)
worksheet
A grid of rows and columns in which the contents of the spreadsheet are laid out. (EX 3)
point
A unit of measure equal to approximately 1/72 of an inch. (EX 17)
text data
Any combination of letters, numbers, and symbols that form words and sentences. (EX 9)
number data
Any numerical value that can be used in a mathematical calculation. (EX 9)
sheet tab
The area at the bottom of the worksheet that identifies the sheet by name. (EX 2)
Normal view
The default Excel view that shows the contents of the worksheet. (EX 43)
Edit mode
The mode in which you can edit cell contents. (EX 39)
drag and drop
The technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, and then dragging the selection to a new location. (EX 27)
truncate
To hide from the view (EX 10)
scale
To reduce the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed. (EX 47)
delete
To remove both the data and the cells from the worksheet. (EX 20)
clear
To remove data from a worksheet, leaving blank cells where the data had been. (EX 20)