Final Exam
Spring 2006
- Start by downloading This Workbook
- When you are finished, print the powerpoint slide show, six slides per page and mail a copy of the worksheet to dbennett@edinboro.edu. If you fail to perform one of these actions, 10% will be deducted from your test.
- This contains information from www.tacobell.com.
- I have numbered the menu items in column a.
- Item descriptions are in column b.
- Nutritional data is stored in columns c-x.
- Put your name in cell A1 of every worksheet.
- Worksheet Formatting, 5 points.
- Place your name in cell A1.
- Rotate the labels in C2-X2 so that they are visible.
- Apply a background color to All Text labels (A2-X2 and A2-B96)
- Apply a border cells C3-X96), it should be 5 point wide.
- Insert a new row between 1 and 2, add the title "Taco Bell Nutrition Information", Center this over the table in a single cell.
- Make the title 28 point, bold.
-
- Graphs 10 points
- Insert a new worksheet, label it graphs.
- Place your name in cell A1.
- For the first 17 items, create a bar chart that compares
Total Fat, Cholesterol and Sodium. Make sure that your chart has a title, and the items are labeled.
-
- Make a pie chart to display the information about a taco. Make suer that the chart has a label and a legend.
-
- Table Lookup 15 points.
- Change to the Tables worksheet.
- Place your name in cell A1.
- For all information, retrieve it from the Taco Bell Menu worksheet using a lookup function.
- Fill in the description field for each item.
- Calculate the total calories for each item.
- Calculate the total % RDA for calories for each item.
- Calculate the total Cholesterol for each item.
- Calculate the total % RDA for Cholesterol for each item.
- Calculate the total sodium for each item.
- Calculate the total % RDA for sodium for each item.
- Calculate the total number of items, as well as the total calories, cholesterol and Sodium, as well as %RDA for each of all items ordered.
Place this in row 8.
- In row 9, for each RDA, print OK if it is less than 100 and BAD if it is 100 or more.
-
- Financial Functions 5 points.
- Change to the Franchise Information worksheet.
- Place your name in cell A1
- Compute the monthly payment for starting a franchise with the
given conditions.
- The total cost is the sum of all costs B3-B10.
-
- Power Point 15 points.
- Create a power point slide show.
- Create a title slide, with your name, CSCI 104 and Spring Final exam on it.
- Create a Second slide, place the graphs from the worksheet on it.
- Create a third slide, place Tables worksheet on this slide,
it should be in formula view, and the entire formulas from columns C,D and E should be visible.
- Create a fourth slide showing A13-B21 of the Franchise Information worksheet in formula view. All formulas should be visible.
- Create a fifth slide,
- Add a link to http://www.yumfranchises.com/overview.asp?cpage=start_up, cite this as the source for Franchise Information
- Add a link to http://www.tacobell.com/, cite this as the source for the nutrition information.
- Add a picture which includes the Taco Bell Logo.
- When you are finished, print the powerpoint slide show, six slides per page and mail a copy of the worksheet to dbennett@edinboro.edu. If you fail to perform one of these actions, 10% will be deducted from your test.