microsoft office

1. Add labels to worksheet

· Cell A4 - "Subscriptions by Game"

· Cell A12 - "Top Game"

· Cell A14 - "Profit by Game"

· Cell G4 - "Top Quarter"

· Cell G14 - "Comparisons"

2. Insert formulas/functions

· a. Cells B11, C11, D11, and E11 – Use a formula/function to calculate Total Sales for each quarter

· b. Cells B19, C19, D19, E19, and F19 – Use a formula/function to calculate Profit for each game. (Profit = In-game Purchases – Operating Cost – Labor Cost) e.g. “B16-B17-B18”

· c. Cells F6, F7, F8, F9, and F10 – Use a formula/function to calculate total Game Subscription Sales for the year at Blizzard

· d. Cells B20, C20, D20, E20, and F20 – These cells hold the Margin for each game. (Margin = Profit/In-game Purchases) e.g. B19/B16

3. Format worksheet Your solution should look something like this

· Cells A1 through F1 (A1:F1) - Merge and Center cells

· Cell A1

· Apply Title cell style

· Bold the text

· Cells A2 through F2 (A2:F2) - Merge and Center cells

· Cell A2 - Apply Heading 2 cell style

· Cells A4, A14, G4, and G14

· Bold the text

· Change font size to 14-points

· Change font color to Orange, Accent 2

· f. Cells A4:C4 and A14:C14 – Merge cells (do not center)

· Cells A5:F5 and A15:F15 - Apply Heading 3 cell style

· Cells A11:F11 and A19:F19 - Apply Total cell style

· Cells A6:A12, F6:F10, A16:A20, and B20:F20 - Bold the text

· Cells B6:F11 and B16:F19 - Apply Currency number format

· Cells B7:F10 and B17:F18 - While retaining the Currency number format, turn-off the "$" symbol

· Cells B20:F20 - Apply Percentage number format

· Auto-resize all columns to ensure content in cells is visible and not "clipped" or hidden

· Row 6 through Row 10 - Manually increase height to 40 pixels (24.00 units)

· Row 12 - Manually increase height to 80 pixels (48 units)

· Row 16 through Row 19 - Manually increase height to 40 pixels (24.00 units)

4. Insert Sparklines

· Cell G6 - Insert Column Sparkline to show the top quarter for each game. (B6:E6)

· Toggle Sparkline High Point

· ii. Change style to Ice Blue, Sparkline Style Dark #1 – 5th Row 1st Column

· Use Cell G6's fill handle to copy Line Sparkline to cells G7:G10

· Cell B12 - Insert Column Sparkline to show the top game for each quarter. (B6:B10)

· Toggle Sparkline High Point

· ii. Change style to Ice Blue, Sparkline Style Dark #1 – 5th Row 1st Column

· Use Cell B12's fill handle to copy Column Sparkline to cells C12:E12

· Cell G16 - Insert Line Sparkline to compare income and expenses among games (B16:F16)

· Toggle Sparkline Markers

· ii. Change style to Ice Blue, Sparkline Style Dark #1 – 5th Row 1st Column

· Use Cell G16's fill handle to copy Column Sparkline to cells G17:G18

5. Review and submit document

· Save your work

· Close Microsoft Excel

##2

1. Add labels to worksheet

· Rename worksheet tab as your last name

· Cell A1 - "Grade Calculator"; press Alt + Enter, then type your name

· Cell A2 - "CSCI-1100-XXX" (where XXX is your course section number)

2. Enter grades from D2L

· Log into D2L, and navigate to your grades for CSCI-1100.

· Enter your grades into your worksheet in the appropriate cells (rows 4, 7, and 10).

· If an item has not been graded, leave the corresponding cell blank

· If you have received a zero for a graded item, enter "0" in the corresponding cell (failure to do so will skew your calculations)

3. Insert formulas/functions

· Cell B13 - Use the AVERAGE function to calculate your Attendance average

for WK01 through WK15

· Cell B14 - Use the AVERAGE function to calculate your Homework average

for HW01 through HW23

· Cell B15 - Use the AVERAGE function to calculate your Quiz average

for Q01 through Q10

· Cell B17 - Enter a formula to calculate your Weighted Grade, based on your Attendance weighted average (cell B13), Homework weighted average (cell B14), and Quiz weighted average (cell B15)

· The category weights are provided in cells B20, B21, and B22.

· This website has a good explanation for calculating a weighted average:  How to Calculate a Weighted Average

4. Format worksheet

· Cells A1:X1, A2:X2, A12:B12 - Merge and Center cells

· Cell A1 - Heading 1 cell style

· Cell A2 - Heading 2 cell style

· Cell A3, A6, A9, A12 - Heading 3 cell style

· Cells B3:P3, B6:X6, B9:N9, A13:A15,A17 - Bold

· Cells B13:B15, B17 - Format values to show 1 decimal place

· Apply a theme to the worksheet (do not use the default "Office" theme)

· Auto-resize all columns to ensure content in cells is visible and not "clipped" or hidden

5. Review and submit document

· Save your work

· Close Microsoft Excel

  

· For extra credit, conditionally format all of your Attendance, Homework, and Quiz grades

· If the grade is greater than or equal to 90, the cell's fill color will be green; the text will be white and italicized

· Do NOT simply change the formatting manually - that is not conditional formatting

###3

My Amazing Vacation
Location Expenses
City	Purchases	Transportation	Hotels	Food	Totals		Step 1:	Replace "My" with your first name (possessive of course)
New York	5517	500	3300	1500			Step 2:	Merge and center A1:F1, Font size 20, Bold
London	3211	450	5600	1350			Step 3:	Merge and center A2:F2, Font size 18, Bold, Bottom Border
Tokyo	2899	750	9500	1150			Step 4:	Center & bold range A3:F3, Bold A11
Beijing	1766	600	4500	1050			Step 5:	Italicize range A4:A10
Sydney	2230	350	4400	1250			Step 6:	Use AutoSum to calculate the total for New York in cell F4
Hawaii	2575	400	4750	1400			Step 7:	Use Fill handle to fill the totals through F10
San Francisco	1890	300	3250	1000			Step 8:	Use AutoSum to calculate the total for purchases in cell B11
Totals							Step 9:	Use the Fill handle to fill the totals through F11
							Step 10:	Resize row 12 to 80 pixels high (60 units)
							Step 11:	Insert a Line Sparkline into B12 for the range of B4 to B10
							Step 12:	Use fill handle to fill sparklines through F12
							Step 13:	Save the workbook (filename lastnamefirstnameq08) and submit to the drop box