Homework Help: Solved 101952

I’m studying and need help with a Business question to help me learn. Spreadsheet requirements Complete the spreadsheet using the correct formulas to fill in the missing data: In the ‘Ordering raw data’ table, complete the ‘Equiv litre per crate/carton’ column. Also complete the ‘Supplier price per unit’ and ‘Retail Sale price per unit’ columns. In the ‘Milk products’ table, complete the ‘Supplier price per unit’ column. Complete the milk production table The formulas required to reveal the missing data include VLOOKUP and SUMIF. Absolute addressing is also required. Spreadsheet graphs You are also required to create three graphs: Create a column chart: show total orders by customers for Week 32 for all 3 years (2016-2018). Create a column or pie chart: by using the milk production data, create a chart illustrating these figures. Create a column or pie chart. Your choice: This chart can reflect an element from any of the data tables that you feel will add value to the user. All graphs must be dynamic to show visible changes instantly when the data is altered.