Search for question
Question

# Complete all tasks based on Module 2, Module 1, Module 3, and Module 4 learnings on the First Quarter Analysis worksheet. All cells highlighted in yellow must be formulas (excel tools).

1 Complete First Quarter Revenue with a formula that does not add Jan thru Mar individually

2 Calculate % Increase or Decrease. It's not a subtraction, hope you watched the video.

3 All values with \$ should be in accounting, rounded to the 100th place, and all percentages %, rounded to the 10th place.

4 Use the IF function to determine if you should expand to a 2nd café. Use "Yes" for regions that exceeded your target % increase and "No" for regions that did not reach your target % increase.

5 Use the AND function to determine if store employees will be eligible for a bonus. Employees are eligible if their store exceeds your target % increase and holds a quality rating greater than or equal to 4.

6 Your formulas in columns I:J should contain absolute cell references around your target % increase.

7 Use an excel function to calculate how many cafés you have rated.

8 In one formula, using excel tools, provide an average quarter revenue + add the ROUND function to round your average revenue to the nearest whole number.

9 Use Date & Time in formulas to determine today's date.

10 Insert a 3-D Column chart with gridlines to showcase first quarter revenue values on the Y axis (vertical) and the regional cities in a way where you don't have to manually label cities on your X axis (horizontal).

11 Move your chart to a new worksheet titled First Quarter Revenue following First Quarter Analysis & change tab color to blue.

12 Add title to the chart "First Quarter Revenue" 24 point font size, provide axes "Revenue" and "Us Cities" 16 point size

13 Adjust first quarter revenue values \$ using chart elements, so there is no decimal point

14 Change bar chart columns to green

15 Add sparklines (lines) in column K to show each store's three-month trend

16 Add to the sparklines high point to be BLACK and low point RED.

17 Change sparklines to green.

18 Include your name in the "Analysis Completed By" and Save file name as "Advanced Learning Activity 3 - MRCH 1950 - Student Name" (replace "Student Name" with your name) and submit on Canvas.Complete all tasks based on Module 2, Module 1, Module 3, and Module 4 learnings on the First Quarter Analysis worksheet. All cells highlighted in yellow must be formulas (excel tools).

Fig: 1