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

Excel independent project 2 4

01/12/2021 Client: muhammad11 Deadline: 2 Day

Excel 2019 In Practice - Ch 2 Independent Project 2-4

Need this assignment completed in the form of an Excel document

Username: D41122036 Excel 2019 In Practice - Ch 2 Independent Project 2-4 COURSE NAME BIS155 SEP20 Master | Data Analysis with Spreadsheets with Lab - 11964

Start Date: 08/29/2011:59 PMUS/Mountain Due Date: 09/06/2011:59 PMUS/Mountain End Date: 10/25/2011:59 PMUS/Mountain

Independent Project 2-4 Central Sierra Insurance (CSI) sets bonus percentages based on commissions earned by each agent and calculates totals by branch office. This workbook also tracks fundraising efforts of employees for a community event. [Student Learning Outcomes 2.1, 2.2, 2.3, 2.5, 2.6, 2.7]

File Needed: CentralSierra-02.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-CentralSierra-02.xlsx

Skills Covered in This Project Create, copy, and edit formulas. Name cell ranges. Set mathematical order of operations. Set cell references to be absolute. Use the NOW function. Use HLOOKUP and VLOOKUP Use the SUMIF function. Build an IF function.

1. Open the start file CentralSierra-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

2. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group].

3. Select cells B1:F2 and click the Name box. Name the selection H_Rates. Note that the first row is arranged in ascending order.

4. Create an HLOOKUP function to display the bonus rate.

a. Click the Commissions sheet tab and select cell F5.

SIMnet - Excel 2019 In Practice - Ch 2 Independent Project 2-4 https://devry.simnetonline.com/sp/embed/#pr/5573827

1 of 4 10/22/20, 10:43 PM

Figure 2-100 HLOOKUP function to display bonus

b. Start the HLOOKUP function and use cell E5 as the lookup_value.

c. For the table_array argument, use the H_Rates range.

d. Use the second row for the row_index_num argument (Figure 2-100).

5. Format the results as Percent Style with two decimal places.

6. Copy the formula in cell F5 to cells F6:F14.

7. Set order of operations to calculate total earnings.

a. Select cell G5.

b. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5).

c. Copy the formula in cell G5 to cells G6:G14.

8. Create and copy a SUMIF function to calculate total earnings by branch office.

a. Select cell E18.

b. Start the SUMIF function with cells $D$5:$D$14 as the Range argument.

c. Set the Criteria argument as a relative reference to cell C18.

d. Select cells G5:G14 for the Sum_range argument and make the references absolute.

e. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders.

f. Format cells E18:E21 as Currency.

9. Total the earnings in cell E21.

10. Create and format the current date.

a. Select cell G23 and insert the NOW function.

b. Select cell G23 and click the Number drop-down list, and select More Number Formats. On the Number tab, select the Date category.

c. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).

d. Click OK. Press fn+Ctrl+Left Arrow or fn+Cmd+Left Arrow.

11. Create and copy a VLOOKUP function to display goals for each funding source.

a. Click the Family Day sheet tab and select cell F6.

b. Start the VLOOKUP function and use cell E6 as the lookup_value.

c. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.

d. Use the second column as the col_index_num The range_lookup argument is empty.

e. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.

f. Format cells F6:F20 as Currency with no decimal places.

SIMnet - Excel 2019 In Practice - Ch 2 Independent Project 2-4 https://devry.simnetonline.com/sp/embed/#pr/5573827

2 of 4 10/22/20, 10:43 PM

Figure 2-101 Date format selected

12. Create and copy an IF function.

a. Select cell H6 and start an IF

b. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.

c. Type Yes as the Value_if_true argument and No as the Value_if_false argument.

d. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.

e. Center align cells H6:H20.

f. Press fn+Ctrl+Left Arrow or fn+Cmd+Left Arrow.

13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.

14. Save and close the workbook (Figure 2-102).

Figure 2-102 Excel 2-4 completed

