FILES TO Be submitted TO Carmen PRELAB 2



CS&E 1111/1112 Pre Lab 3 Download from Carmen: Fund Raiser.xlsx ALL BEGINNING FILES MUST BE DOWNLOADED FROM Carmen OR THEY WILL NOT BE ACCEPTED. PART 1: Complete on SIMnet. Go to Carmen then to Modules then to McGraw Hill Campus then to SIMnet for your assignment for Prelab 3.Part 2: Do-Re-Me Bilingual Learning Center FundraiserYour daughter attends Do-Re-Mi Bilingual Learning Center in Seattle, Washington. You chair the annual popcorn fundraiser. Your job is to track the boxes of popcorn sold per grade, the amount of money to be sent to the distributor, and the amount of money the school earned. Your co-chair created a spreadsheet with the initial order information from the two-year-old classes. You need to insert formulas to calculate missing values and format the worksheet. In addition, you need to insert another worksheet for the three-year-old classes. You will be submitting this report to the Vice Principal at the end of the fundraiser. Open the file, Fund Raiser.xlsxType Popcorn Annual Fundraiser in cell A1. Merge and center the title from cells A1 to F1. Bold the title and select Arial Black font, 18 pt size, and apply Olive Green, Accent 3, Darker 50% font color.Insert a new row between Start of Sale: and Grade: Enter End of Sale: in cell A4. Type 10/31/2013 in cell B4, and then, if necessary, left-align the date.Enter Distributor Earnings %: in cell A6. Type 83% in cell B6, and align left.Add borders around A2:F6 as shown in the figure at the end of the document.Insert a new column between Amount Collected and School Total. Enter Distributor Total in cell E7.Enter Totals: in cell A13.Enter the Amount Collected formula for the Toffee Popcorn row. The amount collected is the number of boxes ordered for that type of popcorn multiplied by the price for that box. Copy that formula down the column for the other four popcorn types using the Fill Handle.Enter the Distributor Total formula for the Toffee Popcorn row. The distributor earns 83% from the amount collected as noted in cell B6. (Round the value to 2 decimal places.) Copy that formula down the column for the other four popcorn types.Enter the School Total formula for the Toffee Popcorn row. The school gets to keep whatever is left from the amount collected after taking out the distributor total. Copy that formula down the column for the other four popcorn types.Enter the Totals formula from the Amount Collected column in cell D13 by adding the amount collected for all five popcorn types. Copy that formula across the rows for the Distributor Total and School Total columns using the Fill Handle.Select cells A7:F7. Apply the following formats: Wrap Text, Bold, Center-alignment, Olive Green, Accent 3, Darker 50% font color, Olive Green, Accent 3, Lighter 60% fill color.Select cells A8:A12 and apply Bold format.Use the Format Painter to apply the formats from row 7 to the Totals row. Apply Comma Style with zero decimal places to the values in the Ordered column.Apply Currency Number Format with two decimal places to all monetary values.Select the range A7:F7 and apply the Top and Bottom Border style.Select the range A13:F13 and apply the Top and Double Bottom Border style.Copy the LC2 worksheet and place it to the right of the worksheet. Rename the copied worksheet LC3.Change the LC2 sheet tab to Light Green and the LC3 sheet tab to Green.Change the following data in the LC3 worksheet: change Grade to LC3, change Toffee Popcorn Ordered value to 2100, the Kettle Corn Ordered value to 2250, the Extra Butter Popcorn Ordered value to 1856, the Movie Theater Popcorn Ordered value to 1523, and the No Frills Popcorn Ordered value to 1245.On each of the two worksheets, center the data horizontally on the page, and insert a header with your name of the left side, the sheet name code in the center and the current date code on the right side.Copy the LC3 worksheet and move to end. Rename the copied worksheet Formulas.Display the cell formulas for the Formulas worksheet.Select options to print the gridlines and the row and column headings.Adjust the column widths for the Formulas worksheet and change to landscape so that the formula printout would print on one page. Select the range A1:F13 and Copy as Picture.Clear All on the worksheet and Paste the picture.Save and close the workbook.-11620514097000FILES TO Be submitted TO Carmen PRELAB 2Fund Raiser.xlsx ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download