Start Excel. Download \u00a0\u00a0and open the file named Exp19_Excel_AppCapstone_ComprehensiveAssessment- Manufacturing.xlsx. Grader has \u00a0\u00a0automatically added your last name to the beginning of the filename.\u00a0<\/p>\n
Group all the \u00a0\u00a0worksheets in the workbook and fill the range A1:F1 from the Insurance \u00a0\u00a0worksheet across all worksheets including the formatting. Ungroup the \u00a0\u00a0worksheets after the fill is complete and ensure the Insurance worksheet is \u00a0\u00a0active.<\/p>\n
Click cell I5, and \u00a0\u00a0enter a function that determines the number of full-time employees, (FT).<\/p>\n
Enter a database \u00a0\u00a0function in cell I6 that determines the average salary of all full-time \u00a0\u00a0employees with at least one dependent. Format the results in Accounting \u00a0\u00a0Number Format.<\/p>\n
Enter a lookup \u00a0\u00a0function in cell E5 that returns the tax deduction amount for the number of \u00a0\u00a0dependents listed in the cell C5. Use the table in range \u00a0\u00a0H13:I17 to complete the function. The maximum deduction is $500.00; \u00a0\u00a0therefore, employees with more than four dependents will receive no \u00a0\u00a0additional deductions.<\/p>\n
Use Auto Fill to copy \u00a0\u00a0the function down, completing column E. Be sure to use the appropriate cell \u00a0\u00a0referencing. Format the data in column E with the Accounting Number Format.<\/p>\n
Enter a logical \u00a0\u00a0function in cell F5 that calculates employee FICA withholding. If the \u00a0\u00a0employee is full-time and has at least one dependent, then he or she pays 7% \u00a0\u00a0of the annual salary minus any deductions. All other employees pay 5% of the \u00a0\u00a0annual salary minus any deductions. Copy the function down through column F. \u00a0\u00a0Format the data in column F with Accounting Number Format.<\/p>\n","protected":false},"excerpt":{"rendered":"
Start Excel. Download \u00a0\u00a0and open the file named Exp19_Excel_AppCapstone_ComprehensiveAssessment- Manufacturing.xlsx. Grader has \u00a0\u00a0automatically added your last name to the beginning of the filename.\u00a0 Group all the \u00a0\u00a0worksheets in the workbook and fill the range A1:F1 from the Insurance \u00a0\u00a0worksheet across all worksheets including the formatting. Ungroup the \u00a0\u00a0worksheets after the fill is complete and ensure … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2393","post","type-post","status-publish","format-standard","hentry","category-essaywr"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts\/2393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/comments?post=2393"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts\/2393\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/media?parent=2393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/categories?post=2393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/tags?post=2393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}