I need assistance with the green and grey areas in the excel document attached. ATTACHMENT PREVIEW Download attachment 11 pages Excel Homework.xlsx Number Formatting Time: 13:39 ==> The colon tells Excel that this is time (13 hours, 39 minutes) What is actually there is a proportion of one day Date: 10/25/2005 ==> the slashes tell Excel that this is a date (Oct. 25, 2005) Accounting: $ 10.00 Currency: $10.00 Percentage: 3.00% Nothing. Type in: 768 Positive numbers = Rad. Type in: 768 What is there is the number of days since December 31st 1899 What is actually there is 10 What is actually there is 10 What is actually there is .03 What is actually there is 768 What is actually there is 768 Accounting Currency Percentage Date (Type Date in cell using forward slash) Time (Type time using colon and AM/PM) Date (Type in as integer and then format) Time (Type in as a proportion and then format) Date Math Apply General Number Format = Ctrl + Shift + ~ Today’s Date = Ctrl + ; Later Date – Earlier Date = Diff Between 2 dates Invoice Due Date Today Day’s Late Time Math Time IN Time OUT Time worked Wage Earnings Later Time – Earlier Time = Diff between 2 times Dates show the number of days since December 31st 1899, where December 31st 1899 is day zero (0), January 1st, 1900 is day one (1), January 2nd, 1990 is day two (2), etc. Bonus Amount Bonus Hurdle $500.00 $50,000.00 Your Sales Do You Get Bonus? Your Bonus $65,000.00 Debit Credit Numbers Numbers $58 $58 $30 $30 $43 $43 $21 $21 In Balance? $152 $152 Logical Formula or logical_test Employee Sales Rod Barbaria Elinore Cromedy Twanda Spruce Darius Raffety Frida Vickerson $20,382 $19,504 $21,579 $12,117 $26,081 Bonus Hurdle $20,000 Bonus Amount If Hurdle Equaled or Passed $750 IF used to put 1 IF used to put 1 of 2 of 2 words in cell numbers in cell Bonus: TRUE or FALSE Bonus: "Yes" or "No" Bonus Amount Product Region SalesRep Customer Units 1/26/11 Bellen West Pham 1/10/11 Bellen MidWest Gault FRED FM COGS 7 $70.00 Sales $154.00 61 $610.00 $1,342.00 6 $48.00 $114.00 Sales Category 0 <= Sales < 100 100 <= Sales < 500 1/3/11 Sunshine South Sioux DDH 500 <= Sales < 750 1/7/11 Sunset West Pham T 61 $564.25 $1,281.00 750 <= Sales < 1000 1/18/11 Sunshine West 1/20/11 Carlota East 1/2/11 Bellen West Sioux Chin Pham AST ET SFWK 8 $64.00 $152.00 59 $649.00 $1,357.00 19 $190.00 $418.00 Sales >= 1000 Category Lower Limit $0.00 $100.00 $500.00 $750.00 $1,000.00 Sales Category 0 100 Subpar OK Good Great Exceptional 100 500 500 750 750 1000 Lookup Table Date Math Categories to help understand VLOOKUP 1000 $114.00 Product Price Product1 $19.00 Product2 $18.00 Product3 $17.00 Product4 $15.00 Product5 $24.00 Product Price Income Tax $0 $0.00 $1,000 $25.00 $2,000 $60.00 $5,000 $120.00 $10,000 $175.00 Income Tax Click on this link to see more about the VLOOKUP function: Highline Excel Class 07: VLOOKUP function formula 7 Examples Format the numbers in Column C, Rows 14-24 to the same format listed in Column A Type Currency Percentage Short Date Long Date Accounting Phone Number Time Fraction Unformatted 1200 0.231 2/3/2008 2/3/2008 123439832 5559832 0.552 0.25 Formatted $1,200.00 23.1% 2/3/2008 Sunday, February 03, 2008 Time and Date Math Date Math Invoice Days Due Today Due Date 123,439,832.00 555-9832 1:14:53 PM 1/4 Find the Due Date for an Invoice that is dated toady and due in 22 days Time Math Currency Percentage Short Date Long Date Accounting Accounting Accounting with $ Accounting with $ Phone Number Social Security Number Time Fraction Text 455.35 0.1523 11/4/2012 11/4/2012 55669952 8856 23.53 665578 5551234 555112222 0.542 0.5 1234567 Time IN Time OUT Time worked Wage Earnings Find the earnings for a time sheet that shows a time in of 8:10 AM and time out of 5:30 PM Challenge: What if the employee was out to lunch from 12:00PM to 12:45 PM? 1) Using a formula for this column, assign a sales category to each employee. Employee Sales Felipe Tr