As the office administrator, you use Excel to maintain personnel data and summarize cash flow. You are finalizing the Personnel and Cash Flow worksheets for the current week. Begin on the Personnel worksheet by cutting the contents of the range B1:B2 and pasting them into the range A1:A2.Adjust the width of column A using AutoFit.Change the width of column B to 16.00.Enter the values shown in Table 1 into the corresponding cells in the range B14:C16.Enter albert.luna@cengage.com in cell D5. Select the range D5:D16, and then use the Flash Fill button (using the Fill drop-down arrow in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.)Change the width of column D to 36.00.Enter the word Total in cell A17. In cell B17, create a formula using the SUM function to determine the total salary paid by Tabula Insurance Agency by totaling the values in the range B5:B16. Copy the formula you created in cell B17 to cell C17.Enter Number of Employees in cell A19.In cell B19, create a formula using the COUNT function to determine the number of people employed by Tabula Insurance Agency by counting the values in the range B5:B16.Enter the text Average Commission in A21.Switch to the Cash Flow worksheet. Change the orientation of the Cash Flow worksheet to Landscape.In cell A2, change the cell content to Cash Flow: April 4-10, 2021 (instead of just reading "April 4-10, 2021").Select the range A4:E4 and the nonadjacent cell G8, and then increase the font size of the cells to 12 point.To better display the content, manually change the height of row 3 to 8.00. (Hint: Do not use AutoFit.)In cell B7, enter a formula without using a function to determine the profit generated from auto insurance policies by subtracting auto expenses (cell B6) from auto sales (cell B5) for the week of April 4-10, 2021. Copy the formula you created in cell B7 to the range C7:D7.After determining the total profits generated by each store, you are now interested in calculating the total sales, expenses, and profits across all types of insurance sold. Select the range E5:E7, and then apply AutoSum to calculate the totals for these categories across all three types of insurance.Since you just edited the worksheet, the content in cell A9 is no longer accurate. Click on cell A9 and clear its contents.Apply the Wrap Text formatting to cell G8.Adjust the Zoom level of the Cash Flow worksheet to 130%.After reviewing the Personnel and Cash Flow worksheets, you typically generate some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting, and if necessary, move the new worksheet after the Cash Flow worksheet. Table 1: Data for the Range B14-C16 B C 14 846.15 23.22 15 846.15 5.19 16 923.08 0.00

Can you help me do these please? Just one paper each, chapter 6 and 7.Purpose of this Assignment:Your assignment is to keep a journal, on a regular basis, related to this course.Journal writing is a form of free-writing. It is also "low stakes" writing: it is mostly for yourself (see below), and therefore, it will not be edited necessarily for style or grammar.Instructions:Journal writing serves many purposes. In your journals you can:Observe what you are reading, what goes on in class, and how it relates to current real-world marketing eventsDefine what you are doing in an assignment, in the course generally, in your major/minorExpress confusion about anything – where you are not understanding, or are frustrated – and perhaps become unconfused as your write or pose questions to meSpeculate about what you are studyingGive insights – your ideas, your conclusions, your putting things togetherConnect readings to other readings, this course to other courses, what we are talking about to your lifeRespond to readings (controversial ones, for example), whether negatively or positivelyReact candidly to what happens in classBe self-aware about what you are studying and why you are studying itRefine your thoughts as they progress throughout the term, whether on particular readings, particular topics, the course generally, or your assignmentsEvaluate the course, including the task of keeping a journal.Expectations: AT LEAST one entry per chapterAT LEAST ONE PAGE (double spaced, typed, 12-point font) per entry/chapter.Each entry MUST CONTAIN specific references to thoughts, comments, examples, etc. FROM CLASS.Express yourself freelyTake the assignment seriously…but have funNO LECTURE NOTES AND/OR CLASS SUMMARIES!Mark every journal entry with the date/time when you wrote it (you don’t have to write the entry all at once, just note the date/time you work on it)Start each entry on a page"Write in your natural voice with your most comfortable language.... Otherwise you may become distracted by form rather than content...."While I am specifying much of what your assignment should contain, how you present that information is up to you. Your work will be graded in comparison to the assignments turned in by the other students in the class. Originality and professionalism will also be considered (in other words… entertain me, show me that you’ve learned something and can apply it to the “real world”, and you’ll do well). Chapter 6we learned about Understand the different types of new products, their advantages, and their risks. Describe the various stages of new-product development. LO 6-3Discuss the major risks in new-product development and how to reduce those risks.Summarize the ethical and sustainability issues in new-product development.Describe the categories of new-product adopters and the implications of adoption to marketers.Describe the stages and aspects of the product life cycle and how they affect the marketing mix.Chapter 7Explain the importance of and criteria for effective market segmentation.Describe the bases for segmenting both B2C and B2B markets.Discuss international segmentation bases and the effect of international market segments on the marketing mix.Describe the factors and analytics involved in selecting target markets.Compare the most common target marketing strategies.Summarize the ethical issues in target marketing.Explain the three steps of effective market positioning and why firms may choose to use repositioning strategies.

add monitor and control activities for both of the project plans from Week 3. Complete the following:Describe how to use project performance metrics to find out project costs, schedule, scope, and quality status during project execution for the waterfall method and Agile scrum method. Discuss the customer's involvement during project execution for the waterfall and Agile scrum method and how to control project performance during the project life cycle. APA format with 1000 to 1200 words