1. Complete the missing information (yellow cells) with thefollowing accounting formulas:
a) Gross Profit: Net Sales minus Cost of Sales.
b) Total Operating Expenses: The sum of Fulfillment, plusMarketing, Technology and content, plus General and administrative,plus Other operating expense.
c) Operating Income or Loss: Gross Profit minus Total OperatingExpenses.
d) Earnings Before Interest and Taxes: Operating Income or Lossplus Total Other Income/Expenses Net. (Note: The / symbol is justpart of the expression Income/Expenses.)
e) Income Before Tax: Earnings Before Interest and Taxes minusInterest Expense.
Create the following charts:
a) 3D Clustered Column Chart: Include Gross Profit and TotalOperating Expenses for the three years available. Change the charttitle