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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller stuuviaa. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
