Excel Chapter 1

Created by olougb10 

Upgrade to
remove ads

63 terms · Go! with Microsoft Excel 2010 Comprehensive


An excel document which contains three worksheets by default but can have more than three


A single sheet contained in an excel workbook


a worksheet, one page in a workbook with rows and columns


a vertical group of cells in a worksheet

column heading

a column letter above the grid that identifies each column


a horizontal group of cells

row heading

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


an equation that performs mathematical calculations on values in your worksheet


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


text or numbers in a cell

left alignment

Text is lined up against the left margin.


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


a group of things that come one after another in succession

context sensitive

options are related to the current task


picture element, a point of light measured in dots per square inch


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


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


a graphic representation of data in a worksheet


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


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


adjusts the width of a column to fit the cell content of the widest cell in the column


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


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


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

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


Reload the page to try again!


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