I don’t understand this Excel question and need help to study.
Instructions
- Complete the above worksheet
- Bold the heading 14pt.
- Fill column headings with white background 1, darker 15%
- Complete the worksheet by putting in a formula to calculate regular, overtime=Time and half (overtime hours X overtime rate), and gross pay
- Use accounting format for columns D, E, F and G.
- Add a total for overtime and gross pay
- Calculate the average and Highest pay below the worksheet in Column A and B
- Use data source to add clustered column chart below worksheet with Black Text fill.
- Name the Chart “Quest Travel Payroll”
- Add a border around the Chart Blue 6”
- Save and upload the document.
