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 a

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

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

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:

Top Academic Guru
Isabella K.
Instant Assignment Writer
Assignment Solver
Helping Engineer
Quality Homework Helper
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$31 Chat With Writer
Isabella K.

ONLINE

Isabella K.

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$23 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$26 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$40 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

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

$30 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

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

When a factory is operating in the short run - Psychology + cyberpsych + interactive e-text code - Community windshield survey example - LULALLBY FASHION STORE - Reading response - Wakefield intermediate care unit - Ash wednesday story for preschoolers - Molecular weight data for a polypropylene material are tabulated - What is the serial position effect in psychology - Film analysis paper - Business Intelligence Project - Capsim rehearsal quiz - R v lmw 1999 - American art before and after world war ii presentation - PowerPoint presentation - Nabertherm more than heat 30 3000 c manual - Research Scenario - 22 asca drive green point - Lead with culture determining where the resistance is - Discussion - Circuit construction kit phet lab - Business Finance Discussion - Professional Nursing and State-Level Regulations - Newtons ring experiment calculation - Lord of the flies chapter 6 discussion questions - When were stone keep castles built - Under armour opportunities and threats - University of oslo physiotherapy - Hesi maternity exam 55 questions - Leonora carrington short stories pdf - Initiating the Project-2 - Penetration test proposal deliverable 1 rules of engagement - The norton introduction to literature 13th edition table of contents - Farewell to manzanar short summary - A siren emitting a sound of frequency - BUS 310 Week 4 Quiz - Daily production report film - 900 words 2 assignments sep 11th - Oracle partner network cost - Ida orlando metaparadigm - Customer relationship management assignment ppt - 343 kw to hp - Overhead crane safety checklist - How is malala a hero - Advantages of hindu arabic number system - Homework - Lies my teacher told me chapter 11 - Ermogenous v greek orthodox community of sa - Article 4 Pages and 8-10 slides - Zach kirkhorn tesla - Gasoline thermal expansion calculator - The april bank statement for trimble corporation - Model of elements of strategic management - Letter of compliance superannuation - Learning about offenders’ characteristics - Earthquakes and volcanoes worksheet answer key - Database systems design implementation and management 7th edition - MKT 630 IP2 - Probable signs of pregnancy hegar's sign - Discussion help - A piston cylinder device contains 0.85 kg of refrigerant 134a - What is program music - Whs action plan sample - Duke ellington in his compositional approach mastered both - Cisco prime infrastructure ordering guide - Security Architecture - Discussion - Bad genius moral lesson - Singapore permanent resident cpf contribution rate - How to make a genogram on word - Energy content of fuels lab report answers - Capsim - Dolan company accounting records reflect - CC-3 - Anthem for the doomed youth - Situations childish gambino - High spen chinese number - A barking sound the shepherd hears - Section 51 xxvi of the constitution of australia - 116 columbus drive hollywell - Recurring motif crossword clue - Advantages and disadvantages of participative management - Connected graph definition d1 - Advantages and disadvantages of balsa wood - Ships load line marks - Exercise 5 5a periodic inventory costing lo p3 - Psychographic segmentation of nivea - Mystik monk - Outback steakhouse international strategy - Ethical dilemmas and decisions in criminal justice - Voice recognition involves converting sound waves into words - The keeper of the bees 1925 first edition - Osha 300 logs excel - Ato weekly tax table 2015 - Characters in montana 1948 - Spectroscopic analysis of a dye lab report - Rels201 paper2 - Fedex ground hr intranet reward and recognition - Fordham summer session 1 - We will fight we will win lyrics vincent bohanan - Analyzes the impact of potential change factors