Excel Assignment
Task 1
1. Write Pizza shop for Heading name at row 1
2. Merge cell A1 to E1, make cell style Heading 1
3. Enter data shown below –
4. Make whole Ingredients headings cell style Heading 3
5. Set Highlight Cell Rules red color for all $0.00 values.
Task 2
1. Find Cost of Pizza for Everything, Vegetarian, Pepperoni, Cheese
2. Find Menu Price for Everything, Vegetarian, Pepperoni, Cheese (Calculation will be in formula bar)
Formula: If cost of pizza is less or equal to $4.00, then menu price = cost of pizza * 1.5
Or if cost of pizza is greater than $4.00, then menu price = cost of pizza * 2
3. Find the Profit for Everything, Vegetarian, Pepperoni, Cheese
4. Show a pie chart on Ingredient cost for Everything pizza.
· Title Percentage of ingredients in Everything pizza
· Show data label in only percentage, label position Outside End
· Legend on right side
5. Save it naming Pizza s
Recent Comments