COMPUTER CONCEPTS Vocabulary

1
COMPUTER CONCEPTSVocabulary

• Chapter 3
• Document. Worksheets, and Databases

2
Document production software

• Computer programs that assist the user in
  composing, editing, designing, and printing
  documents.

3
Word wrap

• A feature of document production software that
  automatically moves the cursor to the beginning
  of the next line of text when it reaches the end
  of the current line, allowing the user to type
  continuously.

4
Outline feature

• A feature of document production software that
  helps the user develop a document as a hierarchy
  of headings and subheadings.

5
Text block

• In an online document, sections of text such as a
  group of words, sentences, or paragraphs.

6
In-line spelling checker

• A spelling checker that checks for misspellings
  as you type.

7
Search and replace

• A feature of document production software that
  allows the user to automatically locate all
  instances of a particular word or phrase and
  substitute another word or phrase for it.

8
Search feature

• A feature of document production software that
  allows the user to automatically locate all the
  instances of a particular word or phrase.

9
Spelling checker

• A feature of document production software that
  checks each word in a document against an
  electronic dictionary of correctly spelled words,
  then presents a list of alternatives for possible
  misspellings.

10
Thesaurus

• A feature of documentation software that provides
  synonyms.

11
Grammar checker

• A feature of word processing software that
  coaches the user on correct sentence structure
  and word usage.

12
Document template

• A preformatted document into which the user types
  text.

13
Document wizards

• Tools that take the user step-by-step through the
  process of entering text in a wide variety of
  documents.

14
Font

• A typeface or style of lettering, such as Arial,
  Times New Roman, and Gothic.

15
Justification

• The alignment of text against the right, left, or
  both margins.

16
Clip art

• Graphics designed to be inserted into documents,
  Web pages, and worksheets, usually available in
  CD-ROM or Web-based collections.

17
Frame

• An outline or boundary, frequently defining a
  box. For document production software, a
  predefined area into which text or graphics may
  be placed.

18
Electronic publishing

• The manipulation, storage, and transmission of
  electronic documents by means of electronic media
  or telecommunications services.

19
HTML (Hypertext Markup Language)

• A standardized format used to display Web page
  documents.

20
Concordance

• An alphabetized list of words in a document and
  the frequency with which each word appears.

21
Footer

• Text that appears in the bottom margin of each
  page of a document.

22
Header

• Text that appears in the top margin of each page
  of a document, e.g., 'Page 5".

23
Mail merge

• A feature of document production software that
  automates the process of producing customized
  documents such as letters and advertising flyers.
  

24
Spreadsheet

• A numerical model or representation of a real
  situation, presented in the form of a table.

25
Cell

• In spreadsheet terminology, the intersection of a
  column and a row in cellular communications, a
  limited geographical area surrounding a cellular
  phone tower.

26
Cell reference

• The column letter and row number that designates
  the location of a worksheet cell. For example,
  the cell reference C5 refers to a cell in column
  C, row 5.

27
Formula

• In spreadsheet terminology, a combination of
  numbers and symbols that tells the computer how
  to use the contents of cells in calculations.

28
Number

• A symbolic representation of a quantity, such as
  a value used in a calculation.

29
Text

• In spreadsheet terminology, words used for
  worksheet titles and for labels that identify
  columns and rows.

30
Worksheet

• A computerized, or electronic, spreadsheet.

31
Function

• In worksheets, a built-in formula for making a
  calculation. In programming, a section of code
  that manipulates data, but is not included in the
  main sequential execution path of a program.

32
Auditing

• In spreadsheet terminology, the process of
  testing a worksheet to make sure that it produces
  accurate results.

33
Worksheet template

• A worksheet form created by professionals and
  provided for your use by your spreadsheet
  software.

34
Absolute reference

• In a worksheet formula, cell references (usually
  preceded by a symbol) that cannot change as a
  result of a move or copy operation.

35
Relative reference

• In a worksheet, cell references that can change
  if cells change position as a result of a move or
  copy operation.

36
Workbook

• A collection of individual worksheets that are
  stored together as one file.

37
Spreadsheet modeling

• Setting up numbers in a worksheet format, to
  simulate a real-world situation.

38
What-if analysis

• The process of setting up a model in a
  spreadsheet and experimenting to see what happens
  when different values are entered.

39
Freeform database

• A loosely structured collection of information,
  usually stored as documents rather than as
  records.

40
Structured database

• A collection of related information organized
  into records and fields.

41
Data access software

• The interface used to search for information in a
  database.

42
Hypertext index

• A screen-based menu that allows the user to
  access information in specific categories by
  clicking a hypertext link.

43
Keyword search engine

• A means of accessing data about a particular
  subject, by searching for a significant word or
  keyword relevant to that subject.

44
Query by example (OBE)

• A type of database interface in which the user
  fills in a field with an example of the type of
  information that she is seeking.

45
Natural language

• A language spoken by human beings, as opposed to
  an artificially constructed language such as
  machine language.

46
Query language

• A set of command words that the user uses to
  direct the computer to create data-bases, locate
  information, sort records, and change the data in
  those records.

47
Export data

• The process by which a program transforms data
  into a format suitable for another program and
  then transmits it.

48
Import data

• The process by which a program reads and
  translates data from another source.

49
Productivity paradox

• The apparent lack of productivity increases in
  the U.S. economy, despite massive deployment of
  computers and other information technology.

50
Return to Title Page

• Prepared by James Q. Jacobs