HW7_sol - 3. When the button is clicked new totals and...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales by product and month Jan Feb Mar Apr May Jun Jul Aug Product 1 5630 4200 4590 6570 4760 5670 4320 5690 Product 2 4530 2490 4200 4550 4330 4940 5850 3160 Product 3 5660 4500 4600 6920 3680 4910 5310 4790 Product 4 2620 5580 6040 4940 5820 4500 4460 5260 Product 5 4590 6490 6230 5110 4540 5580 5080 4630 Product 6 4850 4860 6830 3880 4670 6360 4450 6240 Product 7 5400 5090 6220 5960 4390 4840 5370 5700 Product 8 5430 5510 6160 4560 6820 5080 5970 4900 Product 9 5030 4800 4830 4620 4870 4010 3060 4030 Product 10 4650 4790 4350 5640 5790 4680 3520 7230 Total 48390 48310 54050 52750 49670 50570 47390 51630 Average 4,839.0 4,831.0 5,405.0 5,275.0 4,967.0 5,057.0 4,739.0 5,163.0 1. Print "Total" and "Average" in Cells A16 and A17 respectively in a bold font. 2. Assume each month you will be adding a new month of data.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. When the button is clicked new totals and averages will appear below (rows 16 a 4. Averages should be reported with one digit to the right of the decimal. Avg and to 5. Note that VBA code will not know ahead of time how many months of data are pr 6. Choose a non-white background color for the cells in row 16 and choose a non-b 7. Your first executable statement should be Range("16:17").Clear 8. Let the Font Name be Calibri and font size be 11 for rows 16 and 17. and 17). totals should have commas for 1000's. resent black font color for 17....
View Full Document

Page1 / 2

HW7_sol - 3. When the button is clicked new totals and...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online