Review Sheet for Final Exam, on Tuesday, 12/10 at 6PM:
LOOK OVER LAST
Possible subjects on the Math 3550 Midterm
Absolute vs. Relative references in Excel formulas (using the $-sign, "anchoring").
Know how a formula would change if copied down/over.
(R1C1
Final Exam Review Sheet for VBA:
Know what it means to declare a variable
What is public? What is dim?
How do functions differ from sub's?
Understanding variable types:
Variable types to review:
Integer
integer values from -32,000 to +32,000
Long
a larger
1) Some additional table basics Field Selection:
Complex field types can be added in the "Design View" menu.
In design view, type in a field name and select
field type. In the properties window, specify the
additional criteria for the added field.
Standar
Financial Functions
Financial functions:
1) PV, FV, PMT, RATE, NPER, IRR, NPV.
2) Using nested PV's to calculate deferred payment patterns.
3) Using the IRR formula on positive-negative-positive payment patterns.
4) Cash flows that include a separate rate
Formula Editor tip: When entering in formulas, it's a good idea to enter them in lowercase.
If a formula is recognized in the formula library it is auto-converted to all uppercase,
so you know when you type in your formula incorrectly.
Functions we'll cov
Formatting Tips
Basic skills on how to make professional-looking spreadsheets 1) Use the CTRL + 1 (format cells) shortcut.
2) Make sure you pick the appropriate number of digits and formats.
Sometimes the message can be lost in too much detail or too many
3/3/2015 - Data Evaluation Addtl Features/Functions
Data Evaluation Features:
1) Pivot Tables - quickly summarizes data.
2) Conditional Formatting - will highlight/format cells based on specific conditions.
Additional functions, useful in work with large
Assignment for importing tables and doing simple queries
Step 1:
Import the next 3 tabs into Access.
Top1000 - this is a critic's list of the all-time top 1000 movies.
Top250_IMDB - this is a list of the top 250 IMDB movies with the highest ranking.
Top10
RawData Tab:
You've received a data file and paste it into the tab "RawData".
The file is of the following format:
Characters #1 - 5 = Claim number
Characters #6 - 10 = DOS (date of service)
Characters #11 - 22 =Amount Paid ($'s)
Characters #23 - 28 = MOS
1) Access Ribbon Review: Review the Access menu to show what options are available.
(10 minutes)
2) Access - what is it for?
Excel-based examples of where Access is a better fit.
i) Access allows for linking of large tables that share some common fields.
Find Unmatched Query:
When linking two tables, the default method of linking is an INNER join.
INNER join:
An INNER JOIN links two tables together by a common field.
Only records where the field has a match in both tables will appear.
Table A
Name_A
Gende
Review Sheet for Exam on THURSDAY, 3/12/2015:
Possible subjects on the Math 3550 Midterm
Absolute vs. Relative references in Excel formulas (using the $-sign, "anchoring").
Know how a formula would change if copied down/over.
Goal Seek - What is a goal se
Instructions:
1) Set the Print Area to include A2:G130.
2) Set up Print Header and Footer as follows:
Header: Period Life Table, 2007
Footer:
SOA Experience Study; Page ? of ? (ex. "Page 1 of 3")
3 a) Set up the file to fit to 1 page wide (multiple pages)
1) Access Ribbon Review: Review the Access menu to show what options are available.
2) Access - what is it for?
Excel-based examples of where Access is a better fit.
i) Access allows for linking of large tables that share some common fields.
ii) Access ha
For the questions below, assume all interest rates are compounded, not notional.
In other words, Annual rate = (1+ Monthly rate) ^ 12.
Question #1:
Using the PMT function, calculate the monthly payment required for a 36-month,
$15,000 loan, paid at a 15%
Background:
A common task for actuaries in all fields is the calculation of reserves.
Reserves are the amounts a company owes for their current obligations.
If a company sells insurance, at any point in time, if they were to stop
operating, they would sti
1) Some additional table basics Field Selection:
Complex field types can be added in the "Design View" menu.
In design view, type in a field name and select
field type. In the properties window, specify the
additional criteria for the added field.
Standar
Question:
If you wanted a query that adds records without overwriting existing records, what type of query
would you use?
Answers:
A.
Group
B.
Select
C.
5
6
7
8
9
10
11
Append
D.
Crosstab
E.
Removal
C.
Current Question Type: Access
Current Question Number