Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Apply the total cell style to the selected cells

09/11/2021 Client: muhammad11 Deadline: 2 Day

1.Start Excel. Download and open the workbook named go16_xl_ch04_grader_4g_hw.xlsx, and then save it in your Excel Chapter 4 folder as Lastname_Firstname_4G_Loan_Staff_Form.

2.Display the second worksheet named Warehouse Payment Table. In cell B8, enter a PMT function using cell B4 divided by 12 as the rate, cell B3 as the number of payment periods, and cell B2 as the present value of the loan. Display the result as a positive number.

3.Create a two-variable data table in the range B8:H16. Set cell B3 as the row input cell, and cell B4 as the column input cell. From the Cell Styles gallery, apply the Currency cell style to the range C9:H16. Select the payment option closest to but less than $10,000 per month for a 120-month loan—cell D16—and format the option with the Note cell style. Save your workbook.

4.Display the fourth worksheet named Job Information, select the range A4:C11, and then sort the range by Job Code in ascending order. Create a range named Job_Code using the data in cells A5:A11.

5.Display the Staffing Plan worksheet, and then select the range A9:A18. Display the Data Validation dialog box, and validate from a List using the Source =Job_Code.

6.Click cell A9, click the list arrow, and then click M-MG. Click cell B9 to make it the active cell, and then insert a VLOOKUP function that will look up the Description of the Job Code in cell A9 using the information in the Job Information worksheet as the table array. After selecting the table array, be sure to press F4 to make it an absolute cell reference. The Description to be looked up is in column 2 of the table array.

7.With cell B9 as the active cell, copy the VLOOKUP formula down through cell B18. In cell C9, type 1 as the # of Positions and in cell D9, type Management as the Type.

8.In cell E9, insert the VLOOKUP function to look up the Salary of the Job Code in cell A9 by using the information in the Job Information sheet as the table array; the Salary is in column 3 of the table array. Copy the VLOOKUP formula in cell E9 down through cell E18.

9.Beginning in cell A10, add these staff positions:
Item # of Positions Type
C-CASH 3 Cashier
C-CSA 1 Customer Service
M-AMG 3 Management

10.Delete any unused rows between the last item and the Total row. Sum the Budget Amount column and apply the Total cell style. Save your workbook.

11.Display the Bracelet Revenue worksheet. Click cell I5, and then on the Formulas tab, click Trace Precedents. On the ribbon, in the Formula Auditing group, click Error Checking, and then click Edit in Formula Bar. Edit the formula so that the formula is using the Growth Assumption for Beaded Bracelets, not for Crystal Bracelets.

12.In the Error Checking dialog box, click Resume. In cell M6, notice the formula is trying to divide by cell L10, which is empty. Click Edit in Formula Bar, change 10 to 9 Ensure that the reference to L9 is an absolute reference, and then in the Error Checking dialog box, click Resume.

13.In cell F7, examine the error information, and then click Copy Formula from Above. Examine the error in cell J8, and then click Copy Formula from Left. Click OK. Use Format Painter to copy the format in cell M5 to cell M6. Save your workbook.

14.In the sheet tab row, right-click any sheet tab, and then click Select All Sheets. Display the Page Setup dialog box, click the Margins tab, and then under Center on page, click Horizontally. Click the Header/Footer tab, click Custom Footer, and then in the Left section, insert the File Name. Click OK two times. Ungroup the sheets, and then for these three worksheets—Warehouse Payment Table, Staffing Plan, and Bracelet Revenue—set the Orientation to Landscape. Select the Bracelet Revenue sheet, and on the Page Layout tab, set the Scale to 90%. Add the tag New York revenue to the properties.

15.Ensure that the worksheets are correctly named and placed in the following order in the workbook: Warehouse Purchase, Warehouse Payment Table, Staffing Plan, Job Information, Revenue. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

Instructions Excel Project

GO16_XL_CH04_GRADER_4G_HW - Warehouse Loan and Staff Lookup Form 1.3

