Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel module 2 sam project 1

12/11/2020 Client: papadok01 Deadline: 3 days

New Perspectives Excel 2016 | Module 2: SAM Project 1b

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png New Perspectives Excel 2016 | Module 2: SAM Project 1b

Kelly’s Telemarketing

formatting workbook text and data

GETTING STARTED
Open the file NP_EX16_2b_FirstLastName_1.xlsx, available for download from the SAM website.

Save the file as NP_EX16_2b_FirstLastName_2.xlsx by changing the “1” to a “2”.

0. 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_EX16_2b_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
Kelly runs a small company that deals with telephone sales. She decided to update the workbook she uses to track her team’s compensation data in order to make the information easier to understand.

Change the theme of the workbook to Office.

Switch to the Weekly Compensation worksheet. Apply the Heading 1 cell style to the merged range A1:G1, and then center the text in that merged range.

Merge and center the range A2:G2, and then change the font size of the merged range to 14 pt.

Italicize the contents of the range A3:B3, change the font to Times New Roman, and then change the font color to Orange, Accent 2 (6th column, 1st row of the Theme Colors palette).

Format cell B3 using the Short Date (e.g., 3/13/2018) number format.

Use the Format Painter to copy the format from cell A6 to the range B6:G6.

In cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.)

To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10.

Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7).

Copy the formula and the formatting in cell G7 into the range G8:G10.

Change the fill color of the ranges F8:G8 and F10:G10 to Blue, Accent 5, Lighter 80% (9th column, 2nd row of the Theme Colors palette).

To quickly see which employees received three or more bonuses, use the Highlight Cells Rules conditional formatting to format cells in the range C7:C10 with a value greater than 3 using Light Red Fill with Dark Red Text.

In cell A11, increase the indent of the cell contents twice.

Kelly would like to know the average bonus multiplier for the employees. In cell C11, create a formula using the AVERAGE function to find the average bonus multiplier (C7:C10).

Copy the formula from cell C11 into the range D11:G11 to find the average bonus rate, total bonus, total salaries, and bonus percentage for the team.

In the range D7:F11, apply the Currency number format with zero decimal places and $ as the symbol.

In the range G7:G11, apply the Percentage number format with one decimal place.

For the merged range A20:A30, rotate the cell contents to 0 degrees.

Find and replace all instances of the text “Salaries” with Salary. (Hint: You should find and replace two instances.)

Kelly plans to print the worksheet to review with her team.

Change the page orientation to Landscape, and then set the margins to Wide.

She wants the table and the chart to appear on separate pages when printed. Select cell A13, and then insert a page break.

Set rows 1-3 as print titles. (Hint: Rows 1-3 should repeat at the top of each printed page of the worksheet.)

Create a custom footer for the worksheet. In the left footer section, display the current Page Number using a Header and Footer element. In the center footer section, display the Sheet Name using a Header and Footer element.

Switch back to Normal View if necessary.

Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Weekly Compensation Worksheet

2

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Finance Homework Help
Custom Coursework Service
Writer Writer Name Offer Chat
Finance Homework Help

ONLINE

Finance Homework Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$55 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

L&q intermediate market rent - Assignment - Faye sayer time team - Overflow relief gully australian standards - Week 7 Discussion Forum Peer Review for Culminating Argument paper (Abstract, Intro & Conclusion - Pechenik writing about biology pdf - Alpha cyano maldi matrix - Basic needs of ancient communities - Jet blue airlines company history - 301 best questions to ask on your interview pdf - Accountancy and Management - Discussion question - Her three days short story questions - Air force esd phone number - Im not scared book - Key success factors of tata motors - Yard o led aristocrat pencil - Jeff bezos the force behind the brand pdf - Chartered accountants ireland cpd requirements - Cert iv training and assessment cheat sheet - D light design case study solution - Use the data in the table and submit the answers to the following questions in a Word document: - REPLY 1 and 2 (7) - What shape is a parachute - What will be the hexadecimal value of al after these instructions execute? mov al,94h xor al,37h - Reading comprehension for grade 10 with questions and answers pdf - The seven dimensions of applied behavior analysis - Cpap operations pty ltd - Java program using switch case to find zodiac signs - Teesdale mercury barnard castle - Purdue owl scavenger hunt - How to find restrictions of a function - Communication role play scripts - Email assignment - Josephine paterson and loretta zderad humanistic theory - Sentence starters for evidence - Chlorsig eye ointment side effects - Investment and competition (Finance) - Hcf bronze plus extras - Will dean tough mudder net worth - What you pawn i will redeem annotated bibliography - Physics igcse equation sheet - Husband Wife +91==#9928097710 Love problem solution specialist molvi ji - Twinkle of a fading star - Murdoch deferred exam timetable - Exclusive sales agency agreement nsw - Mk k545whi data socket module rj45 - Lb - Rational approach to change management - Osce physical exam checklist - Annotated Bibliography - Sita sings the blues sparknotes - 5 Best Tips for Homework Success - Sheep brain dissection worksheet - Easi ecg lead placement - The nerdy dozen cliff notes - The alchemist questions and answers - Discussion Board Unit IV - Blue Ocean Strategy Book Review - MBA515 Week 7 Discussion 7 - Discussion needed by Thur @5 - What is the future value of $4,900 invested for 8 years at 7 percent compounded annually? - It planning at modmeters - Kovaak's aim trainer fortnite - Ensure team effectiveness answers - Bodega dreams full text pdf - Crisis Intervention - Home management and family resource management - How can I Hire British ghost writer for my book assignment? - Scantronic 9651 engineer manual - 2 briefly summarize the problem of evil and suffering - Judith myers tombstone dead by daylight - Elite athlete bonus atar points - Post- tania - Taplow car boot sale - African History Discussion question - Bubble deck slab disadvantages - 3 - ¿quién es? select the verb that correctly completes each sentence. - Uniform circular motion pre lab - Home in fiction geraldine brooks - Week Two Discussion One - Spelling connections grade 7 answer key - Bookstore scavenger hunt worksheet - Nucor corporation competing against low cost steel imports case study - Drama vce study design - What is a classified statement of financial position - Pop sound experiment - Trevor needs a new bicycle tire - Apple cider vinegar soaked tampon for bv - Peter symonds college intranet - What does daforest stand for - Sample student case brief - Amp super easy balanced - Overcoming the amorite spirit - A thunderstorm by emily dickinson meaning - Polmont park medical group - Zitkala sa impressions of an indian childhood - Coraline chapter 4 summary - WIRELESS NETWORK APPLICATIONS – BUSINESS AND INTERNET OF THINGS - Creative thinking and problem solving assignment