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

Sam cengage excel project 1

17/12/2020 Client: saad24vbs Deadline: 2 Day

Illustrated Excel 2016 | Module 9: SAM Project 1a


C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Illustrated Excel 2016 | Module 9: SAM Project 1a


Five Points Media


AUTOMATING WORKBOOK TASKS


GETTING STARTED

Open the file IL_EX16_9a_FirstLastName_1.xlsm, available for download from the SAM website.


Save the file as IL_EX16_9a_FirstLastName_2.xlsm by changing the “1” to a “2”.


0. If you do not see the .xlsm 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 IL_EX16_9a_FirstLastName_2.xlsm 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.


If you see a Message Bar with a security warning at the top of the Excel window, click the Enable Content button in the Message Bar to enable the macros contained in the file. [Mac Hint – If you see a popup with a security warning, click Enable Macros to enable the macros contained in the file.]


To complete this project you will need to display the Developer tab. To add this tab to the Excel ribbon, click the File tab to open Backstage View and then click the Options button. In the Excel Options dialog box, click the Customize Ribbon option and click the Developer check box. Click the OK button to close the Excel Options dialog box and confirm the Developer tab appears in the Excel Ribbon.


PROJECT STEPS

Robert Cisneros is the sales manager for Five Points Media, a company selling subscriptions to online media including movies and TV shows. He has asked you to help him automate a worksheet he will use to analyze sales data each week.


Switch to the Week 1 worksheet. Run the Title macro to insert a title for the worksheet in cell A1.


Edit cell A1 to add 1/6/2020 as the date at the end of the title.


Add totals to the worksheet as follows:


a. Assign the Totals macro to the Totals button in column H.


b. Use the Totals button to run the Totals macro.


Identify the top five sales for the week by recording a new macro as follows:


c. Enter Top as the macro name.


d. Assign the shortcut key CTRL+j to the macro. [Mac Hint – Assign the shortcut key Option+Cmd+j to the macro.]


e. Store the macro in This Workbook.


f. Enter the text Highlights the top five sales for the week as the description.


g. With the macro recording, select the range B3:F12.


h. Apply the Top 10 Items conditional formatting rule to the selected range.


i. In the Top 10 Items dialog box, use 5 as the number of top values to highlight.


j. Highlight the cells with Green Fill with Dark Green Text.


k. Stop recording the macro.


Assign the Top macro to the Top 5 button in column H so that Robert can identify the top five sales values by clicking the button.


A macro named Bottom highlights the bottom 10 percent of values, and Robert wants the macro to highlight the bottom five values. Modify the macro as follows:


l. Open the Bottom macro in the Visual Basic Editor.


m. After the .TopBottom = xlTop10Bottom line of code, change the .Rank = 10 line of code to .Rank = 5 so that the highlighting rule identifies the bottom five values.


n. Change the .Percent = True line of code to .Percent = False so that the highlighting rule selects values rather than a percentage of values.


o. Use the Bottom 5 button in column H to run the Bottom macro and highlight the bottom five sales values for the week.


Robert wants to use a button to apply data bars to selected cells and compare their values. Add a button as follows:


p. Between the Bottom 5 and Bonus buttons in column H, insert a Rounded Rectangle to match the other button shapes. (Hint: Depending on your version of Office, the name of the shape may appear as Rectangle: Rounded Corners.)


q. Set the height of the rounded rectangle to 0.3” and set the width to 1”.


r. Enter Compare as the button text.


s. Apply the Moderate Effect - Dark Green, Accent 3 shape style to the new button.


t. Assign the Compare macro to the Compare button.


The Compare macro should select the totals in the range G3:G12, but instead selects cells in the range J3:J12. Correct the macro as follows:


u. Open the Compare macro in the Visual Basic Editor.


v. Change the Range("J3:J12").Select line of code between the initial comments and the “Selection.FormatConditions.AddDatabar” lines to Range(“G3:G12”).Select so that the macro selects cells in the correct range. (Hint: There are no spaces before or after the parentheses in the code.)


w. Run the edited Compare macro.


Thursdays and Fridays are typically the busiest days of the week. For subscriptions sold on those days, salespeople receive a 10 percent bonus for sales in the top tier (indicated by a gold star) and a 5 percent bonus for sales in the middle tier (indicated by a half-gold star).