Project Description: In this project, you will create a named range and use it to set data validation. You will use a PMT function to calculate a value and then use it in a two-variable data table. You will also enter VLOOKUP functions to return values from a table, and format cells in the workbook. You will also audit a worksheet and correct errors.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download and open the workbook named go16_xl_ch04_grader_4g_hw.xlsx, and then save it in your Excel Chapter 4 folder as Lastname_Firstname_4G_Loan_Staff_Form. 0.000 2 Display the second worksheet named Warehouse Payment Table. In cell B8, enter a PMT function using cell B4 divided by 12 as the rate, cell B3 as the number of payment periods, and cell B2 as the present value of the loan. Display the result as a positive number. 9.000 3 Create a two-variable data table in the range B8:H16. Set cell B3 as the row input cell, and cell B4 as the column input cell. From the Cell Styles gallery, apply the Currency cell style to the range C9:H16. Select the payment option closest to but less than $10,000 per month for a 120-month loan—cell D16—and format the option with the Note cell style. Save your workbook. 15.000 4 Display the fourth worksheet named Job Information, select the range A4:C11, and then sort the range by Job Code in ascending order. Create a range named Job_Code using the data in cells A5:A11. 10.000 5 Display the Staffing Plan worksheet, and then select the range A9:A18. Display the Data Validation dialog box, and validate from a List using the Source =Job_Code. 8.000 6 Click cell A9, click the list arrow, and then click M-MG. Click cell B9 to make it the active cell, and then insert a VLOOKUP function that will look up the Description of the Job Code in cell A9 using the information in the Job Information worksheet as the table array. After selecting the table array, be sure to press F4 to make it an absolute cell reference. The Description to be looked up is in column 2 of the table array. 10.000 7 With cell B9 as the active cell, copy the VLOOKUP formula down through cell B18. In cell C9, type 1 as the # of Positions and in cell D9, type Management as the Type. 7.000 8 In cell E9, insert the VLOOKUP function to look up the Salary of the Job Code in cell A9 by using the information in the Job Information sheet as the table array; the Salary is in column 3 of the table array. Copy the VLOOKUP formula in cell E9 down through cell E18. 11.000 9 Beginning in cell A10, add these staff positions: Item # of Positions Type C-CASH 3 Cashier C-CSA 1 Customer Service M-AMG 3 Management 4.000 10 Delete any unused rows between the last item and the Total row. Sum the Budget Amount column and apply the Total cell style. Save your workbook. 3.000 11 Display the Bracelet Revenue worksheet. Click cell I5, and then on the Formulas tab, click Trace Precedents. On the ribbon, in the Formula Auditing group, click Error Checking, and then click Edit in Formula Bar. Edit the formula so that the formula is using the Growth Assumption for Beaded Bracelets, not for Crystal Bracelets. 5.000 12 In the Error Checking dialog box, click Resume. In cell M6, notice the formula is trying to divide by cell L10, which is empty. Click Edit in Formula Bar, change 10 to 9 Ensure that the reference to L9 is an absolute reference, and then in the Error Checking dialog box, click Resume. 5.000 13 In cell F7, examine the error information, and then click Copy Formula from Above. Examine the error in cell J8, and then click Copy Formula from Left. Click OK. Use Format Painter to copy the format in cell M5 to cell M6. Save your workbook. 7.000 14 In the sheet tab row, right-click any sheet tab, and then click Select All Sheets. Display the Page Setup dialog box, click the Margins tab, and then under Center on page, click Horizontally. Click the Header/Footer tab, click Custom Footer, and then in the Left section, insert the File Name. Click OK two times. Ungroup the sheets, and then for these three worksheets—Warehouse Payment Table, Staffing Plan, and Bracelet Revenue—set the Orientation to Landscape. Select the Bracelet Revenue sheet, and on the Page Layout tab, set the Scale to 90%. Add the tag New York revenue to the properties. 6.000 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Warehouse Purchase, Warehouse Payment Table, Staffing Plan, Job Information, Revenue. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quick N Quality
Finance Homework Help
Fatimah Syeda
Academic Mentor
George M.
Instant Assignment Writer
Writer Writer Name Offer Chat
Quick N Quality

