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

Standing soldiers kneeling slaves summary - What is the diameter of the sun - Terminat hora diem terminat auctor opus translation - Nis elements confocal manual - Cinnamon by neil gaiman analysis - Design project report example - Rain rain go away asimov lesson plan - Theme from the giver - Identity london digital watch instructions - Sure success magic 13th edition release date - Buell x1 lightning problems - Learning to serve tony mirabelli - Los angeles county chief executive office - What is iv and dv in research - 4.4 evaluate procedures for working with others - G - 0.78 inches to cm - Www testingforschools com customer id - Data Science and Big Data - Principal as human resource manager - A pair of tickets amy tan summary - What are the four main branches of earth science - Stratco gable homeshed instructions - Kroger ground beef price per pound - Research Paper with Out line - Project report on competency mapping questionnaire - Rockford practice set answer key - Spynie dental centre elgin - Preparation of service equipment - Should Nursing be considered a global profession - Who is the speaker in sandburg's grass - 24 slot single phase motor winding diagram - Aac block u value - Final paper: Biopsychological Analysis of a Neuropsychological Disorder - The boom df of the jib crane - Case 35 deluxe corporation solution - Conflict in organizational behaviour ppt - Sap accounts payable process flow chart - Www ncsthechallenge org dates - Big dipper north star navigation - SOCW Week 2 Discussion 1 - Diagnostic Labels as Powerful Communications - Swot analysis of hardware store - Nature's purest soothing comfort bassinet - Chapter 1 of a project - Lecture 6 notes - Bruce dawe life cycle poem - Systems theory in nursing practice - How to critique a project - Concert press release example - Leader member exchange theory essay - Case Study - Human crutch method first aid - Non chronological report vocabulary - 5 paragraph opord template - Aladdin hasp license manager service - Leadership Foundation/Critical Thinking - Http www bretwhissel net amortization amortize html - The heart sounds s1 and s2 are caused by chegg - Embracing Diversity - Good vision statement characteristics - Www breckland gov uk gardenwaste - Six criteria for choosing brand elements - Billing procedure in hotels - Imagine that you are a crime analyst - New balance manufacturing facilities - What are the bond angles in sf6 - Analyst response - What is environmental scanning strategy - How to make a lighthouse out of cardboard - Integrated financial model Excel - CLASS DISCUSSION - Why did the motte and bailey castles change - Business - Air compressor inline shut off valve - The Following Questions: - A corporate ethics officer should have a background in law. - Numark 5000fx power supply - Psychology unit 3 past papers - Module 2 - Milton hall human capital consultants - Shadow health chest pain - Color rendering index calculation - Antelope abandons baby to leopard gif - Essentialfunctions xlsx at www seletraining com - Disney consumer products competitors - Half life problems worksheet answers - Big red bicycle pty ltd scenario - Square number word problems - Writing DQ 6-1 - Sony vegas remove a and b - IP 4 MKGT630 - The federal reserve worksheet answers - 5-4 Project Part One: Planning Document Second Draft - 2.2 Group Discussion: Participation Invitation - Feast watson surface restore - How can steve add 48 34 by making a ten - Self management plan - Indian king used rolls royce as dustbin - In 500 words - Calculus project