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

Organizational Leadership - Conflict resolution in the workplace powerpoint - Bblearn csuohio edu - Vce 2021 exam timetable - Speedy delivery systems can buy a piece - Siemens masterdrive parameter list - Gphc pre reg sample questions - Statistic - Ben and jerry's homemade case study solution - Internal medicine personal statement pdf - John zink ignition transformer - I wanna be yours poem - Reaction of potassium iodide with silver nitrate - Do sampling methods - Sanctions imposed on attorneys for overbilling clients - C++ program to add days to date - 14 minus the quotient of 25 and p - Marketing yourself plan - Crytographic Attacks - Adolf loos tribune tower - Prepaid satchel post office - Advantages and disadvantages of posttest only design - Kenya obstetrical and gynaecological society scientific conference - Peeping tom quote rear window - Pump start stop logic diagram - Synonyms of social networking - Total the capacity of each product in that segment capsim - Topic: The League of Iroquois Constitution and Government - On its acquisition-date consolidated balance sheet, what amount should trudata report as goodwill? - Winnie the pooh direct to video films - In cell g5, calculate the total due based on the annual total and years of membership in column f. - The train from rhodesia them - Case studies for nursing students - BEHAVIORAL SUPPORT PLANS - DUE IN 24 HOURS - Uob bank transaction code - To tell the truth heinrich heine analysis - Pillars of society matrix - How to make an isocost line in excel - Tú prefieres pasear por la plaza. - In a typical company organizational model middle managers ____ - PPT 10 slides with Note - Week 1 Discussion: Why Study Political Science? - Wuthering heights chapter 14 - Scholarly argument - Food hygiene course answers - Prefix meaning for pre - Asic form 201 - How to see gpa rmit - Sap ibp 100 pdf - Week 7 - How to date a brown girl - Different roles of a teacher - Eric foner give me liberty volume 2 pdf - Relational communication class - Week 5 final assignment - Statement of Purpose - I am chapman campaign - 12 angry men logical fallacies examples - The april bank statement for trimble corporation - MAJOR ASSIGNMENT 2: THE ANALYSIS AND INTERPRETATION OF QUALITATIVE DATA - 300 words not including references - TEST 090820 - Precision specialty tooling pty ltd - Effects of failure on students - Bbc viking quest game - Kj hr to kg hr - Quizzes - Valence electrons for each group - Arno bellack's pedagogical cycle features these moves - Summation of forces in cricket - Death penalty discriminates against black crime victims - Nrs 490 individual success plan example - Ekka sheep dog trials - Westberg model of the grieving process - Geographic pay differentials calculator - ETCM DISCUSSION-6 - Nursing diagnosis for peptic ulcer disease - Control system lab experiments - Capacity planning in operations management ppt - Order # 9556 - Number of edges in a cuboid - Construction Management & scheduling FINAL PROJECT - How to bid - Pediatric soap note - Stelrad radiator output chart - Visual analysis assignment - HR Planning, Work-Life Balance - Cloud in a bottle experiment explanation - Bu ke qi in mandarin pronunciation - Impediments to critical thinking - Introduction to sociology anthony giddens 11th edition pdf - Principles of computer security comptia security+ and beyond 3rd edition pdf - 1014(1) - DB 2 - Iec 60034 1 temperature rise - Fast connection failover 12c - Cambridge 6 test 1 writing task 1 answer - Radiographic markers a reservoir for bacteria - Rally robin kagan structure - Liquid water enters a kw pump