ONLINE

Quick N Quality

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$26 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$34 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$35 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$21 Chat With Writer
George M.

ONLINE

George M.

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$46 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$29 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Nasw code of ethics pdf 2019 - Alfa laval pharma x - Discussion : 15 hours time limit - Debate the efficacies of public versus private based quality initiatives - What ice cream flavor am i - Corporate finance cases and solutions - Social psychology movies - Potato osmosis experiment results - Tyree energy technology lg05 - 6 punctata court voyager point - Discussion - Quickdatabasediagrams - Mit power electronics lab - Lost dog budweiser commercial song - What does fcfs mean on facebook - Physics - — SAT TASK 1: NURSING-QUALITY INDICATORS - Advantages and disadvantages of mmpi 2 - Standards and Accountability - Frequency response of op amp theory - Role of Emotional Intelligence - Bacha meaning in arabic - Team rocket kekeke pokemon go - Double chocolate chip cookies rachel allen - Ufc 3 520 01 - Notes - Oh molecular orbital diagram - Umuc spch 100 quiz 1 - Immigration, Migration and Organization Discussion - How to calculate outright quotes for bid and ask - How to prove diagonals bisect each other - I prefer simple work related assignments agree or disagree - Otago university database - Catkins cattery pamber heath - Red bull product strategy - Comparison of twisted pair coaxial cable and optical fiber - How to identify gaps in literature - Excel funtion question - 8464 b 1h mark scheme - Diagnosing fictional characters with psychological disorders - Cardboard boat race tips - Bus mount gambier to adelaide - 5.879 e 12 in miles - The fall of the rebel angels painting meaning - 60 second radio commercial examples - How to determine water hardness - Kensington wing chelsea westminster price list - PRETORIA WEST ABORTION CLINIC 0717852514 ABORTION PILLS FOR SALE IN MAMELODI, WITBANK, ARCADIA, PRETORIA, SHOSHANGUVE - The scottsboro trial questions and answers - Homework 3 - Market potential index for emerging markets - For Essays Guru - - Sword art online monopoly - Block diagram of 8085 microprocessor - Francis turbine lab report - What's driving porsche case study - Use the above adjusted trial balance - Annotated Bio-2 - Tax Homework - Swot analysis in paragraph form - Hoyer and macinnis 2001 - Bd accuri c6 software download - Strategic factor analysis summary sfas - What's stifling the creativity at coolburst - Week from 2 to 4 - Starry night edvard munch analysis - Square root of 55 - A mutual fund company offers its customers - Sciencespot net scientific method crossword answers - Sandow birk death of manuel - What is the mass in grams of 7.35 mol water - Slope stained glass project - Nurses communicating with legislators to influence health policy - Pycnometer is used to determine - Under armour mission statement 2014 - Pb no3 2 2ki pbi2 2kno3 - Personal training case study answers - Website analysis memo - Accounting 201 Rephrase in own words - The legal environment of business a critical thinking approach pdf - Malapportionment and gerrymandering difference - Architectural scope of services checklist - Telephone collection call scripts - Addressing selection criteria examples - Shaw farm pub essex - The art of the commonplace - What are the best ways for marketers to reach you to get you to try their products or services. Why is that effective? - List the steps in the accounting cycle - Impact and trends regarding health care access quality technology - Extra credit - Module 09 Discussion - Brain Death: Ethical Considerations - UNIT3ASSIGN1 Due 10.27.2020 - Sungold soy style thick sauce - Linda raschke swing trading - Informatics and nursing opportunities and challenges 6th edition pdf free - Two page memo - Hunger games worksheets answers - 636 w rosewood ave san antonio tx 78212 - Scale - Qualitative inquiry and research design choosing among five approaches pdf