Word, Excel, Access, Html (Study Opps)

Front 1

Absolute cell reference (Excel)

Back 1

A cell reference that will not change when the function or formula is copied. To do this, a dollar sign ($) is inserted before the column letter and/or row number.

Front 2

Append (Access)

Back 2

Add records to an existing table in a database.

Front 3

Attribute (HTML)

Back 3

A name and value combination that defines a property of an element. Some elements have multiple ones, e.g. the font size and colour of text.

Front 4

Bibliography

Back 4

A list of cited sources found at the end of a document and formatted according to a chosen style, e.g. APA or Chicago.

Front 5

Bookmark (HTML)

Back 5

A position on a web page that can be marked and stored with a specific name using HTML code. An anchor tag together with the href attribute is then used to create a link to this.

Front 6

Bookmark (Word)

Back 6

Used to mark places or specific sections of text in a document, enabling you to navigate to them quickly and easily.

Front 7

Caption (Word)

Back 7

A numbered description added to a graphic object (such as a diagram or photo) or a table.

Front 8

Chart Area (Excel)

Back 8

Includes both the Plot Area and the ‘outside’ part of a chart where the titles are located.

Front 9

Citation (Word)

Back 9

Reference to the source used in a specific instance and found in the text immediately after the piece of information being referred to.

Front 10

Column break (Word)

Back 10

Used if you want to shift text to the top of the next column.

Front 11

Combo Box (Access)

Back 11

A list of values from which a user can choose a value. Only one value is visible at a time, the others will appear only when the user clicks on the arrow. A Lookup Wizard is used to create the list of values.

Front 12

Combo chart (Excel)

Back 12

If a chart has more than one data series, a different chart type can be used for each series.

Front 13

Constant (Excel)

Back 13

An entry which has a specific fixed value, e.g. 3.5.

Front 14

Crop (Word)

Back 14

To remove parts of a picture that you do not need. You can also customize it, for example to fit a specific shape

Front 15

Cross-reference (Word)

Back 15

Used to refer to related information elsewhere in the same document. One can choose what information to display about the item referred to. A hyperlink to this item is created by default.

Front 16

CSV file

Back 16

A text file which uses commas to separate the values in each line. Commonly used to import and export data between programs.

Front 17

Data labels (Excel)

Back 17

The values of the data points on a chart.

Front 18

Data series (Excel)

Back 18

A column or row of numbers in a spreadsheet that is depicted in a chart.

Front 19

Data validation

Back 19

The application of any technique which can prevent invalid data during input of data.

Front 20

Date picker (Access)

Back 20

Control in Access that enables one to select a specific date by clicking on an on-screen calendar.

Front 21

Default value (Access)

Back 21

A value which is automatically allocated to a field in a new record.

Front 22

Delimiter

Back 22

A character such as a comma, space or tab, used to separate each piece of data (each field) in a line in a CSV file.

Front 23

Drop Cap (Word)

Back 23

An enlarged first letter or word of a paragraph, which drops into the line or lines of text below.

Front 24

En dash (Word)

Back 24

A dash that is slightly longer than a hyphen and used mostly with number intervals and for parentheses.

Front 25

Endnote (Word)

Back 25

Similar in function to a footnote, but different in that it appears at the end of a section, or at the end of the document.

Front 26

Exporting

Back 26

Saving data in a format that can be read by a different version of the same application or even a totally different application.

Front 27

Field (Access)

Back 27

A single fact or the smallest unit of data in a database.

Front 28

Filter (Access)

Back 28

A criterion or rule that you set for a field to display only those records that comply with the criterion.

Front 29

Filter (Excel)

Back 29

Feature used to display only certain rows of data in a worksheet.

Front 30

Footnote (Word)

Back 30

Additional information placed at the bottom of the page in a document, and linked by a number or symbol to the relevant text in the body of the page.

Front 31

Gap width (Excel)

Back 31

The distance between the columns or bars in a chart, expressed as a percentage of the width of the columns or bars.

Front 32

Gridlines (Excel chart)

Back 32

Lines in the plot area of a chart, which make it easier to estimate visually the values of the data points.

Front 33

Gridlines (Excel worksheet)

Back 33

Set of lines forming a rectangular grid and distinguishing the individual cells in a worksheet.

