HINTS: #2. =SUM(Hourly Wage*Hours)+(Hourly Wage*Overtime*$Overtime$Rate) #6. Highlight A3-A17 before applying a Sort Filter #7. -Page Layout Tab -Scale To Fit Menu – Margins Tab -Center on Page -CHECK “Horizontally” -CHECK “Vertically” Don’t Forget to add the appropriate footer with: Name, Page #, and Assignment #. Look at your assignment in Print Preview, ensure that it looks […]
HINT: Don’t forget to divide the interest rate by 12. Why? If you were paying an annual interest rate of 10% you would need to divide that interest rate by 12 in order to find out the monthly interest rate. In this case: (.10/12) Fit the assignment to one page, apply the appropriate footer, print and submit assignment.
In Part 2 on Page 146 You are asked to: Insert in cell C6 a formula that calcualtes the future value of an investment. TIP: Here is that formula for cell C6: =FV($C$5,B6,-$D$3) You will printing two documents for this assignment. 1. With a contribution of $2000 2. With a contribution of $3000 PRINT: Scale […]
Case Study Part 1 asks to “In column G, insert a formula using the PMT function (enter the Pv as a negative).” TIP 1: Don’t forget to enter the Pv as a negative. Why a negative? Because that is the amount to BORROW. TIP 2: When entering the interest rate (E7), make sure and divide […]
Microsoft Excel 2007 Level 1 & 2 Rutkosky, Seguin, Rutkosky 2008 by Paradigm Publishing, Inc Chapter 1 Pages 7-36 • Identify the various elements of an Excel Workbook • Create, Save, and print a workbook • Enter data in a workbook • Edit data in a workbook • Insert a formula using the Sum button […]