https://publicpagestutorbin.blob.core.windows.net/%24web/%24web/assets/Vector_3_18e566da35.png

Excel Homework Help

Excel in Exams with Expert Excel Homework Help Tutors.

https://publicpagestutorbin.blob.core.windows.net/%24web/%24web/assets/Frame_1_7db546ad42.png

Trusted by 1.1 M+ Happy Students

trustPilot
4.4Trust Pilot
eduReviewer
4.4Edu Reviewer
app
5App Review
student
4.8Student
WhatsApp Support

Get Instant
Online Homework Help
via WhatsApp

Get instant homework help from top tutors—just a WhatsApp message away. 24/7 hw help support for all your academic needs!

A
S
M
R
★★★★★
2M+ students trust TutorBin
Your WhatsApp Number
phone
or
⚡ Instant reply
🔒 100% private
👨‍🏫 Top tutors
🌍 All subjects
*Get instant homework help from top tutors—just a WhatsApp message away. 24/7 support for all your academic needs!
2M+ Students Helped24/7 Live SupportExpert TutorsAll Subjects CoveredInstant Response100% ConfidentialTop Rated ServiceMoney-back Guarantee2M+ Students Helped24/7 Live SupportExpert TutorsAll Subjects CoveredInstant Response100% ConfidentialTop Rated ServiceMoney-back Guarantee

Quality Excel Assignment Help At Your Fingertips

Excel is a common subject for those pursuing advanced studies in computer science. Though CS is popular, Excel is quite the opposite. It's one of the most misunderstood subjects and disliked by a large number of students. This subject is closely related to mathematics and calculations. Undoubtedly, it is complex yet not impossible to ace. According to educators, students who request, "do my Excel assignment help for me," can seek guidance from TutorBin. With Excel homework help from TutorBin subject experts, students can fulfill their academic needs in the best possible way.

The assistance they receive strengthens their subject understanding, clears up doubts to fill their knowledge gaps, and enhances their skill sets. Due to these advantages, students receive Excel assignment help regardless of their academic level, subject, or country. It encourages students to overcome their study challenges and enhance their subject knowledge, motivating them to perform their best. With the "do my Excel homework for me" service, academic success is just a step away with just a click of a button.

Excel Homework Help- Subjects Our Experts Cover

Considering the importance of strengthening students' Excel skills, TutorBin offers specialized support in diverse critical areas of this discipline. If you’re thinking, do my homework our team of professionals offers comprehensive assistance through Excel homework help. Our team guides students thoroughly, regardless of the subject's complexities. This approach saves study time, encouraging them to

  • Excel basics
  • VLOOKUP
  • IF Function
  • Pivot Tables
  • Charts
  • Excel Analytics
  • Macros
  • Data Analysis
  • Cell Referencing
  • Keyboard Shortcut
  • Conditional Formatting
  • Excel VBA
  • Data Validation
  • Power Query
  • Data Cleanup
  • Index Match
  • IFERROR
  • Statistics

Homework Help Excel- Topics Covered By Experts

Whatever topic you find challenging, ask for Excel homework assistance from TutorBin experts for support. When you reach out to our subject experts, you can be assured of receiving guidance tailored to your academic needs and aligned with your learning style. No matter how difficult or complex a topic may be, our experienced tutors possess the domain expertise to help you grasp it.

  • Data entry and formatting
  • Creating basic & advanced formulas
  • Application of advanced formulas
  • Navigating the Excel interface
  • Managing worksheets
  • Creating tables and graphs
  • Presenting data in basic visual charts
  • Sorting and filtering data in ascending or descending order
  • Subtraction, multiplication, and division
  • Making use of the Formula tab and Functions library
  • Using formulas to manipulate basic data
  • Building a PivotTable to extract insights from data
  • Effective use of the AutoFilter feature
  • Record and edit macros

Help With Excel Assignments For Students: Why Do You Need It?

Research indicates that teachers often assign homework or tasks based on their assumptions about students' abilities. However, not all students have the same learning capacities. Some of them face difficulties doing their assignments appropriately. Our Excel assignment help is the perfect solution for them, responding to their "do my Excel homework" requests.

Whether it's doubts, complex concepts, inability to analyze data, or creating formulas for diverse activities, homework help Excel can help you overcome your study challenges. From basic functions to advanced techniques, we provide clear explanations and practical examples to help you master Excel. The extensive experience and domain expertise of subject specialists ensure you get expert help at your fingertips.

Restricted Conceptual Understanding:

Understanding the underlying concepts behind Excel features, such as pivot tables, macros, and data analysis, can be a source of difficulty. It hinders your ability to implement your theoretical knowledge in real-world scenarios.

Complexity of Assignments:

The Excel interface and functionality often seem overwhelming for beginners. Students often face confusion due to the complexities of concepts and their applications, which can lead to frustration and hinder their ability to complete assignments.

Lack of Personalized Guidance:

Professors often assume that everyone understands the same material, but students have different academic requirements. Not one solution fits all. Students often fail to understand because of a lack of personalized guidance from subject experts.

Limited Access to Resources:

One major problem students frequently face while studying Excel is their limited access to ample learning materials and tutorials. It makes learning Excel challenging, as students find it difficult to expand their subject knowledge beyond basic operations.

Difficulty in Data Analysis:

Students with weak analytical skills feel daunted when tasked with analyzing large data sheets and asked to perform complex calculations in Excel. Their lack of analytical knowledge hinders them from applying analysis techniques appropriately.

Integration Challenges:

One of the most complex things students often experience is successfully integrating Excel with other software tools or platforms. In most cases, students were unable to accomplish their data import/export and automation goals due to unfamiliarity with these processes.

Error Detection & Handling:

One of the most common yet critical problems students encounter while working with Excel formulas and functions is error detection and correction. The complex nature of the Excel interface often causes students to fail to point out their mistakes.

Software Version Compatibility:

Students encounter issues when their assignments require specific features that are unavailable in their version of Excel. The lack of functions compatible with their software version makes assignment completion tougher than anticipated.

Time Constraints:

Balancing Excel assignments with other academic commitments can be challenging, requiring a lot of time and effort. Students with limited time to refine their skills and priorities find complex Excel assignments problematic and stressful.

Lack of Practice:

Experts have experienced that a large number of students do not practice Excel sufficiently outside of their coursework. It results in a limited understanding, obstructing them from performing well and achieving high grades in their college years.


"Do My Excel Homework" - Is It Right to Ask?

Concerns about the security and legality of homework help are common among students. TutorBin addresses these doubts with its "pay someone to do Excel homework" service. It is similar to offline expert tutoring, where they can obtain professional assistance. It enhances the learning experience, which in turn boosts their academic performance. Although some professors may not prefer it, expert guidance cannot be considered cheating, as there is no legal prohibition against it.

Whenever you request us to "do my Excel homework for me," we understand that you need expert help, accompanied by the guarantee of privacy. Obtaining professional help from TutorBin is completely safe as the site is encrypted with high-security software and never discloses your information to any third party. You can ask me to "do my Excel homework for me", and we are confident that this learning approach will enhance your academic competency and ensure your success.


Hiring Excel Experts for Better Data Visualization

Good grades require clear and well-presented data. Your charts should be easy to understand, properly labeled, and relevant to your analysis. Many students seek help with Excel homework when they need assistance creating professional charts and presenting complex datasets. Our Excel experts help create customized graphs based on your specific data, using the right visualization for comparisons, trends, and patterns. We also provide support with advanced Excel features for students working on business, statistics, finance, psychology, and engineering projects.

We use conditional formatting to highlight important values and make key trends easier to identify. This helps your professor quickly understand the information presented in your spreadsheet. We avoid unnecessary elements and cluttered designs that can make your data difficult to interpret.

With excel help online, students can also get guidance with statistical analysis, survey data, calculations, and data presentation. Our Excel support includes:

  • Customized bar, line, column, and pie charts.
  • Interactive dashboards with slicers and filters.
  • Dynamic charts for changing datasets.
  • Heat maps for identifying data patterns.
  • Clear titles, labels, and professional legends.
  • Conditional formatting and color-coded cells.
  • Organized tables for academic reports.
  • Professional spreadsheet formatting.
  • Print-ready charts and high-quality visuals.

Our goal is to make your data easier to understand and present. We can also help create interactive dashboards that allow you to filter information and explore different aspects of your dataset. Whether you are preparing a business report, marketing analysis, statistical project, or academic presentation, effective data visualization can make your findings more accessible.

Students who need help with Excel homework can work with experienced Excel experts for guidance on charts, formulas, pivot tables, dashboards, and other Excel features. We focus on creating visuals that support your analysis rather than adding unnecessary design elements.

Professional Excel visualization can help you present your findings with greater clarity. From simple charts to advanced dashboards, our excel help online is designed to help students organize, analyze, and present their data effectively.

Online Excel Assignments Help Benefits For College Students


Expert Guidance In Excel

When students ask TutorBin to "do my Excel homework," they enjoy assistance from subject specialists. TutorBin has a vast network of subject experts. Almost 65,000 tutors work with us, including over 800 Masters and Ph.D. degree holders. Our team ensures that our tutors are highly experienced and knowledgeable in their respective domains, helping students to experience better learning and become highly competent.

Customized Learning Facility

Our experts acknowledge that not every student requires the same level of assistance. The need varies according to students' learning ability, academic inclination, subject knowledge, and IQ. Students need personalized guidance that aligns with individual learning styles and paces. Depending on the factors mentioned above, TutorBin subject experts offer customized learning solutions to meet the academic needs of students.

Accurate & Plagiarism-Free

One of the best benefits of seeking expert guidance is receiving 100% accurate and plagiarism-free solutions. Our experts ensure that your solutions are tailored from scratch to meet your specific academic requirements. Each solution is completed step-by-step and accompanied by explanations to ensure accuracy and originality. This approach ensures that students maintain academic integrity.

Assured Timely Assistance

On-time guidance is probably one of the best parts of TutorBin's "do my Excel homework for me" service. Considering the importance of deadlines for students, our subject specialists emphasize the importance of prompt delivery. They ensure you don't have to wait and can submit Excel assignments on time. This on-time assistance saves students from a last-minute rush to submit tasks.

24/7 Academic Assistance

TutorBin's "do my Excel homework" service is known for its 24/7 academic support. Students can access immediate assistance whenever needed. It ensures that students receive expert guidance and invaluable insights consistently, regardless of different time zones. This accessibility fosters a conducive learning atmosphere, providing quick solutions on or before task deadlines.

Precise learning on specific topics

TutorBin has designed a precise learning opportunity for students. By opting for this approach, students can seek targeted assistance from experts on specific topics or subjects. Instead of assistance for the whole course, they can ask experts to "do my Excel assignment" for particular study areas. This method of guidance makes Excel learning convenient and cost-effective for students.

Cost-effective Learning Guidance

Affordable learning enables students to access high-quality academic support without straining their finances. If you are thinking of seeking online Excel homework help but can't do it due to a tight budget, TutorBin is there for you. Our expert assignment help team ensures that every student who reaches out to us can enhance their skills and knowledge without worrying about finances.

Guarantee of a Fully Secured Account

Seeking TutorBin's homework help, Excel offers the advantage of a fully secured account, as our site is encrypted with advanced software. Our team protects students' information. It ensures that students' details and information about their academic assistance are not disclosed to any third party. The policy reflects our sincere commitment to maintaining customer privacy.


Frequently Asked Questions About Excel Help

We receive numerous requests, such as "do my Excel homework." Our Excel homework help experts diligently respond to these requests, striving to meet students' academic requirements. However, students sometimes feel concerned and have doubts about various matters. Here, we have attempted to address some of the questions you frequently ask our experts. We hope the answers to these frequently asked questions bring you better clarity.

How Can I Pay Someone To Do Excel Homework?

For expert guidance, visit a top Excel homework help site like TutorBin. Sign up at " www.tutorbin.com" and contact professionals for assistance through the order form. Experts will connect to you within a few minutes.

How Much Does an Excel Assignment Cost?

The cost of Excel assignment assistance starts at $6, although it varies depending on the proximity to the deadline, question complexity, and expert availability. However, with offers and discounts, students get assistance at an affordable price.

Recently Asked Excel Questions

Expert help when you need it
  • Q1:Excel case Public Television Case The deliverable (two parts, both due at the same time): The first part of the deliverable is a spreadsheet that will show a pseudo budgeted income statement and cash flow, based on the given assumptions. The second part is a word document with your recommendations on how management should proceed. Name both the word document and the spreadsheet with your last name – so I would name them shepherd.doc and shepherd.xlsx You will lose 10% for not following all of this, so save your files now so you won’t forget to do so later. Background: You work for a public television station. You are running a week-long campaign in an effort to get donations. You run spots (sales pitches for money) and offer promotional gifts. The two gifts under consideration are an umbrella, and a one-year magazine subscription to a popular magazine. If a viewer donates $45 they will get the umbrella, and if they donate $50 they will get the one-year magazine subscription. The campaign will last for 7 days, and will run for 12 hours each day. You will do one sales pitch each hour and will offer either the umbrella or the magazine subscription, but not both during the same pitch. Each sales pitch can be considered a spot. One problem is that you must purchase the gifts (umbrellas and magazine subscriptions) in advance. The cost is $25 for each umbrella, and $25 for each magazine subscription. The question for you is how many magazine spots and how many umbrella spots should the station air during the campaign, given the goal of maximizing net income? Important facts: Typical audience size during any hour is expected to be 100,000 homes (different homes each hour, but 100,000 on average). Your marketing experts say that 1% of the homeowners will respond positively to an umbrella spot (they will purchase an umbrella) and 1.5% of the homeowners will respond positively to a magazine spot (they will purchase a magazine subscription). For example, if 10 umbrella spots are run, 100,000 people see each spot and you will have 100,000 * 10 * .01 umbrella purchases. Based on prior campaigns, management knows some viewers who make a donation for a gift will spontaneously donate money again at a later time (not for a gift, but just because they are great people). This gift is $25. Management estimates that 25% of the umbrella recipients will do this, and 10% of the magazine recipients will do this. Management wants at least 30 spots to be run for each gift. Management wants to earn as much net income as possible. How many of each spot should be run? The first part of your deliverable is the spreadsheet where you used the Solver tool showing the maximized net income and binding constraints given the above situation and constraints. The second part is a word document with your recommendations on how management should proceed. While there are about seven different recommendations you can make, I’m looking for four recommendations. The original spreadsheet answer will be your first recommendation. It is probably obvious, but you can’t make recommendation #1, then make recommendation #2, then combine recommendations #1 and #2 into recommendation #3. So each of the recommendations should be different from the other recommendations. Your recommendation should be something that came from the binding constraints in your spreadsheet. So it isn’t realistic for you to say the spreadsheet results suggest that hiring a famous person to give the pitches will result in a 25% increase in net income. Hiring a famous person may do that, but you would be hard pressed to support that number. Along the same line, don’t just suggest that we raise prices for the umbrella or the magazine. Include the net income figure with each recommendation. Suppose the original spreadsheet shows that you should run 1 spot for umbrellas and 1 spot for magazines (it won’t but this is just an example). You would write: Rec. 1: given the constraints we should run 1 umbrella spot and 1 magazine spot for a net income of $$$.See Answer
  • Q2:Assignment Total points 100. Submit through D2L in Word/Excel format, single or multiple files. Must show your work, answer all parts of the question, show all relevant graphs, and write necessary explanations to earn full points. Grading depends on three components of your answer- accuracy and completeness of your calculations (numerical results); accuracy of relevant graphs; and accuracy and completeness of necessary explanations/interpretations/conclusions. You must use Excel to solve this numerical problem (project). The following table gives monthly data for four years in million tons of consumption of ice cream in a country. Plot the series and comment on the visible seasonality and trend. Estimate the centered moving averages for this monthly series. Plot CMA and comment. Next, estimate the S,I component which only includes seasonal and irregular movements of the series. Then find the seasonal indexes for the twelve months removing the irregular component. Find the de-seasonalized levels for the series. Plot De-seasonalized Y and comment. Then estimate the trend values for the four sample years and the 12 months of the year 2022 using linear regression. Finally, make the forecast for the 12 months of 2022 using the Ratio-to-Moving Average method to capture the Trend and Seasonal patterns, using Excel. Plot the forecasted values for the 60 periods including 12 months of the year 2022. Plot the errors for in-sample periods and calculate RMSE. Comment on the error plot with respect to the existence of pattern or lack of visible pattern. Month/Year 2018 2019 2020 2021 Jan 110 140 185 220 Feb 120 150 195 230 Mar 130 155 205 245 Apr 140 175 215 265 May 160 200 235 295 Jun 180 230 250 330 Jul 190 252 270 345 Aug 180 232 260 330 Sep 170 225 250 315 Oct 160 215 230 300 Nov 140 195 210 265 Dec 130 180 205 250 (Hint: First, you have to type the data in a single column form in Excel)See Answer
  • Q3:Overview This assignment has multiple parts: 1) you will extend your Excel model to include the impacts from climate change and 2) analyze the costs and benefits of a number of specific policy proposals. Then, 3) you will adjust the model such that the impacts from climate change are related in a more interesting way to the level of economic development, and finally 4) investigate the effect of different income elasticities on damages. Section 1: Impacts from Climate Change Part I: Modeling Overview You will add a component for the impacts of climate change to your model this week. You will also modify the growth model to pick up the estimate of climate impacts. With that component, you will have a model that provides estimates of everything needed to do a cost-benefit analysis of climate change policy. Impact model The impact model is extremely simple. We assume that the harm done from rising temperatures in a given year as a share of gross output is: Dt = VT2 (1) So Dt is damage as a share of gross output in year t, y is a parameter that you should set to 0.003 and Tt is global average temperature in °C above pre-industrial levels at time t. You should pick up the temperature from the climate dynamics component you have built previously. Growth model To close the loop, you should modify the equation for net output in the growth model to not only subtract the costs of abatement from gross output, but also the damages from climate change that you just added to the model. You must figure out the precise new equation for net output yourself. Have a look at how abatement costs were subtracted from gross output and try to do the same for the impacts of climate change. 1 The last addition to our model is two variables: consumption (in trillion dollar) and per capita consumption (in dollar per person). The equation for consumption is straightforward: whatever is left of gross output once the costs of abatement, the damages from climate change and investment in the capital stock are subtracted can be consumed and thus equals consumption. To compute per capita consumption you divide consumption by population. Be careful with the units, though! Part II: Policy Analysis Question 1: Find out in which year the net change in per capita consumption from four different policies turns beneficial. All the policies you should analyze are characterized by a constant reduction in emissions, i.e. the same percentage reduction in each year. The four policies you should analyze are a 10%, 20%, 30% and 40% emission reduction. For each policy, compute how the per capita consumption in each year changes compared to the no-policy scenario. For each policy, find the first year in which per capita consumption is higher with policy compared to the no-policy case. Question 2: Create a graph that plots the change in per capita consumption for all four policies, one that plots abatement costs as percent of output and one that plots damages as percent of output. The horizontal axis should be years in all three figures. The vertical axes should be percentage change in per capita consumption for the first figure, and percent of output for the second and third figure. Each policy should be one line in each figure. Section 2: Income Elasticity Part I: Modeling Now, we will add a slight twist to the damage function. Above, we had assumed that a given temperature increase would always cause the same loss as a share of income, independently of the level of income. So whether we assumed a high income or a low income, a 3º warming would always cause the same loss as a percent of income. You will replace that damage function with one that has an additional parameter, namely an income elasticity of impacts. We can specify a more nuanced relationship between economic impacts and income levels with this new parameter. You should change the damage function equation from last week to the following format (the new term is marked in the equation): € Dt = VT2 new (1) 2 Yo should be set to gross income in the base year of the model, i.e. GDP in the year 2010. Yt is gross income in year t, and e is called an income elasticity, which you should set to 0 for the base case. e is the parameter you will vary in the second part of the exercise. Part II: Policy Analysis Question 1:How do damages in dollar terms change compared to the model that does not include income elasticity if you set the income elasticity to -0.25, 0.0 and 0.25? You should create a new copy of your model for each of these three cases (one Excel sheet for each). You should then add as another sheet the model from above. Finally, on a new sheet, create a graph that plots damages in dollars for each of these four cases over time (section one's model, and the three models with different income elasticities you created in section two). Write one short sentence (in Excel) for each of the three income elasticity cases that describes how damages differ from the damages in the section one of this assignment. 3 C104 X V fx =$B$96*C100^2 *(C101/$B$101) A Formula Bar D E F G H 1 K L 1 2 Year 2011 2012 2013 5.854 2014 5.808 2015 5.760 2016 2017 2018 5.606 5.551 5. 3 Variable Name 2010 5.980 5.940 5.898 5.711 5.660 18.620 18.602 18.584 18.568 18.553 18.538 18.524 18.511 18.499 18.487 18 67 Energy Intensity (EJ/trillion $ of output) 68 69 Carbon Intensity (MtC/EJ) Gross Output ($ trillion) 190.025 195.260 200.465 205.638 210.783 215.901 220.997 226.073 231.133 236.180 241. 70 Kaya Emissions (Mt C) 71 Total Emissions (Mt C) Emissions with policy (Mt C) Abatement cost (% of output) Abatement cost ($ tillion) 2019 2 6530.537 6619.145 6706.909 7842.909 7842.909 7640.537 7742.145 7742.145 6793.616 6879.054 8041.054 8041.054 7942.616 7942.616 6963.008 8138.008 8138.008 0% 8233.267 8233.267 0% 7045.267 7125.618 7203.853 7279.765 7353. 8593. 8326.618 8417.853 8506.765 8326.618 8417.853 8506.765 8593. 72 73 74 75 7640.53674 0% 0% 0% 0% 0% 0 0 0 0 0 0 0 0% 0 0% 0 0% 0 76 Solow Growth Model 77 Parameters Capital Share Depreciation Rate Savings Rate 30% 10% 22% 78 79 80 81 82 Forcings Total Factor Productivity 0.0275 0.0279 0.0283 83 84 0.0287 0.0291 0.0294 0.0298 0.0301 0.0304 0.0307 0.0 85 Variables 86 Investment (trillion S) 41.7252 139.6500 167.4102 190.0246 195.2605 200.4645 195.2605 205.6380 210.7827 -30.9870 27.8503 200.4645 6.8381 -12.7280 -1.776446 -4.272608 42.9573 44.1022 193.6264 45.2404 218.3660 205.6380 46.3722 241.7698 210.7827 47.4983 263.9650 215.9013 285.0668 220.9969 226.0728 231.1327 236.1804 87 Capital Stock (trillion $) Gross Output (trillion $) 89 Net Output (trillion) 90 Consumption ($ tril) 91 Consumption per capita ($ per person) 48.6193 49.7360 50.8492 51.9597 53.0 305.1794 324.3975 342.8069 360.41 241.2 189.6598 50.0098 215.9013 220.9969 -64.0699 48.0637 -6.548475 -8.627344 226.0728 -79.1066 -10.52993 231.1327 -93.2648 -12.27471 236.1804 241.2 -119.21 -13.87813 -15.35 92 -106.6265 7.24779639 3.985116 0.966258 93 Impact component 94 95 Parameters coefficient on temp squared (psi) Income Elasticity 0.003 0 96 97 98 99 Forcings 100 global average temperature in ℃ above pre-industrial levels 101 Gross Output ($ Tril) 0.8 190.0246 0.819071 195.2605 0.83813 200.4645 0.857177 205.6380 0.876215 210.7827 0.895244 215.9013 0.914266 220.9969 0.933281 226.0728 0.95229 231.1327 0.971294 236.1804 241.2 0.00192 0.36484731 0.002068 0.403816 0.002223 0.445666 0.002385 0.490523 0.002303 0.990 102 103 Variables 104 Damages (% of Output) 105 Damages ($ Trill) 106 107 108 109 0.002404 85487 0.51911 0.002508 0.554182 0.002613 0.590737 0.002721 0.628813 0.00283 0.668446 0.002 0.709See Answer
  • Q4:The objective of this assignment is to introduce you to the basic features and functionalities of Microsoft Excel, including entering data, basic calculations, formatting, and creating simple charts. Instructions: Open Microsoft Excel on your computer. Create a new blank workbook to complete the following tasks. Save your workbook as "Excel_Beginner_Assignment" or a similar name. Complete the tasks described below. Save your work frequently as you progress. Task 1: Entering Data In cell A1, type "Product Name". In cell B1, type "Price". Enter the following data in cells A2:A6: "Item 1", "Item 2", "Item 3", "Item 4", "Item 5". Enter the corresponding prices in cells B2:B6: 10, 20, 15, 25, 30. Task 2: Basic Calculations In cell C1, type "Total Price". In cell C2, write a formula to calculate the total price for "Item 1" by adding the price in cell B2. Use the fill handle to apply the formula to calculate the total prices for "Item 2" to "Item 5". Task 3: Formatting Select the range A1:C1. Apply bold and center alignment to the selected cells. Format the range A2:A6 as a bulleted list. Task 4: Creating a Chart Select the range A1:B6, including headers and data. Go to the "Insert" tab in the Excel ribbon. Choose a "Column Chart" (a simple vertical bar chart). A chart should appear on your worksheet. Move and resize the chart as needed. Task 5: Saving and Submission Save your workbook. Create a PDF version of your workbook for submission. File -- Save as --. pdf Task 6: Explore one other feature not described in the task list (perhaps something on the menu bar, something you read about in the text, or something described in the Help tab). Highlight this feature/addition to your document. Write a few sentences about what you chose and why. What did you learn in the process? Or still want to explore? Additional Challenge, 2 Bonus Points Possible (Optional): Modify the chart title, axis labels, and data labels to make the chart more informative and visually appealing.See Answer
  • Q5:Excel Assignment 2 Download the article “Vigilant Spreadsheet” AND Excel Assignment Summer 2024 file from EMU Canvas Excel Skills: Sorting, SUMIF, COUNTIF, and Conditional Formatting Add the conditional formatting (on the home tab) to the information in the Part 1 tab: Column C – Area in sq miles – less than 10,000 Column E – Males per 100 females - between 95 and 99. Choose a different formatting than “1a” above. Column G – Percent not covered by health insurance –top 10% using the “top/bottom rules”. Choose a different format than 1a and 1b. In cell J53 use the COUNTIF function to count the number of states that have “Percent of Population over 65” (column J) less than or equal to 12 percent. Format with no decimal places. In cell L53, use the SUMIF function to sum the total number of births (column L) if a state has greater than or equal to 200,000. Format with “,” and no decimal places. In cell M53, use the SUMIF function to sum the number of marriages (column M) if the state is in the Midwest region. Go to the Part 2 tab and sort this spreadsheet once. Using the custom sort, the first sort should be descending order by Region (Column B) with the second sort should be State (Column A) in ascending order. Save your spreadsheet and call it “yourlastnameExcel2” Upload your completed spreadsheet into Canvas.See Answer
  • Q6:When thinking about spreadsheet models, simulations and summarizing information the person reviewing the data along with those making decisions have to consider the risks analysis. Select a company of your choice to consider what data they may need to analyze a problem they may be trying to solve. Discuss the following: What Excel function can be used to support simulations for risk analysis? Based on the company selected and problem you want to solve, what data would they need to address the concerns using the risk factors of best and worst-case scenarios? What parameters and information would you use for validation and verification? The posting should consist of no less than 300 words and should incorporate at least one outside, i.e., from a library database search, APA formatted reference at the end of the post.See Answer
  • Q7: Grader - Instructions Project Description: You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are performed. You started a worksheet that lists the number of seats in each section (orchestra and the tiers) and the number of seats sold for a specific performance date. You will calculate the percentage of sold and unsold seats and gross revenue by section. You will format the worksheet to improve readability and copy the final worksheet to use as a template to enter data for the next day's performance. Steps to Perform: Step 1 2 3 4 5 6 7 8 Exp19_Excel_Ch01_Cap_Ticket_Sales 9 Instructions Start Excel. Download and open the file named Exp19_Excel_Ch01_Cap_TicketSales.xlsx. Grader has automatically added your last name to the beginning of the filename. Centering the title Sugarhouse District Theatre over the data columns, increasing the font size, and applying a different font color will make it stand out as a title. Merge and center the title over the range A1:G1, change the font size to 20, and apply Purple font color. You want the performance date to display, including the weekday, centered below the title. Type 4/16/2021 in cell A2, apply the Long Date number format (which includes the day of the week), apply the Note cell style, and merge and center the date over the range A2:G2. Now that you have formatted the worksheet, you need to select margin settings so that any printouts you make will look professional. Set a 1" top margin and center the worksheet horizontally between the left and right margins. Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. You want to insert a new row for Orchestra Back. Insert a new row above row 9, between Right and Left. The new row is row 9. Copy the data from cell A5 to cell A9 and change the data in cell A9 from Front to Back. Indenting the specific seating sections will distinguish the specific section locations from the main section headings. After indenting text, the column needs to be widened to display the text. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17. Then change the width of column A to 18. The column heading in cell A4 is formatted. You want to copy those formats to the other headings on row 4. Use Format Painter to copy the formats in cell A4 to the range B4:G4. Wrapping text within each cell will improve the readability of the column headings. Wrap text and horizontally center the labels in the range A4:G4 and set the height of row 4 to 30. I Points Possible 0 5 6 5 6 5 6 2 4 Grader - Instructions Step 10 11 12 13 14 15 16 17 18 19 Instructions You decided to change the word Purchased to the word Sold. Use Find and Replace to find all occurrences of Purchased and replace them with Sold. The worksheet contains spelling errors that need to be corrected. Check the spelling in the worksheet and correct all spelling errors. Enter the formula to calculate the percentage of seats sold for the performance. Calculate the Percentage Sold in cell E6 by dividing the Seats Sold by the Seats in Section. Copy the formula to the range E7:E17. Delete the formula in cells E9 and E13 since those are empty rows. Enter the formula to calculate the percentage of seats not sold. Calculate the Percentage Not Sold in cell F6 by subtracting the Percentage Sold from 1. Copy the formula to the range F7:F17. Delete the formula in cells F9 and F13 since those are empty rows Enter the formula to calculate the gross revenue from the seats that were sold. Calculate the Gross Revenue in cell G6 by multiplying the Seats Sold by the Price Per Seat. Copy the formula to the range G7:G17. Delete the formula in cells G9 and G13 since those are empty rows. Formatting the monetary values in the Price Per Seat and Gross Revenue columns improves the readability. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17. The formula results in the Percentage Sold and Percentage Not Sold columns are hard to read as decimal values. Formatting the results to display percent symbols will improve the readability. Apply Percentage Style with one decimal place to the range E6:F17. After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data. Insert a new column G. Select and move the range D4:D17 to the range G4:G17. Delete the empty column D. You want to center the values in the Seats in Section and Seats Sold columns. Center horizontally the data in the range B6:C17. Apply Align Right and indent twice the data in the range D6:E17. Borders will help people distinguish different seating sections. Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time. 2 Points Possible 3 2 4 4 4 5 5 5 10 8 Step 20 21 22 Instructions Rename Sheet 1 as 4-16-2021. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021. You want to use the duplicate worksheet to be ready to enter data for the April 17 performance data. Change the date in cell A2 to 4/17/2021. Keep the Long Date Format. Delete the values in the range C6:C17. Save and close Exp19_Excel_Ch01_Cap_TicketSales.xlsx. Exit Excel. Submit the file as directed. Total Points Points Possible 5 6 0 100See Answer
  • Q8: ENGR 1301 Engineering Practices Lab LAB EXERCISE 4 (Sorting Lists Prof M. Lewis Use Excel to Create and Sort Lists 1. OPEN A NEW EXCEL WORKSHEET 1.1. Worksheet headings are the following; 1.2. Title 1.3. File name 1.4. Your name 1.5. Date TITLE 2. SET UP A FICTITICIOUS LIST 2.1. In column A insert numbers 1 to 10 2.2. Enter 10 fictitious random names and corresponding data in separate columns starting at column B through column K as follows; 2.2.1. Last name 2.2.2. First name 2.2.3. Middle initial 2.2.4. Address number 2.2.5. Address Street name 2.2.6. City 2.2.7. State 2.2.8. Zip Code 2.2.9. Phone number 2.2.10. Email address 2.3. Use the above list as the column headings. 2.4. Save this initial worksheet file as the file name given above. PRINT THIS. (see 3.7) 3. DATING SORTING OPERATIONS 3.1. Highlight the 11 columns [columns A to K] [but not the column headings]. 3.2. Click on the "DATA" tab in the toolbar. 3.3. Then just to the right and below the "DATA" tab, you will see the word "SORT". Click on "SORT". 3.4. A menu box appears that asks you to indicate which column to sort on and in what order {ASCENDING OR DECENDING}. 3.5. Select to sort on the column corresponding to the last name and in ascending order. Click "OK". 3.6. Now the data set is in alphabetical order by last name. PRINT THIS, (see 3.7) 3.7. Note: You will need to print this entire worksheet {all 11 columns} on a single page in "Landscape". For this to fit on the page, you may need to set the font to 10 (or 9). 3.8. Select [highlight] the data set contained in the 11 columns. Click the right mouse button, and on the drop-down menu select"COPY". 3.9. At one or two rows below the data set, "PASTE" in the copy of the data set. Now you have two copies of the sorted data. Again select[ highlight] the upper data block again from columns A to K. Again select "DATA" and then "SORT" and this time sort on column A [ the numbers 1-10] in ascending order. Click "OK". 3.10. Note that the upper data block is now returned to the original unsorted format. 4. SORT DESCENDING 4.1. Select [highlight] the 11 columns of unsorted data. Select "COPY". 4.2. Open worksheet "Sheet 2". Do a "PASTE" on worksheet 2. 4.3. Copy and paste the column headings from sheet 1 to sheet 2. 4.4. Select the 11 data columns on sheet 2. 4.5. Do a "SORT" with the last name in "descending" order. 5. SELECTING COLUMNS 5.1. Select the 11 data columns on sheet 2 and "COPY". 5.2. "PASTE" this two rows below the first block of data on sheet 2. 5.3. "COPY" and "PASTE" in the column headings. 5.4. Select the 11 data columns from the second block of data on sheet 2. 5.5. Do a "SORT" by "city" column in "descending" order. 6. SORTING BY MULTIPLE FIELDS 2 6.1. Now create a data set that is sorted by state, city and then last name. 6.2. "COPY" a data block to worksheet 3. 6.3. Open the sort instructions dialog box. 6.4. Select sort on the column containing the 'state' data. 6.5. Then click on "ADD Level" in the dialog box. Add the column containing the city' data. 6.6. Again click on "ADD Level" in the dialog box. Add the column containing the last name'. 6.7. Click OK. 6.8. Note that the data block has been correctly sorted. 7. LAB EXERCISE 4 REPORT GUIDELINES 7.1. For the "DATA' section, include the worksheets with the unsorted data block and the various sorted data blocks. Put in a heading for each data block indicated the sorting criteria. 7.2. For the "SUMMARY AND CONCLUSIONS" section, explain the significance of each of the sorting options used and how they would be useful in general and the use of column A. IMPORTANTSee Answer
  • Q9:/n Instructions: Review the CPS Wage data which is posted in the Week 2 course materials. As discussed in the Week 4 Lecture Notes, the variable Occupation is coded incorrectly. As directed in the lecture notes, please recode the Occupation variable into 5 new variables. Are there any other variables that need to be recoded? Please note any re-coding and discuss your decision on the Description of Data tab/worksheet. Compute descriptive statistics on all of the continuous variables. Compute the frequencies on AT LEAST ONE of the categorical variables. Run a correlation table. The descriptive statistics, frequencies and correlation table should be professionally presented on separate, labeled tabs/worksheets. Need to be done using EXCEL. Please use grading rubric to complete this assignment.See Answer
  • Q10:2. (16 Points) Using Excel (this is a requirement), please create a scatterplot graph/chart of the turkey population in New Hampshire from 1965 until 2020 using the data below. Make sure to include axis labels and a title. Year NH Turkey Population 1965 1970 1975 1980 1985 1990 1995 2000 2005 2010 2015 2020 0 30 25 278 1417 12340 19015 28945 37343 42672 40123 Please include an image of your chart hare:See Answer
  • Q11: New Perspectives Excel 2019 | Module 7: End of Module Project 1 Pierce Software SUMMARIZE DATA WITH PIVOTTABLES sam GETTING STARTED Open the file NP_EX19_EOM7-1_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_EOM7-1_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_EOM7-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. 2. 3. 4. 5. Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has been keeping track of the support calls the center receives, and asks for your help in analyzing the data. Go to the Customer Call Log worksheet, which contains the Calls table where Tiana has been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E5, enter a formula using the HLOOKUP function to look up the call type according to the call code. Use a structured reference to look up the value in the Call Code column of the Calls table. Retrieve the value in row 2 of the CallTypes table (range A3:F4 in the Survey Questions worksheet) using a structured reference to the entire CallTypes table. Because each call type covers a range of values, find an approximate match. Fill the formula into the range E6:E143, if necessary. Customers can rate their service representative by completing a four-question survey at the end of each call. Tiana entered the scores in columns Question 1, Question 2, Question 3, and Question 4 of the Calls table. She wants to calculate the average rating for each call in the Average column. In cell J5, enter a formula using the AVERAGE function and structured references to average the values in the Question 1 to Question 4 columns of the Calls table. Fill the formula into the range J6:J143, if necessary. In the range L4:N13, Tiana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell M5, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting. Tiana also wants to average the combined scores for each employee. In cell N5, enter a formula using the AVERAGEIF function and structured references to the Service Rep and Average columns in the Calls table to average the scores Barry (cell L5) received for all the calls he handled. Fill the formula into the range N6: N13 without formatting. Go to the Call Type by Rep worksheet. Tiana wants to compare the call data by type for each service rep. In cell A3, insert a PivotTable based on the Calls table. Use RepCalls CENGAGE New Perspectives Excel 2019 | Module 7: End of Module Project 1 6. 7. 8. 9. as the name of the PivotTable. Display the service rep names as column headings, and the call types as both row headings and values. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to coordinate with the table on the Customer Call Log worksheet. Center the data in the range B4:K10 to make it easier to read. Tiana notices that Service Rep Bruno has no calls in the How to category, which she knows is incorrect. Return to the Customer Call Log worksheet, and then change the Call Code in cell D10 to 12, which assigns a call to Bruno in the How to category. Go to the Call Type by Rep worksheet and refresh the data in the PivotTable. Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table. Use Scores as the name of the PivotTable. Display the Date values as column headings, which automatically groups the data by month. Display the Service Rep names as row headings and the Average score data as values. Change the summary function to Average for the data in the Values area and apply the Number number format with 2 decimal places to those values. 10. In cell A3, use the text Average Scores to identify the values. In cell B3, use the text Months to identify the column headings. In cell A5, use the text Service Reps to identify the row headings. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to match the other PivotTable. 11. Tiana wants to focus on scores for calls involving technical problems in February. Create a slicer for the Scores PivotTable based on the Call Type field. Resize the slicer to a height of 2.5". Move the slicer so its upper-left corner is in cell F3 and its lower-right corner is in cell G14. Use the slicer to filter the Scores PivotTable by the Tech problem call type. 12. Create a timeline slicer based on the Date field in the Scores PivotTable. Resize the timeline slicer to a width of 7". Move the slicer so that its upper-left corner appears within cell A16 and its lower-right corner appears in cell G23. Use the timeline slicer to show data for February only. 13. Resize columns B:C to 12.00 and center the data in the range B3:C15. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. CENGAGE New Perspectives Excel 2019 | Module 7: End of Module Project 1 Final Figure 1: Customer Call Log Worksheet A B D E G J K L M N 0 Pearce Software 2 Customer Call Log: January-March 3 Customer Survey Scores Question Question Question Question 4 Call ID ▾ 5 20191 Date ▾ Service Rep▾ 1/4/2021 Wagner Call Code ▾ Call Type▾ 1 ▾ 2 3 4 Average ▾ Rep Total Calls Average Score 7 Feature request 4 5 2 4 3.75 Barry 20 3.65 6 20154 1/4/2021 Thanh 1 Bug report 2 1 3 1 1.75 Bruno 20 3.35 7 21170 1/4/2021 Darego 17 Tech problem 5 5 5 5 5.00 Calder 15 3.60 8 21145 1/5/2021 Calder 16 Tech problem 4 5 3 5 4.25 Darego 13 3.71 9 22103 1/5/2021 Shanahan 21 Cancellation 4 4 4 4 4.00 Shanahan 12 3.25 10 22246 1/6/2021 Bruno 12 How to 4 5 3 4 4.00 Thanh 26 3.41 11 22137 1/7/2021 Thanh 7 Feature request 3 3 3 3 3.00 Volmann 9 3.89 12 22234 1/7/2021 Shanahan 1 Bug report 2 1 1 1 1.25 Wagner 7 3.04 13 23228 1/7/2021 Wagner 2 Bug report 3 2 2 1 2.00 Zimmerman 17 3.46 14 23215 1/8/2021 Calder 8 Feature request 4 3 3 2 3.00 15 24117 1/9/2021 Darego 25 Cancellation 5 5 3 5 4.50 16 24140 1/9/2021 Bruno 9 Feature request 3 3 3 2 2.75 17 25224 1/11/2021 Thanh 3 Bug report 4 5 4 4.25 18 23126 1/12/2021 Volmann 2 Bug report 5 5 5 4.75 19 25210 1/12/2021 Barry 12 How to 3 2 2 1 2.00 20 20189 1/14/2021 Wagner 21 Cancellation 1 1 1 1.00 21 20126 1/14/2021 Shanahan 20 Tech problem 3 4 2 3.25 22 26157 1/15/2021 Bruno 22 Cancellation 2 3 2 2.25 23 25201 1/16/2021 Thanh 16 Tech problem 4 4 3.50 Documentation Customer Call Log Call Type by Rep Scores by Date Survey Questions (+ Final Figure 2: Call Type by Rep Worksheet A B C D E F G H I ] K L Per Pierce Software 2 Call Types by Service Rep 3 Count of Call Type_Column Labels ▾ 4 Row Labels 5 Bug report ☑ Bruno Calder Darego Shanahan Thanh Volmann Wagner Zimmerman Grand Total Barry 5 5 4 4 1 7 2 1 35 6 Cancellation 7 Feature request 8 How to 3 4 3 1 3 2 2 2 20 3 3 2 1 1 5 1 16 6 1 1 1 1 2 2 3 17 9 Tech problem 3 7 5 6 6 10 3 3 8 51 10 Grand Total 20 20 15 13 12 26 9 7 17 139 11 12 13 14 15 16 17 18 19 Documentation Customer Call Log Call Type by Rep Scores by Date Survey Questions + ་ CENGAGE New Perspectives Excel 2019 | Module 7: End of Module Project 1 Final Figure 3: Scores by Date Worksheet A B 1 Pierce Software D E F G 2 Average Monthly Scores 3 Average Scores 4 Months Call Type + Feb Grand Total 5 Service Reps Bug report 6 Barry 4.50 4.50 7 Bruno 4.25 4.25 8 Calder 3.63 3.63 Cancellation Feature request 9 Darego 3.33 3.33 How to 10 Shanahan 3.08 3.08 11 Thanh 3.67 3.67 Tech problem 12 Volmann 4.00 4.00 13 Wagner 2.75 2.75 14 Zimmerman 2.88 2.88 15 Grand Total 3.46 3.46 16 Date 17 Feb 2021 18 2021 19 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 20 22221 23 Call Type by Rep Scores by Date Survey ... + ་ CENGAGE MONTHS ▾ New Perspectives Excel 2019 | Module 7: End of Module Project 1 Final Figure 4: Survey Questions Worksheet A B C D E F G 1 Pierce Software 2 Call Type Lookup Table 3 Call Code 0 6 11 16 4 Call Type Bug report Feature request How to Tech problem 21 Cancellation 5 6 Customer Survey Scores 63892 Very satisfied 7 5 4 Satisfied 3 Neutral 10 2 Dissatisfied 11 1 12 Very dissatisfied 13 Customer Survey Questions 14 How satisfied are you with: 16 Question 2 15 Question 1 The service rep's product knowledge How much time it took to reach a service rep The overall process of contacting Pierce Software How the service rep handled your call 17 Question 3 22222 20 21 18 Question 4 19 Documentation Customer Call Log Call Type by Rep Scores by Date Survey Questions CENGAGESee Answer
  • Q12: Tab 1: #1. Using the 1st tab of the starter file and Goal Seek. Set the initial field values to: Unit Cost: $6.00 If our goal is for the Contribution Margin Percent to be 54%, Invoke Goal Seek so as to figure out what the Sales Price (changing cell) is and the answer is $ #2. Using the 1st tab of the starter file and Goal Seek Set the initial field values to: Sales Price: $13.00 If our goal is for the Contribution Margin Percent to be 53%, Invoke Goal Seek so as to figure out what the Unit Cost must be (changing cell) and as a result, the automatically re-calculated Contribution Margin is $_ Tab 2 - Monthly Payments #3. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $1,000 • APR: 5.0% • Term (in Years): 5 • Loan Amount: 30,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the monthly payment is #4. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $2000 • APR: 6.0% • Term (in Years): 6 • Loan Amount: 40,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.50% - the monthly payment is Tab 2-Total Payments #5. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $1,000 • APR: 5.0% • Term (in Years): 5 • Loan Amount: 30,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the total payments are #6. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $2000 • APR: 6.0% • Term (in Years): 6 • Loan Amount: 40,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 6.25% - the total payments are Tab 3 - Monthly Payments #7. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Monthly Payment amount Set the Loan Conditions to the following: • Down Payment: $25,000 • APR: 5.25% • Term (in Years): 30 • Loan Amount: 175,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question: If the APR is 6.75% and the term is 120 (months) - the monthly payment is #8. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Monthly Payment amount Set the Loan Conditions to the following: • Down Payment: $11,000 • APR: 4.85% • Term (in Years): 20 • Loan Amount: 225,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question: If the APR is 8.85% and the term is 360 (months) - the monthly payment is Tab 4 - Total Payments #9. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Total Payments amount (cell C9) Set the Loan Conditions to the following: • Down Payment: $20,000 • APR: 5.50% • Term (in Years): 25 • Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.50% and the term is 240 (months) - the total payments made is #10. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Total Payments amount (cell C9) Set the Loan Conditions to the following: • Down Payment: $20,000 • APR: 5.50% • Term (in Years): 25 • Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.00% and the term is 360 (months) - the total payments made is/n Assignment Instructions Decision support systems (DSSS): Are computer-based information systems that combine models and data in an attempt to solve semi-structured and some unstructured problems with extensive user involvement. Objectives: Upon completion of this lesson, you will be able to: • Know what DSS stands for • Understand what DSS's are and what they can do for you • Identify the different categories of DSS's . . Understand how selected DSS tools within Excel work Demonstrate the use of the DSS tools within Excel by completing the assigned Homework Activity Step 1 - The 01_start_here.pdf is a copy of the slides about the excel dss tools for your convenience. Step 2 - Download the 02_dss_what_ifs_and_data_tables excel file so you can practice using the tools. Step 3 - Watch these Videos: Excel Goal Seek Links to an external site. Excel Data Tables Links to an external site. Excel Scenario Manager Links to an external site. Excel Solver Links to an external site. NOW that you have not only watched all the mini-lectures and hopefully tried it yourself to really understand what/where/how and so forth to master using that particular DSS tool...you are NOW better prepared to attempt the DSS Homework Assignment which has you using/doing ALL these tools! If you are using a MAC - Excel Solver behaves TOTALLY different and I'm not a Mac expert. My best advice is either figure it out on your Mac so you can say you DID or head to any campus computer lab using the PC version of Office wherein the instructions above will more closely match exactly how it works or appears (which is also true for ALL the other Excel DSS tools). Step 4 - Download 03_homework_starter_file and open it in excel Step 5 - Work through the attached worksheet (04) and submit it along with the excel file once you are completed. If you do not save the excel file AFTER you have done the calculations necessary for you to get the answers you will receive no more than half credit. MAKE SURE TO FILL OUT THE ANSWER SHEET. THAT'S WHERE I'LL BE LOOKING AT YOUR ANSWERS. Additional resources for assignment 01_start here.pdf Download 01_start_here.pdf 02 dss what ifs and data Tables.xlsx Download 02_dss_what_ifs_and_data_Tables.xlsx 03 homework starter file.xlsx Download 03_homework_starter_file.xlsx 04_homework_instructions_and_answer_sheet.docx/n/nSee Answer
  • Q13: New Perspectives Excel 2019 | Module 8: End of Module Project 1 Four Winds Energy PERFORM WHAT-IF ANALYSES sam GETTING STARTED Open the fileNP_EX19_EOM8-1_FirstLastName_1.xlsx, available for download from the SAM website. Files downloaded from the SAM website are safe and do not contain viruses, but due to a recent Microsoft policy update, macros in downloaded files are disabled by default. To complete this project, you will need to enable macros in the file. To enable macros on this file: О о For PC: Open Windows File Explorer and go to the folder where you saved the file. Right-click the file and choose Properties from the context menu. At the bottom of the General tab, select the Unblock checkbox and select Apply, and then click OK. For Mac: If a dialog box about macros appears, click Enable Macros. Save the file as NP_EX19_EOM8-1_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_EOM8-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. о If cell B6 does not display your name, delete the file and download a new copy from the SAM website. This project requires you to use the Solver add-in. If this add-in is not available on the Data tab in the Analyze group (or if the Analyze group is not available), install Solver as follows: о In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver. PROJECT STEPS 1. Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San Antonio, Texas. Madhu is developing a workbook to analyze the profitability of the company's wind turbines. She asks you to help her analyze the sales data to determine how the company can increase profits. Go to the Income Analysis worksheet, which lists the revenue and expenses for the Boreas wind turbine and calculates the net income. Madhu wants to compare the financial outcomes for varying amounts of turbines sold and identify the number of units the company needs to sell to break even. Madhu has already entered formulas in the range E5:H5 to extract data from the income analysis in the range B4:C26. In the range E5:H14, create a one-variable data table using cell C5 as the Column input cell, to calculate the revenue, expenses, and net income based on units sold. CENGAGE New Perspectives Excel 2019 | Module 8: End of Module Project 1 2. 3. 4. 5. Madhu asks you to provide a visual representation of the break-even data. Create a Scatter with Straight Lines chart based on the units sold, revenue, and expenses in the data table (range E4:G14). Resize and position the chart so it covers the range 13:N15. Madhu wants to clarify the purpose of the chart and focus on the areas containing data. Use Break-Even Point as the chart title. Change the Minimum bound of the horizontal axis to 2,500 and let the Maximum bound adjust automatically. Change the Minimum bound of the vertical axis to 2,000,000 and let the Maximum bound adjust automatically. Madhu also wants to examine how varying sales price and volume affects net income from wind turbines. She has already entered the net income in cell E18 and sales prices in the range F18:J18. For the range E18:J27, create a two-variable data table using the price per unit (cell C6) as the Row input cell and the units sold (cell C5) as the Column input cell. In cell E18, create a custom number format that displays "Units Sold" instead of the net income value. Madhu has also created two scenarios in the Income Analysis worksheet. The Current scenario assumes the current values for units sold, price, and fixed expenses (salaries and benefits, distribution, and miscellaneous). The Lower Price scenario assumes more units sold at a lower price. She also wants to create a scenario that assumes fewer units sold at a higher price. Create a scenario using the data shown in bold in Table 1 without applying any scenarios. Table 1: Income Analysis Scenario Values Scenario name Changing cells Units sold (C5) Price_per_unit (C6) Salaries_and_benefits (C18) Distribution (C19) Miscellaneous (C20) Raise Price C5:C6, C18:C20 4500 1239 800000 510000 300000 6. 7. 8. 9. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Lower Price, and Raise Price scenarios. Use the total revenue, total expenses, and net income in the range C24:C26 as the result cells. Go to the Scenario Summary worksheet and delete column D, which repeats the current values. Return to the Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income (range C24:C26) for each scenario. Go to the Scenario PivotTable worksheet. Madhu wants to make the PivotTable easier to interpret. Remove the filter from the PivotTable. Use Total Revenue as the row label in cell B3, use Total Expenses as the row label in cell C3, and use Net Income as the row label in cell D3. Display the Revenue, Expenses, and Net Income values in the Currency number format with no decimal places. Display negative values in red, enclosed in parentheses. Resize columns B:D to their best fit using AutoFit. Madhu also wants to compare the three scenarios in a chart. Create a Clustered Column PivotChart based on the PivotTable. Resize and position the chart so it covers the range A8:E24. CENGAGE New Perspectives Excel 2019 | Module 8: End of Module Project 1 10. Go to the Product Line worksheet, which lists three wind turbines that Four Winds Energy produces and sells. Madhu wants to find the product mix that generates the most net income for the company. Use Solver to maximize the percentage of difference between the even and optimal product mixes (cell F23) by changing the optimal product mix (range C10:E10) subject to the following constraints: ' . The total units sold in the optimal product mix (cell D18) must be 4,750. · The company needs to produce 1,200 or more of each turbine model, so the optimal mix values for each model (range C10:E10) must be at least 1,200. Those same values in the range C10:E10 must be integers. The Remaining values for each assembled part (range J5:J13) must be greater than or equal to zero because the company cannot produce more wind turbines than the parts available. 11. Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range H17: H24, and then close the Solver Parameters dialog box. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. CENGAGE New Perspectives Excel 2019 | Module 8: End of Module Project 1 *Final Figure 1: Scenario Summary Worksheet 1 2 1 - N 12356788 + | י A B Scenario Summary Changing Cells: Units_sold C D E F G Current Lower Price Raise Price Price_per_unit 4,750 $1,139 5,000 $1,039 4,500 $1,239 Salaries_and_benefits $ 833,500 $ 833,500 $800,000 9 Distribution 10 Miscellaneous 11 Result Cells: 12 Revenue 535,000 550,000 510,000 310,000 325,000 300,000 5,410,250 5,195,000 5,575,500 13 Expenses 5,193,500 5,408,500 4,940,000 14 15 16 Net_income $216,750 $ (213,500) $635,500 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. 17 18 19 20 Documentation Scenario Summary Scenario PivotTable Income Analysis Product Line CENGAGE New Perspectives Excel 2019 | Module 8: End of Module Project 1 Final Figure 2: Scenario PivotTable Worksheet A B с D E F G 12345678927 10 Row Labels Total Revenue Total Expenses Net Income Current Lower Price 6 Raise Price $5,410,250 $5,195,000 $5,575,500 $5,193,500 $216,750 $5,408,500 ($213,500) $4,940,000 $635,500 Total Revenue Total Expenses Net Income $6,000,000 11 12 $5,000,000 LLL 13 $4,000,000 14 15 $3,000,000 16 17 $2,000,000 18 19 $1,000,000 20 21 22 ($1,000,000) 23 $C$5:$C$6, $C$18: $C$20 24 25 26 $0 Current Lower Price Raise Price Values ■Total Revenue ■Total Expenses ■Net Income Documentation Scenario Summary Scenario PivotTable Income Analysis Product Lir CENGAGESee Answer
  • Q14:need an excel file created indicating Official UNESCO or World Bank data on: government expenditure on primary education as a percentage of GDP 2003 -2023 the info can be downloaded from UNESCO or the world Bank we should look for the data for worldwideSee Answer
  • Q15: Assessment 2: Group Practical Assignment - MS Excel /MS Word (40%) Due Date: March 20, 2024, 11:59 PM EC/ 10:59 PM JA As members of the Customer Service Department within your organization, your team members and you are expected to review feedback provided by a small group of customers related to their experience with your company. Customers were expected to rate services on a scale from 1 to 5, as follows: 1. Highly Satisfied 2. Satisfied 3. Neutral 4. Dissatisfied 5. Highly Dissatisfied This information was shared openly with the team by the customers, and entered into an MS Excel document for analysis. One year into business, Management wishes to get an idea of how well their products and services are meeting customers expectations as well as the impact on revenue and expenses since going digital. The company Digital Government Inc. recently opened its doors in 2022 and aids customers in completing various government transactions online, across one main office in the City, located at #33 Apricot Lane, Castries, St. Lucia. The company's primary objective is to use information and communication technology (ICT) as a tool to integrate public sector processes to improve services to citizens and businesses. Not only is this modality safe and efficient, but it also reduces the overall cost of Government operations. Having completed the analysis, the team is expected to share feedback with Senior Management to assist them in determining the way forward. Follow the components below to attain a greater understanding of the full requirements. The Customer Service Departments number and email address is (758) 454-DIGI and customerservice@digitalgovernment.inc The assignment consists of two (2) gradable components using Microsoft Excel and Microsoft Word applications which should be completed and submitted together. Each component carries with it several questions for which you are required to provide all solutions to fully maximize on mark potential. Please note that in some instances you are required to integrate features between applications. Download all related files. The completed MS Excel and MS Word files are to be submitted via the course website web tool (the Learning Exchange), using the following naming convention: Sub-Group #_open_s2_24xls – MS Excel file - Sub-Group #_open_s2_24wd1; - MS Word File 1 Sub-Group #_open_s2_24wd2; - MS Word File 2 Please note that “#” in the file names is to be replaced by your Sub-Group number. MS Excel Assignment Instructions For this part of the assignment browse through all worksheets before attempting the question. Using the Microsoft excel workbook assgt_mgmt1000_open_s2_24.xls complete the questions below to provide solutions for the senior management of Digital Government Inc, regarding their services: Using the "Results" worksheet: a. Provide the relevant formulas to calculate the average age of respondents accessing services at the company. Please format the values using zero decimal points. [4] b. Determine the average satisfaction level across all respondents using the appropriate function [4] c. Using the appropriate feature, dynamically apply the following formats to the necessary rows as follows: i. Dissatisfied customers, should be red and bolded [2] ii. [2] Highly Satisfied customers, should be green and italicized d. Complete using the “Satisfaction Level" worksheet, the distribution across satisfaction levels [4] e. Having completed question d above, create an exploded 3D pie chart in a new worksheet called “Satisfaction Levels Charts”. Include all relevant labels, titles and legends while changing the default colors. [10] f. Center the titles across the data below and bold and italicize the company name across the "Results" and "Income Statement” worksheets [4] Using the "Income Statement” worksheet: g. Complete the formulas in cells provided for revenues* for 2023. 2023 revenues have increased by 3.5% over 2022 values. [10] h. Having completed question (g) above, create a 3-D 100% stacked column chart representing the values across the 2 years for all revenue items with all relevant labels, titles and legend while changing the default colors. The chart is to be inserted on a separate worksheet, called “Revenue Chart Comparison” Hint: change the font size on the text areas on the chart to assist in resizing the chart. [10] i. Complete the formulas in cells provided for expenses for 2023. 2023 expenses have decreased by 1.5% over 2022 values [10] j. Having completed question (i) above, create a 3-D clustered column chart representing the values across the 2 years for all expense items with all relevant labels, titles and legend while changing the default colors. The chart is to be inserted on a separate worksheet, called "Expense Chart Comparison” Hint: change the font size on the text areas on the chart to assist in resizing the chart. [10] k. Using the correct function or formula calculate the total expenses and losses in the cells provided. [4] 1. Using all relevant cells calculate the income tax expenses for each year. m. Using the correct function or formula calculate the net income. [10] [2] n. Format the comparative income statement using dollars signs where necessary. All values are to have the thousand separator format with ZERO decimal places [4] o. Using functions, complete the "Aggregates” worksheet. (Hint: must use Income Statement worksheet") [3] p. Save your MS Excel workbook as Sub-Group#_open_s2_24xl for submission. For example Sub-Group 1_open_s2_24x1. MS World Assignment Instructions 1. Referencing your completed MS Excel assignment, prepare a brief report in the form of a letter, to be sent to ALL Senior Managers. In the introductory part of the letter: i. ii. iii. iv. Briefly inform these stakeholders of three (3) benefits of conducting customer surveys as a proactive approach to gathering feedback and improving the effectiveness of the new initiative and how Microsoft Excel made it easy to process the data to derive the information presented in the report. Briefly discuss the feature of MS Word being used to generate these reports. Identify two (2) benefits of this feature and why other Managers should aim to use it. Give a brief analysis of the data found in the pie chart as well as those found in the two column charts created (in your MS Excel assignment), considering the recent move to conducting government transactions online and include these graphics in the report. The report should be no more than 1000 words. Note that all employee internal contact information is located in the "Employee Department Contacts” MS Excel worksheet. Prepare the aforementioned by following the additional instructions below. 2. Prepare a professionally constructed letter using the Company name, Department Name, telephone number, and email address as provided in the instructions and a resized graphic of computer as part of the letterhead as relevant salutations. In addition, ensure requirements at points i. to iv. above are included. 3. All formatting stays at the default except for the following: [10] [30] i. Left and right margins : 0.5" ii. iii. Page numbers – bottom right e.g. “3 of 5” where “3” is the page number and “5” is the total number of pages. Page numbers should NOT be shown on first page The description "Customer Satisfaction Analysis for 2022/2023" in the left header. Header information should NOT be shown on first page iv. Your Sub-Group # in the right header. Header information should NOT be shown on first page V. "First line indent” on each paragraph e. c. Include, from your MS Excel assignment, a copy of the Results sheet. In one sentence briefly describe the figure copied in this letter [10] d. Complete the report as your main document using the Mail Merge feature in MS Word. Include and ensure that all necessary fields based on the requirements mentioned above are visible in your main document. Save the main document as Sub-Group #_open_s2_24_wd1 [20] Generate the required letters (to the persons mentioned above only) and save the generated file as Sub-Group #_open_s2_23_wd2. [20] f. Submit both documents along with your MS Excel file to the drop box for grading.See Answer
  • Q16:Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx data set using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required: 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Data: Alt Lab 1,3 Data.xlsx Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. Answer the following questions based on the details computed. Note: Round gross margin to 2 decimal places and gross margin percentage to 3 decimal places. Question 1. What is the gross margin (dollars) for SKU PED-T80? 2. What is the gross margin percentage for SKU PED-T80? 3. What was the highest gross margin percentage among all the SKU's? 4. How many total SKU's are there? 5. How many SKU's are in the 0.45-0.475 bin? AnswerSee Answer
  • Q17:GO! with Microsoft® Office 2019 Scripted Lecture for GO! with Microsoft Office 2019 Excel Chapter 1 Project 1B To the instructor: The notes below are provided for you to demonstrate to your students the skills they will practice when they create Project 1B. Although the skills and approach are identical to Project 1B, the content is different from the actual text. As necessary, refer to the steps in the text and Excel_1B_script_solution as your guide as you demonstrate. You may find it easier if you place the solution file on the desktop. Point out that the workbook should be saved after each activity. Activity Name Objective 7: Check Spelling in a Worksheet 1.18 Check Spelling in a Worksheet Demonstration Notes Start Excel and display a new blank workbook. • Save the workbook as Excel_1B_script_solution In cell A1: Type Western Mountains Warehouse and press Enter. Type Exercise Equipment Inventory In cell B3: Type Quantity and press Tab. Type Average Cost and press Tab. Type Retail Price and press Tab. Type Total Retail Value and press Tab. Type Percent of Total Retail Value and press Enter. In cell A4, type Traedmill with the text spelled incorrectly and then press Enter. In the range A5:A8 type the following row titles: Rowers Elliptical Trainers Exercise Bike Total Retail Value for All Products Adjust the width of column A to 220 pixels. Merge and Center the text in the range A1:F1 and then apply the Title style. Merge and Center the text in the range A2:F2 and then apply the Heading 1 style. Check Spelling for entire worksheet, making necessary corrections. Objective 8: Enter Data by Range 1.19 Entering Data by Range Select the range B4:D7. Pressing Enter after each entry with B4 as the active cell, type the following: 533 612 833 988 With cell C4 active, continue to type the following values, pressing Enter after each: Average Cost Retail Price 620 735 3350 4380 385 550 270 350/nObjective 9: Construct Formulas for Mathematical Operations 1.20 Using Arithmetic Operators 1.21 Tool 1.22 Using the Quick Analysis Copying Formulas Containing Absolute Cell References |In cell E4, type =b4*d4 Click in cell E4 and drag the fill handle down to cell E7. Point out that the cell reference can be typed in uppercase or lowercase. • Select the range B4:B7 and apply the comma number style with zero decimals. • Select the range E4:E7, point out that at the bottom of the screen, the values for Average, Count, and Sum are displayed. If necessary, select the range E4:E7. Using Quick Analysis from the Totals tab, click the first sum button. • Select the range C5:D7 and apply the Comma Style with zero decimals. Select the range C4:E4 and cell E8 at the same time. Apply the Accounting number format with zero decimals. In cell E8, apply the Total style. In cell F4, type = click cell E4 type / and then click cell E8. Double-click the formula in cell F4 to display the range finder. Drag the fill handle on cell F4 down through cell F7. Point to the Error Checking button to display the ScreenTip. Double-click the formula in cell F5 to show students the cause of the error. • Double-click the formula in cell F4, and use the F4 key to make the formula absolute so that the new formula is E4/$E$8. Drag the fill handle in cell F4 down to cell F7. Click in cell F5 to show the resulting formula. Objective 10: Edit Values in a Worksheet 1.23 1.24 Editing Values in a Worksheet Formatting Cells with the Percent Style • Click cell B5 and type 625 Before pressing Enter, point out that cells F5 and E8 will change. Press Enter and ask why this happened. • Double-click cell D5 and change the 8 to a 7 In cell A2, type a space and add the word Value to the right of the word Inventory. In cell B3, type a space and type on Hand after the word Quantity. Select the range F4:F7 and apply the Percent Style. Increase the number of decimals to show one decimal place and then Center the values. Objective 11: Format a Worksheet Inserting 1.25 and Deleting 1.26 1.27 Rows and Columns Adjusting Column Widths and Wrapping Text Changing Theme Colors Insert a new row above row 3. In cell A3, type As of June 30 Merge and Center the text across the range A3:F3. Apply the Heading 2 Style. Insert a new column to the left of Column B. In cells B4:B8, type City Medford Bend Corvallis •Delete column D. Select columns B:F and set the column width to 105 pixels. Select the range B4:F4, wrap the text, center and middle align the text, and apply the Heading 4 Style. Center the text in the range B5:B8. Apply Themed Cell Style 20% - Accent 5 to cell A9. Change the theme color to Red. • Change the orientation to landscape. In the Backstage view add exercise equipment, inventory to Tags, the subject should be your course name and section number and make sure the author is your name. Save and close the workbook and exit Excel.See Answer
  • Q18: New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project 1a NewSight Consulting ANALYZE DATA WITH TABLES AND WHAT-IF TOOLS sam GETTING STARTED Open the file NP_EX19_CS5-8a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_CS5-8a_FirstLastName_2.xlsx by changing the "1" to a "2". O If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: Support EX19_CS5-8a_2020.xlsx Support_EX19_CS5-8a_Management.docx With the file NP_EX19_CS5-8a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. This project requires you to use the Solver add-in. If this add-in is not available on the Data tab in the Analyze group (or if the Analyze group is not available), install Solver as follows: O In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver. PROJECT STEPS 1. Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to consumers in North America. In an Excel workbook, Benicio is analyzing the performance of each speaker model and projecting sales for a new product. He asks for your help in completing the analysis. Go to the U.S. worksheet. Benicio has received annual sales worksheets from the main offices in the three countries where DIG Technology sells products: the United States, CENGAGE New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project la Canada, and Mexico. The worksheets for the countries have a similar structure. Complete the worksheets as follows: 2. 3. a. Group the U.S., Canada, and Mexico worksheets. b. C. d. In cell F5, insert a formula using the SUM function that totals the Mini sales amounts for Quarters 1-4 (range B5:E5). Fill the range F6:F7 with the formula in cell F5 to display the totals for the other types of portable speakers. Ungroup the worksheets and then check to confirm that all three worksheets reflect the changes you made in this step. Go to the All Locations worksheet, where Benicio wants to summarize the quarterly and annual totals from the three locations for each type of product. Consolidate the sales data from the three locations as follows: a. In cell B5, enter a formula using the SUM function and 3-D references that totals the Mini sales values (cell B5) in Quarter 1 from the U.S., Canada, and Mexico worksheets. b. C. Fill the range C5:E5 with the formula in cell B5 to total the Mini sales for Quarters 2-4. Fill the range B6:E7 with the formulas in the range B5:E5 to total the sales for the other products in Quarters 1-4. Benicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales for each product. He wants you to add a defined name for the Waterproof sales amounts and then find the total annual sales for each product. Create and use defined names as follows: a. b. C. d. Create a defined name for the Waterproof sales amounts (range B7:E7) using Waterproof_Total as the name. In cell F5, enter a formula using the SUM function to display the total of the sales amounts in the Mini_Total range. In cell F6, enter a formula using the SUM function to display the total of the sales amounts in the Voice_Activated_Total range. In cell F7, enter a formula using the SUM function to display the total of the sales amounts in the Waterproof_Total range. CENGAGE New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project la 4. Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows: a. Open the workbook Support_EX19_CS5-8a_2020.xlsx. b. Return to the All Locations worksheet in the original workbook. C. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5). d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number. 5. e. Fill the range G6:G8 with the formula in cell G5, filling without formatting. Close the workbook Support_EX19_CS5-8a_2020.xlsx. f. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14: F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function. b. Use the Total Q1 sales (cell B8) as the value to look up. 6. 7. C. d. e. f. Use the Revenue Amts and Rating information (range $B$14:$F$15) as the table containing the lookup data, using absolute references to specify the range. Specify that row 2 contains the value you want to return, which is the performance rating. Specify an approximate match (TRUE) because the Revenue Amts represent ranges of values. Fill the range C12:E12 with the formula in cell B12 to enter ratings for Quarters 2- 4. In the range 13:L7, Benicio listed information about the managers of the DIG Technology main offices in the U.S., Canada, and Mexico. He needs to add a link to the email address of the U.S. manager. In cell L5, create a link to the tfenton@example.com email address without changing the display text. Benicio also wants to make it easy to access more detailed information about the managers, which he has stored in a Word document. Create a link to a file as follows: a. In cell 19, create a link to the Word document Support_EX19_CS5- 8a_Management.docx. b. Use Management Details as the text to display. C. Use Access manager details as the ScreenTip text. 8. Go to the Current Sales worksheet, which contains a table listing sales data for January, 2022. To make it easy to refer to the data, the table has been renamed "Sales". Benicio wants to use the table data in formulas. In column G, Benicio wants to indicate whether DIG Technology should send the CENGAGE New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project la 9. customer a promotional offer. Customers are eligible for the offer if they purchased a Mini 2 in the U.S. Provide the promotional offer information for Benicio as follows: a. b. C. d. In cell G5, start to enter a formula using the AND function and structured references. The first condition tests whether the value in the Product column ([@Product]) equals "Mini 2", the product eligible for the promotional offer. The second condition tests whether the value in the Location column ([@Location]) equals "U.S.", the location eligible for the promotional offer. If Excel does not fill the column, fill the range G6:G40 with the formula in cell G5. The Sales table is currently sorted by the values in the Sale ID column, but Benicio wants to sort the table by date, then amount to make it easier to track the data. Apply a custom sort to the Sales table to sort it in ascending order first by the values in the Date column, and then by the values in the Amount column. 10. Benicio wants to make sure that the Sales table does not contain any duplicate records, which would make any sales analysis incorrect. Identify and remove duplicate records in the Sales table as follows: a. In the range A5:A40, create a conditional formatting Highlight Cells Rule that formats Duplicate Values in Light Red Fill with Dark Red Text. b. Delete the second duplicate record from the table. (Hint: Do not delete the row from the worksheet.) 11. Benicio might want to filter the Product Details data in the range I4:M16, so he asks you to format it as a table. Format the range 14: M16 as a table using Light Gray, Table Style Medium 14 to match the Sales table. 12. To make it easier to refer to the data, assign the table name Details to the table in the range 14:M16 to make it easy to refer to the data. (Hint: Rename the table, not the range.) 13. Benicio wants to examine the January, 2022 sales by country and channel. Create a PivotTable based on the Sales table as follows: a. On a new worksheet, insert a PivotTable based on the data in the Sales table, and use January Pivot as the name of the worksheet. b. Display the Channel Type values as column headings. C. Display the Location values as row headings. d. Sum the Amount values CENGAGE New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project la 14. Format the PivotTable as follows to make it easier for Benicio and others to interpret: a. Apply the Currency number format with 0 decimal places and the $ symbol to the Sum of Amount values. b. Use Sales (000s) as the custom name of the Sum of Amount field. C. In cell A4, use Country to identify the row headings. d. In cell B3, use Channel to identify the column headings. 15. e. Change the PivotTable style to White, Pivot Style Medium 14 to coordinate with the tables on the Current Sales worksheet. Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable: a. Insert a slicer based on the Product field. b. Move and resize the slicer so that it covers the range F3:G12. 16. Benicio also wants to compare the sales data by country in a visual format, and then display data only for the Mini 1, the company's best-selling product. Create a PivotChart as follows: a. b. Insert a Stacked Column PivotChart based on the data in the PivotTable. Move and resize the PivotChart so that it covers the range A10:E25. 17. Format and filter the PivotChart as follows to meet Benicio's requests: a. b. Change the colors of the PivotChart to Monochromatic Palette 6 to coordinate with the PivotTable. Use the slicer to display sales data for only the Mini 1 in the PivotTable and PivotChart. 18. Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Benicio wants to make sure the total expense per unit sold calculation in cell B17 does not produce a divide by zero error. Modify the formula in cell B17 as follows: a. Add the IFERROR function to the formula in cell B17. b. Use "Divide total expenses by units manufactured" as the message to display in case of an error. 19. Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 22,000. He wants to see how the gross profit changes if the price or unit sales are different. Create a two-variable data table as follows to calculate gross profit as the price and unit sales change: a. For the range D4:K9, create a two-variable data table using the price per unit (cell B6) as the Row input cell. b. Use the units sold (cell B5) as the Column input cell. CENGAGESee Answer
  • Q19:Need to do- We have to copy the formulas from one sheet to the other From Milestone Labour with cost → to Milestone Labour 1) For the loadmaster part, we have to make X3 of that - for xpat, national, and 3rd party 2) Need to create 2 pie charts:- 1 shows total labour cost, xpat vs national vs 3rd party 2nd shows the loadmaster info xpat vs national vs 3rd party 3) put the pie charts in a new tab at the bottom of the Excel file Files attached- 1) Student instruction for assignment 2) Milestone Labour with cost 3) Milestone Labour Student Note- When you alter the Excel sheet, the charts auto-change to suit the new details. the pie chart will update when info is adjustedSee Answer
  • Q20: 6/13/24, 10:55 AM Assignment Information QSO 320 Module Four Assignment Guidelines and Rubric Overview For this assignment, you'll continue to build on your Labor Hours spreadsheet to look at the actual costs of a business project. Directions Use the Labor Hours spreadsheet to build on the table in the Data tab and get the actual cost of this project. To do this, complete the following steps: 1. Total the complete labor cost. A. Make a column that totals the labor for each employee when you give the added information. (See the last two bullets in the scenario box below.) B. Total the complete labor cost. 2. Think about what other costs could add to the overall cost of the project. A. Below is a list to think about. Add more columns for these costs. (Note: Not all of these should be included; read each bullet carefully.) i. The project is located 30 miles from the office, and the company pays the employees 54¢ per mile to drive to the worksite and back. ii. You are using $1,000 in materials left over from another project. iii. The worksite is in a remote location. Therefore, a portable office with restrooms had to be leased at a cost of $300 per day. iv. The company spends $350 per employee to provide each employee with a uniform and safety equipment. This equipment is replaced annually. v. The company pays for a $60 food platter to be delivered to the site every day to feed all the workers. vi. Fuel to run the generator in the portable office costs $10 per day and is included in the lease agreement. vii. A security service had to be hired by the company to guard the worksite 24 hours a day. This costs $720 per day. B. Total the entire project cost. 3. Create a new tab titled Actual. Write a summary statement that recommends lowering costs without lowering labor rates. Scenario You are looking at labor costs for a construction project using eight employees: • The employees' names are Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green. • Each employee worked eight hours a day for five days. • The employees' wages per hour are as follows: • Smith: $8.95 https://learn.snhu.edu/d2l/le/content/1614358/viewContent/33190528/View 1/2 12 6/13/24, 10:55 AM 。 Rodriguez: $11 o Daniel: $14 • Eli: $16 • Lee: $19 。 Kim: $20 0 Buster: $25 Assignment Information • Green: $40 • Green, Kim, Eli, and Lee are full-time employees, and the others are contract employees. • • The cost of overhead per hour for a full-time employee is 40% of their hourly rate. The cost of overhead per hour for a contract employee is 20% of their hourly rate. Specifically, you must address the following rubric criteria: 1. Set up a spreadsheet and perform labor calculations correctly. 2. Choose the correct additional costs and calculate the total cost correctly. 3. Write a summary recommendation. What to Submit Your assignment must be submitted as the same Microsoft Excel document you used for the Module One and Two assignments. Use 11-point Calibri font. Criteria Labor Calculations Proficient (100%) Module Four Assignment Rubric Needs Improvement (70%) Additional Costs Summary Recommendation Sets up the spreadsheet correctly and performs calculations correctly Chooses the correct additional costs and calculates the total cost correctly Writes a summary recommendation https://learn.snhu.edu/d2l/le/content/1614358/viewContent/33190528/View Not Evident (0%) Value Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 20 Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 40 40 Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 40 Total: 100% 2/2See Answer
