63 terms

# Excel Chapter 1

Go! with Microsoft Excel 2010 Comprehensive
###### PLAY
workbook
An excel document which contains three worksheets by default but can have more than three
worksheet
A single sheet contained in an excel workbook
a worksheet, one page in a workbook with rows and columns
column
a vertical group of cells in a worksheet
a column letter above the grid that identifies each column
row
a horizontal group of cells
a number at the far-left side of a row that can be clicked to select the entire row of cells
cell content
anything you type in a cell; most common values are text values and number values
constant value
simply a value, a number or letter that does not change based on other cell content
formula
an equation that performs mathematical calculations on values in your worksheet
label
a text value
active cell
Highlighted worksheet cell that is ready for data entry
cell reference
the intersecting column letter and row number; cell address
data
text or numbers in a cell
left alignment
Text is lined up against the left margin.
autocomplete
suggests text to inset quickly into your document
fill handle
the small black square in the lower right corner of a selected cell, lets you copy cell contents or continue a series of data into a range of selected cells
Auto Fill
generates and extends a series of values into adjacent cells based on hte value of other cells
series
a group of things that come one after another in succession
context sensitive
options are related to the current task
pixels
picture element, a point of light measured in dots per square inch
range
two or more cells on a worksheet that are adjacent or nonadjacent`
gerneral format
a specific way in which Excel displays numbers, the default number format
displayed value
data that displays in a cell
underlying value
data that displays in the formula bar
point and click method
Allows you to point and click each cell in a formula rather than typing cell references
rounding
a procedure that determines which digit at the right of the number will be the last digit displayed and then increases it by one if the next to its right is 5-9
relative cell reference
a cell reference based on the relative position of the cell that contains the formula and the cells refered to
Merge & Center
joins selected cells into one larger cell and centers the contents in the new cell
cell style
a defined set of formatting characteristics, such as font, font size, font color, cell borders and cell shading
Accounting number format
applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis when negative numbers are present
Comma stye
inserts thousand comma separators where appropriate and applies two decimal places
chart
a graphic representation of data in a worksheet
sparklines
tiny charts embedded in a cell and give a visual trend summary alongside your data
column chart
useful for illustrating comparisons among related numbers
chart types
ways you can display data in a way that is meaningful to the reader; e.g. column charts, pie charts, and line charts
category labels
labels that display along the bottom of the chart to identify the category of data; category axis or the x-axis
value axis
on the left of the chart, excel includes a numerical scale on which the charted data is based; y-axis
legend
on the right, identifies the tterns or colors that are assigned to the categories in the chart
data point
a value that originates in a worksht cell
data marker
a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point
chart layout gallery
you can select a predesigned chart layout
chart layout
a combination of chart elements, which can include a title, legend, labels for the columns, and the table of charted cells
Chart styles gallery
displays an array of predefined chart styles
chart styles
the overall visual look of the chart in terms of its colors, backgrounds and graphic effects such as flat or beveled columns
page layout view
you can see the edges of the paper of multiple pages, the margins, and the rulers
normal view
maximizes the number of cells visible on your screen and keeps the column letters and row numbers closer
Autofit
adjusts the width of a column to fit the cell content of the widest cell in the column
scaling
shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convient for printing formulas
arithmetic operators
the symbols used to perform basic mathematical operations
absolute cell reference
refers to a cell by its fixed position in the worksheet
range finder
the referenced cells are displayed in color and bordered with the same color; useful for verifying formulas because it visually indicates which workbook cells are included in a formula calculation
Autosum
a function that automatically adds the values in the cells directly above or to the left of the active cell
expand formula bar button
increases the height of the formula bar to display lengthy cell content
expand horizontal scroll bar button
increases the width of the horizontal scroll bar
horizontal window split box
splits the worksheet into two horizontal views of the same worksheet
name box
displays the name of the selected cell, table, chart or object
operators
symbols with which you can specify the type of calculation you want to perform in a formula
select all box
selects all the cells in a worksheet
sheet tab scrolling buttons
display sheet tabs that are not in view when there are numerous sheet tabs
status bar
displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average
vertical window split box
splits the worksheet into two vertical views of the same worksheet
workbook-level buttons
minimize, close, or restore the previous size of the displayed workbook