Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

15 Cards in this Set

  • Front
  • Back

What do Data Delivery Functions do?

List some examples

Verify/search/transofrm/deliver data from one point to another

Ex. Filter Unique Values

Data Validation & Drop-Down Menus

Lookup Functions

Define a lookup table, compare values and a lookup value

A table that organizes data you want to retrieve into different categories

The categories for the lookup table

The value you are trying to find

What are the functions for VLOOKUP and HLOOKUP



What are examples of simple functions?





What are examples of range functions?

=COUNT - cells that have numbers
=COUNTA - counts cells that are numeric and text


=COUNTIF - cells within a range that meets the condition

What are the phases in Problem-Solving & Modeling Process?

Define them

Formulation - Transformation of a real problem scenario into a mathematical model

Solution - Solving the model to obtain the optimal solution

Interpretation - Analyzing results and implementing solution

What is a model and what does a valid model do?

A simplified version of the thing they represent. A valid model represents the relevant characteristics of the object or decision being studied

What are the types of models? Name an example of each

Mental - Arranging furniture

Visual - Map

Physical/Scale - buildings

Mathematical - financial analysis

Define a computer model and what is the most convenient way to do business for people who build them?

A set of mathematical relationships and logical assumptions implemented in a computer as an abstract representation of a real-world or phenomenon


What are the benefits of the modeling approach?

Economy: Less costly to use models

Timeliness: Deliver more quickly

Feasibility: Understanding impossible outcomes

Gives us insight & understanding that improves decision making

Define annuity (finance theory), general annuity and how does it work?

Any terminating stream of fixed payments over a specified period of time

A series of constant cash payments made over a continuous period

Cash paid out = negative

Cash received = positive

What are the syntax


Rate - Interest rate per period

Nper(10)- Total number of payment periods annualy

Pmt - Payment made each period (cannot change over the life of the annuity)

What's incredibly important when using rate, nper, and pmt arguments?

Checking that the arguments are expressed in equal terms

Not using the delete key when deleting a row/column

What are the5 arguments of the Payment function?

1. rate - Interest rate charged by a lender

2. nper - Number of payments or period of time

3. pv (present value) - The amount of money being borrowed or the principal of the loan (must be negative)

4. fv (future value) - Part of loan paid off with periodic payments and balance of loan is paid off in one lump sum at a future p.i.t

5. [type] - either a 1 or 0. It determines if payments are made at the beginning (1) or end of a period (0)

What is the objective of the Financial Model?

Familiarize you with:

- Modeling approach to problem-solving

- Formulas and functions

- Using relative & absolute cell references

- Using FV function to consolidate simpler arithmetic functions