Cis Chapter 7

Front 1

Audit

Back 1

An Excel feature that enables you to check the accuracy of the formulas by reviewing the structure and behavior of the formulas in your worksheet.

Front 2

AutoRepublish

Back 2

Automatically updates and republishes the Web page whenever the workbook is saved.

Front 3

Comment

Back 3

A text box that is attached to a specific cell in which the user adds an explanation or question about the contents of the cell.

Front 4

Dependent cell

Back 4

A cell that uses the value of the active cell in its formula.

Front 5

Discussion server

Back 5

Computer that allows participants in a Web discussion to make comments about a Web document and have the comments appear as if part of the document.

Front 6

Error indicator

Back 6

A green triangle in the upper-left corner of a worksheet cell that indicates that an error or potential error in the formula of a cell exists.

Front 7

Error value

Back 7

An indication that a type of error has been found begins with a number sign followed by an error name.

Front 8

Extensible Markup Language (XML)

Back 8

A programming language in which data can be placed in text files in a structured way that can be read by a wide variety of applications.

Front 9

Hyperlink

Back 9

A reference from some point in one hypertext document to some point in another document or another place in the same document.

Front 10

Hypertext document

Back 10

Text on a Web page that connects to documents on the World Wide Web.

Front 11

Hypertext Markup Language (HTML)

Back 11

A language that supports the online display of textual and graphical information that includes hypertext links.

Front 12

Interactive Web Page

Back 12

An interactive workbook, which can be viewed on a web browser and has a special spreadsheet component, that enables you to switch between worksheets, enter or edit data, format values, and change formulas on the Web page.

Front 13

Link

Back 13

A connection between two files allowing information to be transferred from one file to another.

Front 14

Noninteractive Web page

Back 14

An Excel workbook, published as a Web page, through which users can scroll and switch between worksheets, but to which they cannot make any data or formatting changes.

Front 15

Precedent cell

Back 15

A cell that is referred to and provides the values used in the formula of an active cell.

Front 16

Routing

Back 16

Using the Routing Recipient command on the Send To submenu, to send a workbook as an e-mail attachment along with a list or recipients to review workbook.

Front 17

ScreenTip

Back 17

A yellow box that appears when you position the mouse pointer over a toolbar button. The yellow box displays the button’s name.

Front 18

Spreadsheet component

Back 18

An interactive workbook on a Web page.

Front 19

Tracer arrow

Back 19

An arrow that shows the relationship between the active cell and its related cells; blue if pointing to a cell that provides data to another cell, and red if the cell contains an error value.

Front 20

Tracking log

Back 20

Worksheet where changes to a shared workbook are displayed and erroneously rejected changed can be retrieved.

Front 21

Web browser

Back 21

A software program that retrieves a hypertext file from the Web server and then displays the document on the user’s computer.

Front 22

Web page

Back 22

An electronic document, created using HTML that contains links to other electronic documents.

Front 23

Web server

Back 23

A computer that stores and delivers Web pages to the computer’s browser that requested the web page

Front 24

Web site

Back 24

A collection of Web pages.