Question: Please answer only 8.2. 30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND

Please answer only 8.2.

Please answer only 8.2. 30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB

30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND MONTH VALUES UNIQUE IN THE EXCEL DISPLAY AS THE FOLLOWING: H1 2013 FOR THE FIRST SEMESTER OF 2013 Q1 2013 FOR THE FIRST QUARTER OF 2013 JANUARY 2013 FOR THE JANUARY OF 2013 Total Sales Column Labels +2010 + 2011 +2012 Row Labels + Accessories + Bikes + Clothing Grand Total 2013 H1 2013 Q1 2013 + February 2013 January 2013 March 2013 $12,587.75 $6,009.76 $16,520.54 $256,707.13 $313,576.75 $338,847.08 $5,401.45 $2,928.76 $6,844.62 $274,696.33 $322,515.27 $362,212.24 $1,080.76 $4,099.09 $1,481,936.71 $1,968,068.84 $274.89 $4,099.09 $1,481,936.71 $1,969,424.49 8.2 MAKE THE MONTHS IN THE RIGHT ORDER AS INDICATED BELOW: Total Sales GQ1 2013 Q1 2013 Total Row Labels + January 2013 February 2013 March 2013 + Accessories $19,049.71 $46, 246.09 $55,339.21 $120,635.01 + Bikes $829,911.35 $703,796.72 $967,773.46 $2,501,481.53 + Clothing $8,728.85 $21,305.93 $26,794.72 $56,829.50 Grand Total $857,689.91 $771,348.74 $1,049,907.39 $2,678,946.04 30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND MONTH VALUES UNIQUE IN THE EXCEL DISPLAY AS THE FOLLOWING: H1 2013 FOR THE FIRST SEMESTER OF 2013 Q1 2013 FOR THE FIRST QUARTER OF 2013 JANUARY 2013 FOR THE JANUARY OF 2013 Total Sales Column Labels +2010 + 2011 +2012 Row Labels + Accessories + Bikes + Clothing Grand Total 2013 H1 2013 Q1 2013 + February 2013 January 2013 March 2013 $12,587.75 $6,009.76 $16,520.54 $256,707.13 $313,576.75 $338,847.08 $5,401.45 $2,928.76 $6,844.62 $274,696.33 $322,515.27 $362,212.24 $1,080.76 $4,099.09 $1,481,936.71 $1,968,068.84 $274.89 $4,099.09 $1,481,936.71 $1,969,424.49 8.2 MAKE THE MONTHS IN THE RIGHT ORDER AS INDICATED BELOW: Total Sales GQ1 2013 Q1 2013 Total Row Labels + January 2013 February 2013 March 2013 + Accessories $19,049.71 $46, 246.09 $55,339.21 $120,635.01 + Bikes $829,911.35 $703,796.72 $967,773.46 $2,501,481.53 + Clothing $8,728.85 $21,305.93 $26,794.72 $56,829.50 Grand Total $857,689.91 $771,348.74 $1,049,907.39 $2,678,946.04

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!