Create a macro to sort the product by the total sales

Assignment Help Computer Engineering
Reference no: EM131834064

Assignment

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:

1. You can use macro recorder to help in programming but do not only use the macro recorder.

2. In the new worksheet "Summary" the following two columns are required:

a. Product
b. Total Sales (in decreasing order of total sales)

3. The macro should also:

a. Calculate the runtime

b. Prompt a dialog box showing the time in seconds. The message will be "This macro ran in __ seconds."

Create a list of charts for the top 50 products and display these charts in another worksheet named "Charts.")

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:

1. You will create an ActiveX control button on the worksheet ("Sheet1") to initiate the wizard process.

2. The wizard should include the following steps:

a. Step 1: Entering the name
b. Step 2: The number of miles traveled on the trip
c. Step 3: The average miles per gallon (MPG) on the trip
d. Step 4: The average price per gallon paid for gas on the trip

3. You should include at least the following controls in each step:

a. A label showing what information a user should enter in this step

b. A place where the user can enter the information

c. A "cancel"button

d. A button to go back to the previous step

e. A button to go to the next step

f. A "finish" button

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
ii. "No" returns to the wizard

h. A user should not be able to go back in the first stepor go to the next in the last step. 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.

i. A user can only finish in the last step. 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.)

4. 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.

5. 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.

6. Users should be able to continue working on the worksheet with the wizard being displayed.

Attachment:- Sales.rar

Reference no: EM131834064

Questions Cloud

Determining ksp experimentally : Describe two sources of error that could have been present while doing the experiment "Determining Ksp Experimentally"
What is the normal boiling point of pure : For the process: HNO3(g) ? HNO3(l), ?H° is -39.04 kJ/mol and ?S° is -111.74 J/(mol · K). What is the normal boiling point of pure HNO3
Identify the instrument or instruments used to quantify data : Make sure the quantitative article that you selected in Unit 1 will allow you to thoroughly address all of the points required for this discussion.
Element in the formula for potassium phosphate : What is the percent composition of each element in the formula for potassium phosphate (K, P, and O, respectively)?
Create a macro to sort the product by the total sales : 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.
Minute and the consumption of solid propellant : What would it cost to send a rocket to Mars, which is 4.91* 10^7 miles distance from earth, if the average speed of the rocket is 1600 miles/minute
If the threads are layered from top to bottom : If the threads are layered from top to bottom, brown, green, red , which layer will come into focus first if you are using the microscope properly?
Write a smart goal that would be suitable for the training : Examine how it related to your job performance and to broader organizational goals. If you have not had an organizational training experience
What word describes a microscope : What word describes a microscope that remains in focus when the objective lenses are changed?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd