Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Module 5 Index

Absolute Reference: A cell reference that does not adjust when the formula is pasted to a new location.

Active Cell: The worksheet cell with a dark border; text or numbers you type appear in this cell and in the formula bar.

Alignment: The placement of cell data in a cell.

Auto Fill: A feature that enables you to fill in a series of numbers, dates, or other items automatically in a specified range.

Auto Sum: A feature that you can use to insert a formula that sums a range of cells automatically.

Bar Chart: Compares individual items. Categories are organized vertically, values horizontally to place more emphasis on comparing values than on time.

Cell: The intersection of a row and column.

Cell Reference: Identifies a particular cell.

Chart: Graphic representation of worksheet data.

Chart Title: Identifies the purpose of the chart.

Chart Wizard: A series of dialog boxes that lets you create a chart and customize it as you create it.

Column Chart: Shows changes in data over a period of time or illustrates comparisons among items.

Data Label: Identifies specific points or series.

Data Series: A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.

Fill Handle: The small black square on the bottom right corner of a selected cell.

Formula: A sequence of values, cell references and operators used to produce a new value from existing cells.

Formula Bar: Displays the contents of the current or active cell, located above the worksheet column headings.

Function: A predefined function in Excel.

Gridlines: Optional lines on a chart.

Insert Function: A button loacted on the formula bar that allows quick access to the Insert Function dialog box.

Legend: Key to the data represented by a chart.

Line Chart: Shows trends in data at equal intervals.

Merge and Center: To combine adjacent, or contiguous, cells into one large cell and center the data.

Operators: Addition (+), Subtraction (-), Multiplication (*), and Division (/), also the colon (:) that separates cells in a range.

Order of Precedence: The order in which excel processes operations in a formula with more than one operation.

Pie Chart: Shows the relationship of items that make up data series to the sum of the items.

Range: A colon inserted between two cell references.

Sheet Tab: A means to access the different sheets in a workbook, located at the bottom of the spreadsheet.

Spreadsheet: A table of values arranged in rows and columns.

Task Pane: Provides a quick means to execute commands. Displays when you start Excel and and enables you to create new workbooks or open and existing one.

Templates: ready-made pages format, complete with margins, fonts, headers and footers, numbering, logos or any other kind of formatting the designer wants to appear on each page.

Toolbars: A series of buttons and menus in an application, which allows the user to perform functions quickly using the mouse.

Workbook: An Excel file that contains one or more worksheets.

Worksheet: A work area comprised of rows and columns, also known as a spreadsheet.

Value: The number resulting from the execution of a formula.

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated:09/2007
© 2003, St. Edward's University