Chapter 9 - Multiple-Sheet Workbook Management Flashcards

1
Q

Occurs when a** formula or function violates construction rules**

A

Syntax Error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Electronc link that, when click, goes to another location in the same or diffrerent worksheet, opens another file, web page in a web browser, or email client and inserts an email add. into the To box.

A

Hyperlink

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Condition that dictate the type of data that can be entered in a cell.

A

Validation Criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Condition that dictate the type of data can be entered in a cell.

A

Validation Criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Area that displays the workbook name, worksheet name, cell addresses, values and formulas so you can monitor and examine formula calculations involving cellls not immidiately visible on the screen.

A

Watch Window

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A file that contains link to retrieve data from a source file.

A

Destination File

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Rules that must be followed to allow to be entered in a cell.

A

Data Validation Rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Tools that enables you to detect and correct errors in formulas by indentifying the relationship of the cells.

A

Formula Auditing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A colored line that shows relationship between precedent and dependent cells

A

Tracer Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Process of creating external references from worksheets in one workbook to cells on a worksheet in another workbook.

A

Linking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Process of selecting 2 or more worksheet so that you can perform the same action at the same time on all selected worksheets.

A

Grouping

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A cell in a worksheet prevents a user from entering dat aif the worksheet is protected.

A

Locked cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Happens when formula contains a direct or indirect cell reference to the cell containing the formula

A

Circular reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Vertical or horizontal lines that frames panes in a worksheet and enables the user to resize panes.

A

Split bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A cell containing a formula that relies on other cells to obtain its value.

A

Dependent cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Occurs when a formula uses incorrect cell references or incorrect operator that produces inaccurate result.

A

Logic error

17
Q

A reference within a formula or fuction on 1 worksheet that includes name of another worksheet, column letter, and row number located in a workbook.

A

3D Reference

18
Q

A file that contains original data that you want to use in another file.

A

Source file

19
Q

Cell that is referenced by a formula in another cell.

A

Precedent cell

20
Q

A message that displays when the user enters invalid data in a cell containing validation rule

A

Error alert

21
Q

Descriptive text or instruction that inform a user about the restrictions for entering data in a cel..

A

Input message