ICT Unit 4 Vocabulary

Active Cell

Active Cell -To make a chart sheet or worksheet the active, or selected, sheet. The sheet that you activate determines which tabs are displayed. To activate a sheet, click the tab for the sheet in the workbook. active cell. The selected cell in which data is entered when you begin typing.

Auto Fill

Auto fill is a function in some computer applications or programs, typically those containing forms, which fills in a field automatically. Most of the time, such as in Internet Explorer and Google Toolbar, the entries depend on the form field's name, so as to not enter street names in a last name field or vice versa.

Average Function formula

Average Function formula - Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE (A1:A20) returns the average of those numbers.

Bar Chart

Bar Chart - another term for bar graph.

Cell

Cell - Spreadsheets are made up of rows and columns, which form a table or grid. A cell is a specific location within a spreadsheet and is defined by the intersection of a row and column. Since most spreadsheets use numbers to define rows and letters to define columns, cells are often referenced by a letter and number combination.

Cell Reference

Cell Reference - A string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference. A cell reference may be absolute (denoted by a "$" prefix in Excel ) or relative (no prefix) in each dimension, thus, e.g. B$6 refers to the second cell across in the sixth row. The distinction between absolute and relative is only significant when the referring cell is copied, e.g. if cell A1, which refers to B$6, is copied to cell B1, then B1 will refer to C6 If the reference is to a cell in a different sheet then it is prefixed with the target sheet's name and an exclamation mark.

Cell Reference Box

Cell Reference Box - A string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference. A cell reference may be absolute (denoted by a "$" prefix in Excel ) or relative (no prefix) in each dimension, thus, e.g. B$6 refers to the second cell across in the sixth row

Chart

Chart - a sheet of information in the form of a table, graph, or diagram.

Clip art

Clip Art - simple pictures and symbols made available for computer users to add to their documents.

Column

Column - a vertical division of a page or text.

Column Chart

Column Chart - A vertical bar chart is sometimes called a column bar chart. A bar graph is a chart that uses either horizontal or vertical bars to show comparisons among categories. One axis of the chart shows the specific categories being compared, and the other axis represents a discrete value.

Embedded Chart

Embedded Chart - Embedded charts display graphs on the same worksheet as the data, and both are stored in the same location. One benefit of an embedded chart is that you can update it rather than creating a new one from scratch. To create an embedded chart, open your data, highlight the cells and select one of the chart options from the "Insert" tab of the Excel Ribbon. To make changes to an existing chart, open the "Design," "Layout" or "Format" tab on the Ribbon.

Fill handle

Fill Handle - In Microsoft Excel, fill handle is a command that lets you fill data in to your spreadsheet cells, that is based on a pattern you establish. For example, you can use this command to continue a series of numbers, text combinations, or dates.

Filter

Filter - a porous device for removing impurities or solid particles from a liquid or gas passed through it

Formula

Formula - a fixed form of words, especially one used in particular contexts or as a conventional usage.

Formula Bar

Formula Bar - A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Function

Function - work or operate in a proper or particular way

Header

Header - a line or block of text appearing at the top of each page of a book or document. the part of an e-mail before the message, containing information such as the subject and sender.

Landscape Orientation

Landscape Orientation - In word processing and desktop publishing, the terms portrait and landscape refer to whether the document is oriented vertically or horizontally. A page with landscape orientation is wider than it is tall. Not all printers are capable of generating text in landscape mode

Legend

Legend - the wording on a map or diagram explaining the symbols used/ ME

Line chart

Line Chart - A line chart or line graph is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments. It is a basic type of chart common in many fields.

Maximum Function Formula

Maximum Function Formula - In SQL, MAX is a clause to determine maximum value of the select statement. The MAX function returns the maximum value of an expression.

Minimum Function Formula

Minimum Function Formula - The MIN function is used to find the smallest or minimum value in a range of data.

Pie Chart

Pie Chart - a type of graph in which a circle is divided into sectors that each represent a proportion of the whole.

Portrait Orientation

Portrait Orientation - The terms portrait and landscape refer to different orientations of the paper -- whether it is oriented vertically or horizontally. A page with portrait orientation, typical for letters, memos, and other text documents, is taller than it is wide. Not all printers are capable of generating text in landscape mode.

Range

Range - the direction or position in which something lies

Row

Row - a number of people or things in a more or less straight line.

Scroll bars

Scroll Bars - a long thin section at the edge of a computer display by which material can be scrolled using a mouse.

Sorting

Sorting - arrange systematically in groups; separate according to type, class, etc."she sorted out the clothes, some to be kept, some to be thrown away"

Spreadsheet

Spreadsheet - an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.

Spreadsheet Program

Spreadsheet Program - A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns.

Sum Function Formula

Sum Function Formula - A function is a preset formula in Excel and Google Spreadsheets.

Text Box

Textbox - Computer Definition. An on-screen rectangular frame into which you type text. Text boxes are used to add text in a drawing or paint program. The flexibility of the text box is determined by the software. Sometimes you can keep on typing and the box expands to meet your input.