Front 34

Hard space (Word)

Back 34

A space where word wrapping cannot occur. The characters / words on either side of it will remain together on a line.

Front 35

Header / Footer

Back 35

An area within the top and bottom margins of a page, which can contain information that appears on each page of the document or section, such as page numbers, a company logo, or the file name.

Front 36

HTML

Back 36

One of the languages in which web pages are written. It is used to structure and present content on the WWW, including text, graphics, audio and video.

Front 37

Importing

Back 37

Opening or ‘reading’ data created in a different version of the same application, or even a totally different application.

Front 38

Input Mask (Access)

Back 38

A field property which can be set for a specific field in Design View. It is a code made up of a combination of letters, digits and symbols, and is used to enforce the entering of data in a specific format.

Front 39

Label (Access)

Back 39

A control containing text, mainly used for headings and captions.

Front 40

Legend (Excel)

Back 40

The ‘key’ which describes (gives the names of) the different data series in the chart, by depicting the fill colours or the patterns used.

Front 41

List Box (Access)

Back 41

A list of values from which a user can select a value but not add an additional one.

Front 42

Markers (Excel)

Back 42

Small marks (e.g. dots or crosses) used to indicate the actual data points on a line chart.

Front 43

Non-breaking hyphen (Word)

Back 43

Used to force the words or characters on both sides of the hyphen to remain on the same line.

Front 44

OLE Object (Access)

Back 44

A data type that can contain graphics, sound and video in addition to other data types.

Front 45

Page Break

Back 45

Starts text on a new page, without creating a new section.

Front 46

Plot Area (Excel)

Back 46

The ‘middle’ part of a chart where the data – the bars/columns/line – is plotted.

Front 47

Primary key (Access)

Back 47

A field that identifies each record with a unique value.

Front 48

Record (Access)

Back 48

A group of related fields that contains the particulars of a specific entity.

Front 49

Relative cell reference (Excel)

Back 49

When a formula or function is copied from one cell to another, the cell reference is automatically adjusted relative to the original cell.

Front 50

Section (Word)

Back 50

A part of a document in which the page formatting can differ from the rest of the document. It are thus used to vary the page layout on one or more pages of the same document.

Front 51

Section Break (Word)

Back 51

Separates a document or page into sections, and indicates the end of one section / start of the next section. Distinguishes sections from one another, and allows different sections to be formatted differently.

Front 52

Stack and scale (Excel)

Back 52

Where a data series in a chart is filled with pictures, and each picture is used to represent a certain number of units.

Front 53

Stacked chart (Excel)

Back 53

A type of chart where data series are placed one on top of the other – useful for comparing main categories (grand totals) and sub-categories in the same chart.

Front 54

String (text data)

Back 54

Combinations of characters (letters, digits and symbols like @) in text data. Examples are names and surnames, as well as strings of digits such as cellphone numbers and postal codes.

Front 55

Style (Word)

Back 55

A combination of formatting attributes such as font size and type, and paragraph spacing, saved as a collection under one name.

Front 56

Table of contents (Word)

Back 56

Automatically created list of headings or chapters and the pages on which they start, placed at the beginning of a document.

Front 57

Template

Back 57

A blueprint or framework for a specific type of document, with a suitable layout. It is used by filling in only the missing information.

Front 58

Track Changes (Word)

Back 58

A feature of a word processor that can be used to track or mark all the changes made to a document.

Front 59

Trendline (Excel)

Back 59

A straight or curved type of ‘best fit’ line in a chart, that shows the general trend or direction of the values of a data series – usually over time.

Front 60

Valid data

Back 60

Data where the values are acceptable in terms of permissible values, the limits within which it occurs or the format in which it is entered.

Front 61

Validation Rule (Access)

Back 61

The condition(s) that the data in a specific field must meet to be accepted as valid data.

Front 62

Validation Text (Access)

Back 62

The message that must be displayed if the data entered does not meet the condition(s) in the Validation Rule.

Front 63

Watermark (Word)

Back 63

Text or a graphic which appears very lightly as a background on all the pages in a document.

Front 64

Widow/Orphan (Word)

Back 64

A single ‘dangling’ line at the top or bottom of a page of a paragraph that splits over a page.