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

Ways to fix AirPods Pro crackling sound issue - Love in la by dagoberto gilb - Sir lancelot rides slowly out of the castle - Quest diagnostics drug test procedure - Gilgamesh 3-5 page paper outline attached and sample - Leicester mercury birth deaths and marriages - 21st century jet the building of the 777 - Entomology multiple choice questions - Create an advertising campaign assignment - How to analyse a picture in english - Discussion - Peer review: literacy sponsorship - Spine stretch pilates exercise - Examples of bad hospitality in the odyssey - Where anonymity breeds contempt questions for study and discussion - What do gorillas sleep on in fruit orchards - 2.5 page paper on summarizing the following passage - 8 mile rap battle music - Human reproductive system vocabulary - "Hang the DJ” - Jacob and esau slideshow - State the following observations indicate an acid or a base - Short answer response examples hsc - J4 - High energy ignition system flare - Awl vet clinic gold coast - Total direct costs for the apparel department - Ecco global perspectives part 2 - Litterature - Interpreter of maladies mla citation - The traveling bra salesman's lesson answers - Architectural grid line conventions - Thyroglossal duct cyst pictures - Vcaa chinese second language advanced - Battle of the gods poster - 1206 ledbury dr smyrna tn - 4 mm brass rod - Ibm optim data studio - Sds polyacrylamide gel electrophoresis lab report - Advertising and social responsibility essay - Explain the stepwise approach to asthma treatment and management - A__________________ communicates general rules that cut across the entire organization. - Assignment 1 (Evidence-Based Practice Paper Reflection) - A family friend has asked your help in analyzing - Cell homeostasis virtual lab graph - NS-14 -D - Coca cola company business plan - Cloud computing concepts technology & architecture textbook - Financial markets word wizard - Cognitive behavioral therapy group settings versus family settings - Charlton heston bowling for columbine - Cisco wlc multicast ip address - Fissler spare parts australia - Assignment 2 - Conflict of the song of roland - Snap health center tutorial - Dobbs company issues two year bonds - Give the 2 components of physical fitness - Sarah palin is a cunt - Change verbs into nouns examples - What is hacking ppt - Nonverbal communication in indian culture - Certificate iv in building and construction hia - What is the Best Format of Manager Level CV? - Discussion Board 2: Beach Mouse Experiment - Cuwq - Newham council resident permit - Forces and vectors lab report - X 2 22x complete the square - Formal and informal letter writing exercises - 3d robotics disrupting the drone market case analysis - Significance of Air Freight in Military Aviation - Minkpink sunglasses david jones - Chemical equation for aerobic respiration - How to determine the leading coefficient - Developing persuasive business messages part ii - Operational Excellence - Write the decay equation for carbon 14 to nitrogen 14 - Chuck e cheese profit margin - Access chapter 3 northwind traders - 48 shades of brown sparknotes - Bojczuk v gregorcewicz [1961] sasr 128 - Wileyplus infinity symbol - Problems on lens formula - Acrostic poem for poem - Ims common cartridge 1.1 - Critical path analysis maker - Multiple sclerosis and type 1 diabetes an unlikely alliance - Pol 110 exam 2 - Devices that display textual information captured digitally are called ________ - Discover psychology 2.0 a brief introductory text - Week 10 - Discussion - Cie english language 0522 - Error code e1-0-1 centrelink - Bow and arrow cheerleading move - Nojo original baby sling recall - Zin zin zin a violin reading rainbow - Compound miter angle chart - Youtube llc going global by acting local case study