(Q) Use Product Sales.xlsx to create a macro to sort the product

FIND A SOLUTION AT Academic Writers Bay

Question 1: Use Product Sales.xlsx to create a macro to sort the product by the total sales (in a decreasing order) and report the results in a new worksheet named “Summary.”Requirements:
You can use macro recorder to help in programming but do not only use the macro recorder.

In the new worksheet “Summary” the following two columns are required:

a. Product (0.6 points)
b. Total Sales (in decreasing order of total sales) (0.6 points)
The macro should also:
a. Calculate the runtime (0.6 points)
b. Prompt a dialog box showing the time in seconds. The message will be “This macro ran in __ seconds.” (0.6 points)
Bonus: Create a list of charts for the top 50 products and display these charts in another worksheet named “Charts.”) (1.2 points)
Question 2: Use Travel Expenses.xlsx to create a wizard that will guide users through a few steps to enter some information used to calculate travel expenses.Requirements:
You will create an ActiveX control button on the worksheet (“Sheet1”) to initiate the wizard process. (0.6 points)

The wizard should include the following steps:

a. Step 1: Entering the name (0.6 points)
b. Step 2: The number of miles traveled on the trip (0.6 points)
c. Step 3: The average miles per gallon (MPG) on the trip (0.6 points)
d. Step 4: The average price per gallon paid for gas on the trip (0.6 points)
You should include at least the following controls in each step:
a. A label showing what information a user should enter in this step (0.6 points)
b. A place where the user can enter the information (0.6 points)
c. A “cancel”button (0.6 points)
d. A button to go back to the previous step (0.6 points)
e. A button to go to the next step (0.6 points)
f. A “finish” button (0.6 points)More requirements for the buttons:
g. By clicking the cancel button, there should be a pop-up window asking the user whether he or she would like to cancel the process:
i. “Yes” cancels the process (0.6 points)
ii. “No” returns to the wizard (0.6 points)
h. A user should not be able to go back in the first step (0.6 points) or go to the next in the last step (0.6 points). If the user clicks the button to go to the next without entering any information, there should be a message box reminding him or her to enter information and not allowing going to the next step (0.6 points).
i. A user can only finish in the last step (0.6 points). By clicking the finish button, there should be a new row in the data range showing all the information just entered. (Note: the column names should not be replaced.) (0.6 points)
Once a record is being created, the Excel file should automatically calculate the total travel expense for this trip and store it in the last column. (0.6 points)

The next time you run the wizard, your utility should create another record in the data range (a new row). It should not replace any records before. (0.6 points)

Users should be able to continue working on the worksheet with the wizard being displayed. (0.6 points)

Use Product Sales.xlsx to create a macro to sort the product by the total sales (in a decreasing order) and report the results in a new worksheet named “Summary.” Requirements: first appeared on Term Paper Tutors.

Order from Academic Writers Bay
Best Custom Essay Writing Services


Why Choose Us?

  • non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How It Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT ; SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

About AcademicWritersBay.com

AcademicWritersBay.comnbsp;is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient andnbsp;high quality academic servicesnbsp;to our highly esteemed clients. AcademicWritersBay.com is equipped with competent andnbsp;proficient writersnbsp;to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders ofnbsp;master's degreesnbsp;ornbsp;PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. Atnbsp;AcademicWritersBay.com, you can be sure ofnbsp;excellent gradesnbsp;in your assignments and final exams.

error: Content is protected !!