InstructionsExam EnvironmentExam Interface and ControlsThe exam panel provides access to the project task(s).

here is the step-by-step solution for Task 1:

Step 1: Navigate to the Correct Worksheet

Click on theQtr 2worksheet tab at the bottom of the Excel window to ensure you are working on the correct data set.

Step 2: Insert the Column Sparkline

Click on cellF10(this is where the first sparkline will reside).

Go to theInserttab on the Ribbon.

In theSparklinesgroup, click onColumn.

A dialog box will appear. ForData Range, select the cells representingApr through Junfor the first row (likelyB10:D10).

Ensure theLocation Rangeis set to$F$10.

ClickOK.

Step 3: Apply the Specific Sparkline Style

With cellF10still selected, a newSparklinetab will appear at the top of your Ribbon.

Click on theSparklinetab.

Click theMorearrow (the small downward arrow at the bottom right) of theStylesgallery to see all options.

Hover over the styles to find the specific name:Gold, Sparkline Style Accent 2, Darker 25%.

Click to apply it.

Step 4: Copy the Sparkline to Remaining Cells

Select cellF10.

Hover your mouse over theFill Handle(the small green square in the bottom-right corner of the cell).

Click and drag the handle down to cellF14.

Excel will automatically generate sparklines for the other locations (Downtown, Eastside, etc.) using the same style and corresponding data rows.