60.1K

Verified Solution

Link Copied!

I missed question 12 by .33 points, with the following message "Clustered Column Chart" on the sheet "Sheet1", the "Source" was not set as per the instruction.

Based on the instructions I selected cells A3:F7 and created a Clustered Column. I am only working on one sheet so this picture shows everything on the excel sheet.

Does anyone know what the message means by source??

Gradebook Grade: 98.2% Score Card Detail Excel Ch 1 Grader Project 1G: Regional Sales Filter Incorrect Only Pr Step Instruction Earned Possible "Snee TIBET Other action(s) in this instruction were performed and scored correctly. 1.8 1.8 12 Select the range that represents the sales figures for the four quarters, including the quarter names and each region-do not include any totals in the range. With this data selected, by using the Recommended Chart command, insert a Clustered Column chart with the regions as the category axis and the Quarters as the legend, A 1.667 2 In the 'Clustered Column chart' on the sheet 'Sheet1', the 'Source' was not set as per the instruction 0 0.333 Other action(s) in this instruction were performed and scored correctly. 1.667 1.667 13 Apply Chart Style 8 and Color 3 under Colorful Position the chart so that its upper left corner begins in cell B10 2. B D G H 1 2 Trend S Quarter 1 225,684.50 $ 128,698.12 110,985.45 292,416.67 757,784.74 Pro Fit Marietta 2019 Regional Sales to Fitness Clubs Quarter 2 Quarter 3 Quarter 4 Total 210,760.45 $ 181,555.32 $ 228,634.85$ 846,635.12 144,465.29 132,106.81 155,874.75 561,144.97 118,674.91 100,548.50 120,621.17 450,830.03 247,941.48 262,774.12 291,698.99 1,094,831.26 721,842.13 676,984.75 796,829.76 2,953,441.38 % of Total Sales 28.67% 19.00% 15.26% 37.07% 100.00% 2019 Regional Sales to Fitness Clubs $1,200,000.00 $1,000,000.00 3 4 Northeast 5 Southeast 6 Midwest 7 West 8 Total Sales 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Y $800,000.00 $600,000.00 $400,000.00 $200,000.00 S- 1 2 3 4 Northeast Southeast Midwest West

Answer & Explanation Solved by verified expert

See Answer