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

Where is total cell style in excel

17/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.

Office 2016 – myitlab:grader – 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:

Engineering Mentor
Accounting & Finance Master
High Quality Assignments
Coursework Helper
Online Assignment Help
Instant Homework Helper
Writer Writer Name Offer Chat
Engineering Mentor

ONLINE

Engineering Mentor

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$21 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$27 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$50 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$37 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$38 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$41 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

Mercury mahadasha jupiter antardasha - Big data means big potential challenges for nurse execs - Assa abloy lockwood manual - Which describes harmony in renaissance music? - What are the advantages and disadvantages of easily obtainable information - Ruth mccaddon bailey pictures - Types of reaction lab answers - Sofia kovalevskaya interesting facts - SERVANT LEADERSHIP PROJECT - Assigning oxidation numbers worksheet part b answer key - Australian early development index aedi - Project 1—Victims’ Rights Legislation Critique - Flinders university bedford park map - Epidemiology for public health practice 5th edition pdf free download - Butyric acid empirical formula - Business ethics william shaw 9th edition - Moment of inertia of a rectangle - Criminal procedure - Responding - Approaches to message authentication - Sarah edmondson and benjamin darras - Is whistleblowing ethically justified for an engineer - 9 4 proportional parts and triangles - A chain of appliance stores app corporation - Entered apprentice lecture third section - The myth of the latin woman purpose - Dichotomous key examples for dogs - A history of europe in the modern world palmer pdf - Powerball 1324 check ticket - Paradise malt biscuits iga - Organisational culture and its impact on employees behaviour ppt - Wrexham council bin not emptied - Chap. 6 Q MAC - Under armour annual report 2016 pdf - ENG102: Critical Writing - Discussion A: Exploring Your Own Styles of Communication - Shooting the moon henry lawson analysis - Organ leader and decision making - Convatec orahesive protective powder - Cpt code 00562 - Pedagogy of the oppressed chapter 1 summary - 3 reasons why college still matters - Book of mormon scripture mastery flashcards - Iptv architecture block diagram - Mary jo parker reviews - Money for nothing inside the federal reserve answers - Eitzen (2016) identifies that a fault of adult-organized sport is that it redefines “fun” - Roots of x 3 x 2 x 1 0 - Prepare a 6- to 10-slide presentation, with speaker notes, for the next web meeting - She got them brown eyes - African American Studies_Week 2 - Ehwic 4g lte a - The enrique camarena case a forensic nightmare - Essentials of nursing practice package fndn2015 - Pattern in residual plot - The journey of gilgamesh - Together in song australian hymn book - How to get system date in c++ - Dr azim and partners - Mass communication living in a media world 7th edition - The cash conversion cycle of working capital management is - Telstra band 1 salary range - App developers inc enters into a contract with carmen - How does social media make the world bigger - Management project proposal - Bunce fantastic mr fox - Two discussions - Pestle analysis for escape rooms - Opponent process theory negative afterimages - Guess my number python code - ECO/535: ECO/535: - A box contains 20 fuses of which 5 are defective - Koch's postulates diagram - Aluminium die casting defects ppt - Statement of partnership liquidation - Julie bowen eating disorder - Discussion - Follow the outline, and complete the 4-6 outline - Nucor at a crossroads case - Planned road closures lincolnshire - Office move gantt chart - 12 o clock high toby jug - Research Paper - Flowchart to java code - Calculate drops per minute - User profile wizard 3.12 - Speech and language screening report template - Fartlek training fitness components - What are the four strategic alternatives - Explain the differences you saw between the two websites you observed in Wireshark. What were the differences you noticed when you did the trace? You should write about 250 words or more . - Case study - Henderson state university undergraduate tuition and fees - Https www youtube com watch v gf81d0ys58e - What is the dapps rule - Robert palmer she makes my day chords - Predict the ph of an aqueous solution of nh4no3 - Ultrasonic blind stick project - Positivism - In praise of the f word argumentative essay - Balancing chemical equations practice