Excel Chapter 1

63 terms by olougb10 

Create a new folder

Advertisement Upgrade to remove ads

Go! with Microsoft Excel 2010 Comprehensive

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

spreadsheet

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

column

a vertical group of cells in a worksheet

column heading

a column letter above the grid that identifies each column

row

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

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

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