171 37 047 /27/2007 2134 662 Figure 1 Insert Page Layout Formulas Dts R Vies O Tel me whut you wan tod ebruary MarchApri July Aupust Monthly Gains/ Losses Monthly Gains / Losses 520000 00 $154,000 00 100 000 00 $50 000 0o 3. Step 4 said "move the $100,000..." Why can't I just select it and drag it oer to F5 a. Formulas will be incorrect b. Excel won't allow it c. Cell F9 will still have $100,000 d. You can What happens to the chart if I add a new weekly total to the bottom of the MITTX Totals column in the Weekly Totals spreadsheet? 4. The chart is removed. a. Nothing b. The value is added to the chart c. "Invalid Number" error d. Why do I need a formula for the weekly totals on the weekly totals spreadsheet? Why not just copy and paste the number? 5. You can. That's what you should do. The value wouldn't change if you change the number in MITTX. a. d. b. You have to add weeks c. It's because of the charts. 6. I want to try out some different styles on the left-hand chart to see what they look like. How c I do that easily? I click on the chart and... a. Delete it and redo it b. Use the Format tab d. Change Chart Type in Design