I have an excel project that needs to be complete. You will use Microsoft Excel 2010 to create a new workbook. This will be a fairly simple assignment for someone who is familiar with excel.

This is the assignment. Please let me know if you are still interested. Using Microsoft Excel 2010, create a new workbook that will be used to record the jobs performed and charges generated by a landscaping company. In the first worksheet, create columns for the employees of your landscaping business. Required fields for this worksheet include the following and you may add other fields if you wish: Employee_ID, First_Name, Last_Name, and Hourly_Wage You will add at least 10 records of your creation to populate this data. Sort in ascending order on Last_Name. Create a second worksheet that will hold the fields to maintain a client list. Required fields for this table include the following and you may add other fields if you wish: Client_ID, Client_Name, Client_ZipCode, HourlyBilling_rate (format currency with 2 decimal places) You will add at least 10 records of your creation to populate this data. All values are fictional. Sort in ascending order by Client_ID. Create a third worksheet to record jobs performed. Required fields for this table include the following and you may add other fields if you wish: Job_ID, Date, Client_ID, Hours_Worked, Employee_ID, Cost, Bill_Amount, Discount (format Cost, Bill_Amount, and Discount as Currency, 2 decimal places) You will add at least 20 records of your creation to populate this data. All values are fictional. The Employee_ID and Client_ID of each record in the Jobs worksheet must match a record in the respective Employees and Clients worksheets. Cost is a calculated field that must include a VLOOKUP function linked to the Employee worksheet Hourly_Wage field and multiplied by the Hours_Worked field. Bill_Amount is a calculated field that must include a VLOOKUP function linked to the Client worksheet and also multiplied by the Hours_Worked field. Discount is a calculated field with an IF statement that will show if the Bill_Amount minus Cost is greater than $100, then the discount is 10% of the Bill_Amount.
User_624 | Mar 19, 2013, 02:54 AM

---

I get it am using Microsoft Excel 2007 will it be compatible?
tutor4U_d_971 | Mar 19, 2013, 03:00 AM

---

I do not know.
User_624 | Mar 19, 2013, 03:02 AM

---

I think they have the same features. assign it.
tutor4U_d_971 | Mar 19, 2013, 03:03 AM

---