Name: Score:
54 Multiple choice questions
Term 1 of 54
Relative Reference
adjusts during a copy operation
- specified without dollar signs
ex: B4
an error that occurs if a formula refers to itself
remains constant throughout a copy operation
- specified with a dollar sign before the column and the row
ex: $B$4
accepts no arguments and returns a value as false
ex: =FALSE()
Term 2 of 54
TRUE Function
accepts no arguments and returns a value of true
ex: =TRUE()
accepts no arguments and returns a value as false
ex: =FALSE()
occurs when one function is embedded as an argument to another function (one function
inside another)
ex: =IF(A1<A2,MIN(B1:B5),MAX(B1:B5))
displays the current date and time
,Term 3 of 54
Semi -Selection
accepts no arguments and returns a value of true
ex: =TRUE()
uses the mouse pointer to build a formula containing cell references or ranges
enables you to highlight cells within a range that satisfy a certain condition or equal to a
particular value
returns TRUE value if ALL the arguments are true
ex: =AND(logical1, logical2,.....)
Definition 4 of 54
1. the numeric value (or cell) to look up
2. the range of the table
3. the column number containing the value you want to return
*Requires the Lookup table is in ascending order*
Nested Function
NOT Function
OR Function
VLOOKUP Function
Definition 5 of 54
the set of rules that govern correct formation of a function
Relative Reference
Syntax
Function
Conditional Formatting
, Definition 6 of 54
an individual piece of data
- names appear in as column headings
Table
Record
Worksheet
Field
Term 7 of 54
Bubble Chart
returns the mathematical sum for a number of cells or ranges
ex: SUM(A1:A3)
The contents of the active cell are displayed here
uses the mouse pointer to build a formula containing cell references or ranges
shows the relationship among three values by using bubbles
Definition 8 of 54
- a column chart that depicts totals by category instead of each individual data point
- useful when you want to compare totals by category
PMT Three Requirements
Stacked Column Charts
Structured Reference
VLOOKUP Function
54 Multiple choice questions
Term 1 of 54
Relative Reference
adjusts during a copy operation
- specified without dollar signs
ex: B4
an error that occurs if a formula refers to itself
remains constant throughout a copy operation
- specified with a dollar sign before the column and the row
ex: $B$4
accepts no arguments and returns a value as false
ex: =FALSE()
Term 2 of 54
TRUE Function
accepts no arguments and returns a value of true
ex: =TRUE()
accepts no arguments and returns a value as false
ex: =FALSE()
occurs when one function is embedded as an argument to another function (one function
inside another)
ex: =IF(A1<A2,MIN(B1:B5),MAX(B1:B5))
displays the current date and time
,Term 3 of 54
Semi -Selection
accepts no arguments and returns a value of true
ex: =TRUE()
uses the mouse pointer to build a formula containing cell references or ranges
enables you to highlight cells within a range that satisfy a certain condition or equal to a
particular value
returns TRUE value if ALL the arguments are true
ex: =AND(logical1, logical2,.....)
Definition 4 of 54
1. the numeric value (or cell) to look up
2. the range of the table
3. the column number containing the value you want to return
*Requires the Lookup table is in ascending order*
Nested Function
NOT Function
OR Function
VLOOKUP Function
Definition 5 of 54
the set of rules that govern correct formation of a function
Relative Reference
Syntax
Function
Conditional Formatting
, Definition 6 of 54
an individual piece of data
- names appear in as column headings
Table
Record
Worksheet
Field
Term 7 of 54
Bubble Chart
returns the mathematical sum for a number of cells or ranges
ex: SUM(A1:A3)
The contents of the active cell are displayed here
uses the mouse pointer to build a formula containing cell references or ranges
shows the relationship among three values by using bubbles
Definition 8 of 54
- a column chart that depicts totals by category instead of each individual data point
- useful when you want to compare totals by category
PMT Three Requirements
Stacked Column Charts
Structured Reference
VLOOKUP Function
