Could someone help me please, I dont know how to do any of this :(
The four spreadsheets displayed on the last page are all worksheets in a single workbook. You are using this workbook to keep track of labor costs for your small construction company. In this exercise you will be calculating each person's yearly compensation and vacation based on the following data: The worksheet named wages lists the hourly wages of each of the different craft skills. Each craft-skill is uniquely identified by a job code. . . The benefit costs in dollars per month are determined based on the hourly wage. The spreadsheet named benefits lists the monthly benefit that corresponds to a specific range of hourly wages. For example: wages of less than $25 per hour have a $416 per month benefit paid, and wages between $25 and $29.99 per hour have a benefit of $624 per month benefit paid. The length of paid vacation (in weeks) is given in sheet vacation. The vacation length is based on the employment length. The spreadsheet named summary lists the name of each employee, the number of years they have been employed and to which craft skill they belong. The cell summary!B1 has been named hours and contains the number of hours per year each . employee is paid. Write an Excel formula in cell summary!D3, which can be copied down the column, to calculate the hourly wage for this person. Write an Excel formula in cell summary!E3, which can be copied down the column, to determine the total value of the benefits per year for this person. Note that the figures given in sheet benefits are per month. 3. Write an Excel formula in cell summary!F3, which can be copied down the column, to determine the total yearly value of the compensation including wages and benefits for this on. Use the named range previously entered into the worksheet (see problem pers description) to represent the number of hours per year each employee works