Spreadsheet Applications.
Line chart
A type of graph that highlights trends by drawing connecting lines between data points.
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 a 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 bars with lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a 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 more 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, functions, or operators 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 in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.
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 window.
sorting
arranging data in a specified order.
AutoFill:
automatically fills in cells with common series like numbers, months, and days of the week.
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 or the sum of all the cells divided by the number of cells.
maximum function formula
returns the largest 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 with 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.
filter
to display only the rows in a list that satisfy the conditions you specify. You use the auto filter command to display rows that match one or more specific values, calculated values, or conditions.
range
two or more cells on a sheet; a group of selected cells.
