Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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??
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Crime Investigation And Control

Authors: K. H. Spencer Pickett, Jennifer M. Pickett

1st Edition

0471203351, 9780471203353

More Books

Students also viewed these Accounting questions

Question

My opinions/suggestions are valued.

Answered: 1 week ago