SIMnet - Excel 2019 In Practice - Ch 2 Independent Project 2-4 https://devry.simnetonline.com/sp/embed/#pr/5573827

3 of 4 10/22/20, 10:43 PM

15. Upload and save your project file.

16. Submit project for grading.

SIMnet - Excel 2019 In Practice - Ch 2 Independent Project 2-4 https://devry.simnetonline.com/sp/embed/#pr/5573827

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:

Smart Accountants
Exam Attempter
Homework Tutor
Accounting & Finance Specialist
Solutions Store
Assignments Hut
Writer Writer Name Offer Chat
Smart Accountants

ONLINE

Smart Accountants

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

$18 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$29 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

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

$23 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$30 Chat With Writer
Solutions Store

ONLINE

Solutions Store

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$20 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

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

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

Unit 2 Discussion #2 - Ista 2a vs 3a - Law & Ethics in the Business Environment - Nursing research - What makes a great screenplay - Eaton 9130 rackmount ups - New innovations in mathematics - Resource utilization charts based on each activity’s earliest start time are said to be based - Cio presentation ppt - Isopentyl alcohol with acetic acid - Percussive arts society rudiments - Launchpad statistics answers - Annotated Bibliography - Advantages and disadvantages of anova - What is a information report - Ms abc plan room - The saints and the roughnecks - Final Project, Part 1 - Serving it right answers - Baubles and bubbles columbia sc - Ulsan university graduate admission - Black bread mold reproduction - Google Admob - From which direction does autocad start measuring angles - Accounting information systems controls and processes 3rd edition test bank - Standard deviation of x symbol - Analyzing Parametric Statistics - 1996 collector's edge president's reserve - Owasp stands for - Writing - The premier business oriented social networking site - Julie pett dog training - Qq - Cowards cakes mildura west - Cornell notes on i have a dream speech - Discussion Responses- ITGE - 2 short paragraphs - Lorem Lorem - The mobile crane has a weight of - Horatian and juvenalian satire - Structure and profile of residential aged care sector - Taming of the shrew act 3 quizlet - How to calculate euac in excel - My papa's waltz figurative language - Performance education melbourne contact - Speed of a toy car lab report - The rotation of rod oa about o is defined - CASE STUDY - Hippie sabotage providence cover girl name - Reverse return piping diagram - Discussion Board - Discuss this - IT-project management DQ7B - Week 04 Research Paper - Brave new world chapter 17 summary - Ms hagen of films crossword - Media ethics issues and cases pdf - Perform the indicated operations and reduce to lowest terms - History of California-4 - How to find the practical domain - Strat Planning1 - Role play - Who does katniss end up with - Rifle company butterworth medal - Assignment - What was jonathan kozol’s impression of the poorly funded schools he visited in urban chicago? - Homework help - What are three ways heat is transferred - Dialogue between social worker and client - The piano lesson analysis - The rocking horse winner discussion questions - Polishing stainless steel trim - Ftsz inhibitor and imipenem - Hsi talents - Air meals is a company that prepares - How many beagles weigh between 22.5 and 29.5 - Dr irena eris cosmetic laboratories - Walmart ethical dilemma - Loughborough hospital phone number - A consensus of procedures in the career counseling models - Discussion Question - Reticulum function in digestive system - Mt cole state forest - Psy 410 week 5 programmatic assessment - How to calculate reticulocyte count - University of warwick grading system - Sodium hydroxide + hydrochloric acid word equation - CONTRACT LAW (ESSENTIAL ELEMENTS) - Unsw apa style referencing - Training and Development : Unit VI Journal, Unit VI Assessment, Unit VII Homework, Unit VII PowerPoint Presentation - Dialogue between social worker and client - A raisin in the sun worksheets - Walmart retail link login page - OtisLine Case Study - Systems engineering principles and practice pdf - Law exam - Anatomy and physiology II - Answer to essay-200 words minimum (YL) - Human resource - Triangular arbitrage with bid ask quotes