be sure the managers don ’ t change the formulas in the worksheet . Describes the characteristics of the worksheet . PART 2 Describe the process Mark will use in combining the completed worksheets into on workbook and creating the summary report . ( Points : 40 )
Part 1 For the case of Jacob ’ s Mini-Mart , he needs to have a way of … Part 2 For the completed worksheets to make sense to the users ….
( TCO 9 ) You are assigned to analyze a large dataset containing the detailed records of invoices of a company ’ s customers which contain the customer ID , their address , city , region , post code , country and sales person and additional information about specific order id , order date , shipped date , shipper , product ordered , unit price , quantity , discount , ship address , ship city , ship postal code , ship country , and product category name . Explain how you would use Excel and Excel formulas to analyze this data and organize it to prepare a written report . Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations . ( Points : 40 )
The use of excel for data analysis is one the best processes that data …
( TCO 1 ) You are the Payroll Manager for your employer . Your payroll clerk has submitted the worksheet displayed here . All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50 % of the hours worked in excess of 40 hours .
Part 1 : Write a formula as if it were in Cell E2 that will calculate gross pay . Write the formula so that it may be copied to the other employees without modification .
Part 2 : You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table . Write a formula as if it were in Cell F2 that calculates the income tax for the first employee . Write the formula .