Unit 4 Spreadsheet Application

Formula Bar

A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts; displays the constant value or formula stored in the active cell

Cell

A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.

Legend

A box that identifies the patterns or colors that are assigned to the data series or categories in a chart

Function Formula

A built formula that automatically performs calculations for specified range of data

Column Chart

A chart representing comparative periods of fluctuation or the comparative size, length, value, or endurance of a group of things by means of juxtaposed proportional columns

Embedded Chart

A chart that is added to an active worksheet

Bar Chart

A chart with rectangular bar with lengths proportional to the values they represent. The bars can be plotted vertically or horizontally. A vertical bar chart sometimes called column bar chart

Clip Art

A collection of pictures or images that can be imported into a document

Spreadsheet Program

A common computer application (Excel) which allows users to solve mathematical calculations

Chart

A graphical representation of data, in which the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart

Spreadsheet

A grid of rows and columns in which you enter text, numbers, and the results of calculations

Landscape Orientation

A page layout in which documents are printed across the length of the page, making it wider than tall

Portrait Orientation

A page layout in which documents are printed across the width of the page, making it taller than wide

Textbox

A rectangular object on a worksheet or chart in which you can type text

Formula

A sequence of values, cell references, names, function, or operations in a cell that together produce a new value. A formula always begins with an equal sign (=)

Workbook

A spreadsheet program file that you create on Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.

Line Chart

A type of graph that highlights trends by drawing connecting lines between data points

Sum Function Formula

Adds all the numbers that you specify as arguments. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function

Row

Appears horizontally and is identified by numbers on the left side of the worksheet window

Column

Appears vertically and is identified by letters at the top of the worksheet view

Sorting

Arranging data in a specified order

AutoFill

Automatically fill in cells with common series (numbers, moths, and days of the week)

Filter

Displays only the rows in a list that satisfy the condition you specify. You use the auto filter command to display rows that match one or more specific values, calculated values, or conditions

Header

Headers are lines of text that print at the top of each page in the spreadsheet

Cell Reference Box

Identifies the active cell by the letter of the column and the number of the row that it intersects. The cell reference box also identifies the range of cells being selected

Pie Chart

Is a circular statistical graphic, which is divided into sectors to illustrate numerical proportion. In a pie chart, the arc length of each sector is proportional to the quantity it represents.

Average Function Formula

Receives a range of cells, and returns the average of all the numbers that appear in that range (the sum of all the cells divided by the number of cells)

Maximum Function Formula

Returns the largest value in a set of value in a set of values

Minimum Function Formula

Returns the smallest number in a set of values

Scroll Bars

The scroll bar contains a slider that can be used to click and drag to scroll through the window

Title Bar

The section at the top of a window that contains the name or description of the window

Active Cell

The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border

Cell Reference

The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.

Fill Handle

The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross

Range

Two or more cells on a sheet; a group of selected cells