Question: Please help me with step by instructions using an Excel worksheet and the screenshots of them.Thank Yoou COMPUTER EXERCISES 8 As a professional at a
Please help me with step by instructions using an Excel worksheet and the screenshots of them.Thank Yoou
COMPUTER EXERCISES 8 As a professional at a consulting firm, you would like to set up a workbook to keep track of your hours. You have three current clients (Arco, Beta, and Carlisle) that you bill by the hour. In addition you spend non-billable time cultivating new clients and non-billable time at work on other tasks, such as attending internal meetings. Set up a workbook to help you keep track of your time and biling. Each worksheet should represent a different week. There should be five rows: one for each different client, one for time cultivating new clients, one for other non-billable time. You should have columns for each of the seven days of the week. Entries will be filled in for the number of hours spent each day in each of the categories. There should be row totals for the number of hours spent in each category and column totals for the number of billable hours, the number of non-billable hours, and the total number of hours you worked each day. WORKBOOKS WITH MULTIPLE WORKSHEETS I 157 You bill all your clients at $350 per hour. This value should be entered into a separate cell in the worksheet, because it is subject to change. You should have cells for the dollar amounts to be billed each client each day and for the week. The final cell should give the total amount to be billed for the week. Your firm bills its clients every four weeks. You should have as workbook for each week in the cycle. Each of these worksheets should have the week number. After these weekly worksheets you should have a Totals worksheet that lists all useful totals, including the total accumulated hours for the cycle for each category, the total amount to be billed each client for the cycle, and the total amount billed for the cycle
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
