Question

Review View Help Tell me what you want to do Page Layout Formulas Data Insert Normal 22 Project He Stude... Normal 2 Calibri General Ea Copy Paste $ ▼ % , 400 →.0 Conditional Format as Normal Formatting Table B 1 u·m ク 廷程 圁Merge & Center Format Painter Clipboard Styles 812 X / 在1 Head Accessories SpringLeaf Designs - Loan and Revenue Scenarios Conservativ Moderate Aggressive 3 Loan Term (Yrs) Status Quo e Growth Growth Expansion $150,000 4 Total Loan Amount $0 350,000$ 638, 986 5 Annual Interest Rate 6 Monthly Interest Rate 0.40% 0.40% 0.40% 7 Loan Term (Yrs) Total Number of Payments $4,482.18) 000.00 10 Current Conservativ Moderate Aggressive 11 Revenues e Growth Growth Expansion Year $ 3,047,520 3,352,272 4,266,5285,333,160 $ 3,591,816 3,950,998 5,028,5426,285,678 $ 5,289,720 $ 5,818,692 7,405,608 $ 9,257,010 12 Head Accessories 14 Body Accessories Total 11,929,056 13,121,962 16,700,678 20,875,848 16 ACTUAL AND PROJECTED 18 REVENUES 19 20 Head Accessones Arm Accessories -Body Accessones 23 $9257,010 24 105508 s&818,692 25 s5289 720 26 27 28 Current Year Conservative Moderate Growth Ageressive 29 Expansion 31

There’s a lot of numerical information in this worksheet, so some visuals might help make the data easier to interpret. Insert Column Sparklines in the range G12:G14 based on data in the range C12:F14. Change the sparkline color to Green, Accent 6, Darker 50% (10^th column, 6^th row of the Theme Colors palette).

Answer 1

To insert Column sparklines,

1. In the worksheet, First select range of cells(G12:G14) where you want to place the Sparkline.

2. Now, Select Insert tab --> Sparkline --> Column. This will display a pop-up window where the data range is to be selected (C12:F14).

3. Click Ok. This will display the Column Sparkline in the corresponding cells.

4. To change the color of the Sparkline, Select the displayed Sparkline. This will show the Design tab. Click on the "Sparkline color" of the Style in Design tab.

5. Click on Green, Accent 6, Darker 50% (10^th column, 6^th row of the Theme Colors palette)