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 […]
Look on Project 4B on page 54 for help “Writing a Formula with Nested IF Conditions”. Here is how the “nested IF” begins: IF(E4>99999,”10% This assignment will not be printed, rather graded on your computer.
This assignment will not be printed, rather graded on your computer.
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.
HINT: When calculating the percentages in the C4 “If statement” be sure and key the percentage as a decimal. This assignment will not be printed, rather graded on your computer.
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 […]
Instruction #6 on p. 143, Assessment 2, states: Specify the column row titles (A3 through A22) are to print on each page. HINT: 1. Goto the Page Layout Tab 2. Click on the Print Titles Icon 3. Set the Columns To Repeat at Left to A3:A22
Midterm Assessment: #2 Page: #104 Filename: YourLastname_L1_C3_A2_p.104.xsl What does a “DATE” function look like? EXAMPLE: =DATE(2011,4,10)
Remember to type on the spreadsheet: -Your Name -Your Class Period -The Day (Odd/Even) -Remember to Display Formulas before printing. (Control + ~) -See page 55 Project 4C for help with the IF Formula. Your spreadsheet should look something like this:
Example from – p.54 4B =IF(E16>89,”A”,IF(E16>79,”B”,IF(E16>69,”C”,IF(E16>59,”D”)))) Hint for – p.63 Assessment #4 C4 =IF(B4>X, “Platinum”,IF(B4>100000,”X“, IF(B4>75000,”X“,IF(B4>X, “X“)))) D4 =IF(C4=”Bronze”,”None”,IF(C4=”X“,3000,IF(C4=”X“,X,IF(X=”X“,X
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 […]
