VBAExam-w20-Romney_Cope.xlsm - 30 Points Possible...

This preview shows page 1 - 7 out of 71 pages.

30 Points Possible Fahrenheit Celcius
40 Points Possible Quantity 0 <--enter an integer Price 0 <--enter a currency Extended Price (Quantity x Price) $0.00 <--calculate in your VBA code Membership Gold <--Select from this dropdown cashback % 0% <--Your code should fill this in Cashback amount $0.00 <--calculate this in VBA Total after cashback $0.00 <--calculate this in VBA Setup Section Membership Level Cashback% Gold 1% Platinum 2% Black 3% None 0% Minimum purchase for cashback $ 5.00 Encouragement Threshold $ 10.00 Save before running!
! Requirements Create a Sub, run by the button at the bottom of the page, that calculates the cashback for any purchase. This business gives cashback based on a customers membership level, which is calculated as follows: cashback amount = extended price * cashback% The cashback% is listed in the setup section for each of the three membership levels. The user will enter the quantity, price, and select the membership level from the dropdown that is already built for you in cell B7. The code will determine, calculate, and fill in the highlighted cells. Cashback is earned only if the extended price meets or exceeds the minimum purchase for cashback. If the cashback amount meets or exceeds the encouragement threshold, display a message box encouraging the customer to make the purchase. Assume the values in the setup section can change (i.e., don't hard code numbers that could change). Assign the macro to the button. Comment your code so that it is easy for a grader to follow. Points may be deducted if there are no comments.
85 Points Possible Summary Statistics Table Total Average Total Name of Date Lisa Location Quantity Rating Revenue Location Provo Orem Quantity 3 Provo Revenue $972 Springville Rating 0 Grand Totals ^ Sum ^ ^ Ave ^ ^ Sum ^ Name of Date Rod Location pRovo <-- Make sure to handle this miscapitalization Quantity 5 in your code without changing the text. Revenue $2,160 Rating 4 There are three possible misspelled cities Provo, Orem, and Springville. Name of Date Maggie Location Provi <-- They meant Provo here; but don't change Quantity 6 the spelling. Make your code handle it. Revenue $2,160 Rating 1 <-- Notice the several blank rows here. Use code to account for multiple blank rows. Name of Date Carl Location Orem Quantity 5 Revenue $2,700 Rating 4 Name of Date Homer Location Provo Quantity 4 Revenue $1,728 Rating 1 Name of Date Otto Location Orem Quantity 3 Requirements Create a sub ('Bikes"), run by the button, that generates a sentence outpu averages in the table to the right of the data. Don't forget to handle the c at least the left three characters are spelled correctly. Also assume there removed at the bottom, and assume there may be more than one blank r are formatted exactly as shown in the examples (including a period), and summary sentences need to be are shown to the right of where your out so that a grader can follow it. Points may be deducted if there are no com HINT : If you can't finish you will have a better shot at partial credit if you code (pseudo code) as well.
Revenue $1,404 Rating 5 Name of Date Homer Location Provo Quantity 7 Revenue $3,528 Rating 1

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture