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

28/03/2021 Client: saad24vbs 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

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:

Maths Master
Top Class Engineers
Financial Solutions Provider
Quick N Quality
Custom Coursework Service
Online Assignment Help
Writer Writer Name Offer Chat
Maths Master

ONLINE

Maths Master

I will cover all the points which you have mentioned in your project details.

$23 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I have read your project details. I can do this within your deadline.

$36 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$56 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

Give me a chance, i will do this with my best efforts

$23 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Give me a chance, i will do this with my best efforts

$50 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

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

Yanbu university college women's campus - Edward scissorhands seduction scene - Please respond if you can complete it in 7 hours, Please see the doc attached and respond - Solutions acids and bases worksheet - Why does lime water bubble - Cybertext accounting solutions - Youngest player to hit home runs - 79 81 commodore drive paradise waters - The relevant range of activity refers to the - Pathfinder ring of eloquence - List two explicit premises that you find the most compelling in “give thanks to meat.” - Html and css 6th edition tutorial 4 case 3 - PROMOTING IDEAS AND TEAM BUILDING - The snow child short story - Multi touch screens vs mouse driven screens - Jobs in st marys sydney - What is moral subjectivism - Essay 2--Lysistrata - Mini paper2 - Global bike inc case study journal entries - What is the melting point of gold - Pantheistic worldview about human nature purpose and flourishing - After watching the movie Inside Out, discuss the concepts of short to long term memory - Making ethical decisions evaluation answers - Key concepts of media - Unimodal positively skewed hump-shaped distribution - Arma 3 interact button - Bank of baroda power of attorney format - GHF A3 - Module 1 - Forum 2 - Hoyt sector model pdf - Drill press safety sheet - Multi-threading computer science assignment - War and Cyber Operations - Examples of confidence intervals in health care - Essay 4 - Catch 22 character map - How to make the cup song - Attack of the mamazon - Arthur gorrie correctional centre contract - Week 1 Post - Ifsm 300 stage 4 cic - Inside job movie reaction paper - How to calculate your own ecological footprint - Abrsm trombone grade 1 - Universal purpose of goods - How does an exoskeleton help arthropods live on land - Doctors note for school - Global supply chain management simulation cell phone tips - Sunbeam fraud case - Write a summary about what have you learned from this article - WORLD GEOGRAPHY - Use excel help you optimize complex projects - Short answer - PAPER – Construction Technology – CONSTRUCTION PROJECT MANAGEMENT - "A" WORK DISCUSSION IN 18 HOURS - Federalism - The investment in the notes receivable earns interest at a rate of 12% per year. - Special schools for slow learners in pune - Dry inflammable matter crossword - Identifying innovation roles - Describe the alternative marketing mix strategies used in global marketing - Sample thesis statement informative speech - Print network diagram ms project - Diffraction grating experiment observation table - Question - Specific heat capacity table j gc - Rammed earth timber frame - Picasso elements of art - Project team leadership presentation cpmgt 300 - Sqa higher psychology assignment examples - Judaism is the only civilization that had its roots based on the logocentricity of life? - Liberty university letter of recommendation - Piano by numbers songs - ARTH 334 Discussion - GPU Databases (Kinetica, SQream, BlazingDB, Omnisci etc) - Discuss Question - Prepare a budgeted income statement for 2014 - Abb irc5 controller manual - Differences in male and female communication informative speech - If the pressure of a gas sample is quadrupled - Miercoles - If the ad shortfall is $600 billion and the mpc is 0.8, - Qualitative methods of demand forecasting ppt - A Doll's House Act I - How to become a film director pdf - Probability sum of three dice - Sketch and label dna replication - 3d trigonometry gcse exam question practice - Jetblue case study summary - Punctuation/commas - Encumbrance accounting is only typically used for - Building Trust - Control plan format 4th edition - How to increase customer accessibility in capsim - Interrogations-- CJT202 DICUSSON BOARD - Describe juliet's rapidly changing attitudes toward romeo in this scene - 5 pages due by 24 hours......... - Discuss case 9.2 hsbc combats fraud in split second decisions - Seaway national bank chicago il