Use the Bonus button in column H to run the Bonus macro and determine which salespeople receive a bonus for their Thursday and Friday sales.


Record a new macro and assign it to a button to prepare the worksheet for printing as follows:


x. Enter Print_Setup as the macro name.


y. Store the macro in This Workbook.


z. Enter the text Sets up the worksheet for printing as the description.


aa. With the macro recording, change the orientation of the worksheet to Landscape.


ab. Set the range A1:G12 as the print range.


ac. Scale the worksheet to print on one (1) page wide and one (1) page tall.


ad. Select cell A1 to remove the selection from the range.


ae. Stop recording the macro.


af. Assign the Print_Setup macro to the Print button.


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


Final Figure: Week 1 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:

Top Essay Tutor
Homework Guru
Calculation Guru
University Coursework Help
Best Coursework Help
Helping Hand
Writer Writer Name Offer Chat
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.

$125 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

$122 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

$115 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$122 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

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.

$120 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.

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

Gorgias encomium of helen pdf - Philosophy assigment - Give them the pickle - Gospel Christology Paper - How to study for pharmacology nursing - Triage assessment form crisis intervention - Crossfade co issued 15 year bonds - How to write reflection 3 for english sba - Mental Health in African American in College - How to Publish a Statement of Purpose ? - 139 morialta street mansfield - Lord of the flies quote - How to make a 3 generation genogram - Scotiabank student gic refund - Wk 1, HCS 457: DR 2 - Hours per patient day formula - Marking classified information exam answers - What were rent parties in 1920s harlem - Gear drawing with dimensions pdf - Summary of 1776 by david mccullough chapter by chapter - Business plan project - We said feminist fairy tales not fractured fairy tales - Choir rules and regulations - Compulsory heterosexuality and lesbian existence - Reply needed 2 - Cocky mart new listings - N mm2 in pa - Swarovski flatback size chart - Direct shear test lab report pdf - Week 7 Video Questions - Wilsons prom information centre - X4 bus timetable anglesey - Www math odu edu bogacki lat - Abiotic biotic factors worksheet - A puck moves on a horizontal air table - Leadership versus followership - Leicester college term dates - What is the quantity survey method - What is a disadvantage of an erp system - Durham english literature reading list - Question - How to use fprintf to make a table in matlab - Stuart alexander v blenders - domain model class diagram - Screening of breast cancer - Enterprise risk management assignment - Concrete mixing lab report - Multiple vendor dns query id field prediction cache poisoning - Best Assignment Writing Help UK - 6 hobson street sandringham - Examples of things in mesosystem - Flames and dangling wire annotation - Residential summer string camp - Cement stabilised sand strength - Disaster Recovery - 4th root of 1296 - Hilti hvu installation instructions - Sports management 3 - Analysis of a poem - Chapter 12 test answers - Activity based costing provides managers with information that affects - Half of a4 size in cm - Change proposal - Allusion in greek mythology - An assembly line is to be designed to operate 7 - The pardoner's tale summary - A school field trip essay - Sofia kovalevskaya interesting facts - David mccormack god's gonna cut you down - ¡a ver, chicas! éstos son los planes para mañana. presten atención porque no quiero - A company issued 5 20 year bonds - Celf 5 sample report - The rime of the ancient mariner worksheet answers - Data analysis plus - What is exhaustive search - Physics unit 3 worksheet 3 answers - A sheet that is made of plastic n - Taxation law - Enter a formula that references the value in cell f10 - Polymer molecular weight viscosity - Economist milton friedman is most closely associated with - What is the molarity of a solution prepared by dissolving - Bob mills talk radio - Joule kelvin coefficient van der waals - Why are some substances biodegradable and nonbiodegradable - Example of macrosystem in healthcare - The monkey's paw pdf - Effective training systems strategies and practices 5th edition pdf - The balance in the supplies account before adjustment - Kate spade warranty no receipt - Discussion 10-2 - St patrick's church crossmaglen - Why did laura kill herself in jasper jones - Wipro lighting price list - Who theorized that all behavior lawful and criminal is learned - Ernie and bert thirsty - Global training at google case study - Gold coast city council planning - Project Plan Overview - Hertfordshire county council training courses