View More

Popular Subjects for Excel

You can get the best rated step-by-step problem explanations from 65000+ expert tutors by ordering TutorBin Excel homework help.

Get Instant Excel Solutions From TutorBin App Now!

Get personalized homework help in your pocket! Enjoy your $20 reward upon registration!

Download on the
App Store

Scan to download app

Claim Your Offer

Sign Up now and Get $20 in your wallet

Moneyback

Guarantee

Original Work

Reports

$20 reward

Upon registration

Full Privacy

Full Privacy

Unlimited

Rewrites/revisions

Testimonials

TutorBin has got more than 3k positive ratings from our users around the world. Some of the students and teachers were greatly helped by TutorBin.

"The service they provide is great. Their answers are unique, and expert professionals with a minimum of 5 years of experience work on the assignments. Whether you need Excel assignment help or support in other subjects, expect the answers to be of the highest quality and get ready to see your grades soar."

Olivia

"Ever since I started using this service, my life has become easy. Now I have plenty of time to immerse myself in more important tasks viz., preparing for exams. TutorBin exceeded my expectations. I asked them to do my Excel assignment for me, and they delivered excellent quality tasks within deadlines. My grades improved exponentially after seeking their assistance."

Gloria

"They are amazing. I sought their help with my assignment and the answers they provided were unique and devoid of original work. I was looking to pay someone to do my excel homework, and they really helped me get into the good books of my professor. I would highly recommend their service."

