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

19/12/2020 Client: saad24vbs Deadline: 10 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


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Homework Guru
University Coursework Help
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$77 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$75 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

How to find nominal annual interest rate - Veracity definition nursing - Www hartnell edu canvas - Peter boxall university of auckland - Discussion needed by 3pm Sat - Murras by eva johnson - The beatles font microsoft word - Three Homework - Discussion: Patient Preferences and Decision Making and Assignment: Evidence-Based Project, Part 5: Recommending an Evidence-Based Practice Change - Project 1: Block Encryption in CBC Using 3DES - MK405 Social Media Marketing Evaluation Assignment - Bio lecture exam - Eric worre 90 day blitz - Vals psychographic segmentation - As Project Manager give Brief Project about Waste Water Management. - Little creatures dan murphys - Four learning patterns - Dunkin donuts job design - 2 Assignments- Target Marketing Essay & Pricing Essay - Unit IV Annotated Bibliography - Context level of data flow diagram - 182 johnsens road fernbrook - What is project integration - Cost constraint on useful financial reporting - What are the key elements of tesla motors strategy - Secret life of bees packet answers - Nursing diagnosis risk for falls as evidenced by - POB Home Work - Which of the following statements is true about naturalistic observation - S43a real property act - Smashing lights in karaoke bars - Baking soda and iodine chemical or physical - Iki indicator 1 ml 2.1 in glass vial - CMIT 370 week 6 discussion - Hay for sale herefordshire - Qualitative Analysis of the Sulfate, Carbonate, Chloride and Iodide Anions Lab Report - Bus 308 week 3 assignment - Ocr f322 june 2013 mark scheme - Speedway hobbies regina - Deliverable 3 – 5500 Assessing Concepts and Theories of Healthcare Leadership-PPT - Week 8 - ASSIGNMENTENTHICS-3 - System Engineering - 12 point essay topics - PHI-413-107200 Ethical and spiritual - Aps micro inverter monitoring - Easy rake silage facer for sale - Emergency Management Forum - Lit final exam - New york times homework article - ICA Summary 1b - When inductors are connected in parallel - Chapter 5 accounting for merchandising operations test bank - Win t increment 3 - Allison transmission investor relations - How to crash in ms project - Bulk density kg m3 - Aws iam policy validator - A student pipets 5.00 ml of ethanol - What is the duration of the rockfest? - Justin robinson and the mary onettes - Determination of pka of unknown acid - Realism vs liberalism vs constructivism chart - Total manufacturing cost to account for - Legal and ethical issues in prescribing - Oncourse strategies for creating success - Discussion - Humbuggery and manipulation the art of leadership - Winappls - Ableism essay - I need a discussion - Zpd to lexile conversion chart - 1 1 what is science answer key - Shl on demand candidates practice tests - Critical illness cover hcf - AC/FI A.5 - Chemistry ice table practice problems - Personality psychology 5th edition larson pdf - Apple iphone upgrade program for business - Skip downing on course 8th edition pdf - Ansoff matrix example nestle - Team contract project management - On her knees tim winton - Born haber cycle mgo - Gcse maths foundation revision checklist - Are toxins involved in set point theory - 154 cleeland street dandenong - Excel chapter 4 grader project mountain view realty - Member churches of the ncca - How to light a bunsen burner - Which of these supporting premises reinforces the thesis statement - Comprehensive problem 1 kelly consulting - Crime scene photos oj simpson - SOCW 6103 Week 8 - Assignment: A Disease of Obsession - CYS-P-14 - Poehling medical center has a single operating room - P10 1a accounting answers - Nursing 1 - Www utas edu au mylo - Essay about the American dream