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 shop-ID number(ID number = your ID/roll number)
My ID: 015062266