FALL MATERIALS


EXCEL TERMS

Definitions will match those provided in the hand-outs.  Review all key terms for lessons 1, 2, 3 and 5.  Here's the lists.

Key Terms:        Lesson One         Lesson Two         Lesson Three      Lesson Four   

       Lesson Five             Lesson Six         Lesson Seven         Lesson Eight  

Quilt: Make Studying Vocabulary Fun

How Excel Converts Dates To Numbers

Chase’s Quizlet For Excel Vocab!!!



FINANCIAL FUNCTIONS

(Don't be concerned about the difference in the title above the annotated answers.) 

Practice Financial Functions Practice Test #A1

Practice Financial Functions Test #A1 Annotated Answers

Practice Financial Functions Test #A1 Answers PDF Format


Practice Financial Functions Practice Test #A2

Practice Financial Functions Test #A2 Annotated Answers

Practice Financial Functions Test #A2 Answers PDF Format


Practice Financial Functions Practice Test #A3

Practice Financial Functions Test #A3 Annotated Answers

Practice Financial Functions Test #A3 Answers PDF Format


Practice Financial Functions Practice Test #A4

Practice Financial Functions Test #A4 Annotated Answers

Practice Financial Functions Test #A4 Answers PDF Format


Practice Financial Functions Practice Test #A5

Practice Financial Functions Test #A5 Annotated Answers

Practice Financial Functions Test #A5 Answers PDF Format


Practice Financial Functions Practice Test #A6

Practice Financial Functions Test #A6 Annotated Answers

Practice Financial Functions Test #A6 Answers PDF Format


Practice Financial Functions Practice Test #A7

Practice Financial Functions Test #A7 Annotated Answers

Practice Financial Functions Test #A7 Answers PDF Format



Identification of present value (PV), future value (FV), payment (PMT), rate, and number of periods (Nper).  Here's anexample of how a strong student would  use color coding of the worksheets to help match the prompts in the question with their correct interpretation. 

Financial Function Color Coded Prompt Identification Example

NEW & IMPROVED FOR 2014!!!

Financial Function Annotation Guide


© Andrew Nelson 2012