Michael

"The service they provide is great. Their answers are unique, and expert professionals with a minimum of 5 years of experience work on the assignments. Whether it's general homework or excel homework assistance, expect the answers to be of the highest quality and get ready to see your grades soar."

Richard

"They provide excellent assistance, and what I loved most was their homework help. They are available around the clock and provide support until you are satisfied. When I needed someone to do my excel assignment for me, their expert assistance was extremely helpful."

Willow

TutorBin helping students around the globe

TutorBin believes that distance should never be a barrier to learning. Over 500000+ orders and 100000+ happy customers explain TutorBin has become the name that keeps learning fun in the UK, USA, Canada, Australia, Singapore, and UAE.

  • discord

Services

Live Sessions
Help in Essay
Help in EssayDo My EssayWrite My Essay
Lab Report Help
Project Report Help
Speech Writing Service
Presentation Writing Service
Video Solutions
Online Assignment Help
Online Tutoring
Questions and Answers Library
Math Problem Solver
Do My Homework
Do My Assignment
Pay Someone To Do My Homework
Academic help service
Paper Writing HelpWrite My Research PaperPay Someone To Write My Paper

Branch

Math Homework Help
Physics Homework Help
Chemistry Homework Help
Civil Engineering Homework Help
Finance Homework Help
Electrical Engineering Homework Help
Mechanical Engineering Homework Help
Computer Science Homework Help
Economics Homework Help
Other Subjects Homework Help
Do My Math Homework
Do My Geometry Homework
Do My Chemistry Homework
Do My Computer Science Homework
Do My Physics Homework

Websites

Pay People to Do Your Homework
Pay for my Assignment
Write My Essays for Me
Help Accounting Homework
Economics Homework Help Online
Geometry Homework Help
Help Me Do My Essay
Help in Assignment

Get Instant Homework HelpOn Your Mobile

All The Answers, In Your pockets

Tutorbin
Tutorbin
Scan to download app
DMCA.com Protection Status

Features

Expert Tutors
Original Work
100% Correct Solutions
24/7 Availability
Cost Effective
Solved on Time
Secured account
Refer and earnNew!
Essay Rewriter
Paraphrase Writer
Grammar & Spell checker

Get Instant Homework HelpOn Your Mobile

All The Answers, In Your pockets

Tutorbin
Tutorbin
Scan to download app
DMCA.com Protection Status

About

Blogs
FAQs
Refund Policy
Privacy Policy
Terms and Conditions
Reviews
Copyright Policy
Academic Integrity
Top Questions

Get Instant Homework HelpOn Your Mobile

All The Answers, In Your pockets

Tutorbin
Tutorbin
Scan to download app
DMCA.com Protection Status

Get Answers In Few Hours

Get Homework Help Now!

Instant Help? WhatsApp Us!

+91 9733392546

+