Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I don't need answers. PLEASE tell me how do you do these in Excel??? Problem 1: Basic Calculations On Worksheet #1, calculate and report
Hello, I don't need answers. PLEASE tell me how do you do these in Excel???
Problem 1: Basic Calculations On Worksheet #1, calculate and report the Problem 4: Breakeven Analysis On Worksheet #4, calculate and report a) $ Average revenue a) $ Total costs b) Total Expenses b) Profit c) $ Paris store's profit C) Breakeven point Store with the highest profit d) Breakeven point if the fixed cost is $10,000 e) S Total Profit e) $ Fixed cost if the breakeven point is 700 Problem 2: Pivot Table On Worksheet #2, calculate and report the Problem 5: LOOKUP & COUNTIF functions On Worksheet #5, calculate and report a) How many dresses were sold in Paris? a) Average review score for all employees b) Total sales of accessories? Report the lookup function to categorize b) employees as above or below average c) What items were sold on May 2, 2015? c) How many employees are above average d) Which item had the lowest sales? d) How many employees are below average e) $ _What was the sales amount of all clothing in Milan? Report the function used to calculate the number e) of above average employees Problem 3: Income Statement On Worksheet #3, complete the income statement. Report the following. Work through without pushing undo" (leaving any previous changes the way they are): a) S Net income b) S Net income if marketing expenses increase to $15,000 c) $ Insert an operating expense called "Transportation Costs at $9,500 and increase utilities to $2200. What is the new net income? d) $ Taxes if the tax rate is 10% e) $ Gross profit Problem 1: Basic Calculations On Worksheet #1, calculate and report the Problem 4: Breakeven Analysis On Worksheet #4, calculate and report a) $ Average revenue a) $ Total costs b) Total Expenses b) Profit c) $ Paris store's profit C) Breakeven point Store with the highest profit d) Breakeven point if the fixed cost is $10,000 e) S Total Profit e) $ Fixed cost if the breakeven point is 700 Problem 2: Pivot Table On Worksheet #2, calculate and report the Problem 5: LOOKUP & COUNTIF functions On Worksheet #5, calculate and report a) How many dresses were sold in Paris? a) Average review score for all employees b) Total sales of accessories? Report the lookup function to categorize b) employees as above or below average c) What items were sold on May 2, 2015? c) How many employees are above average d) Which item had the lowest sales? d) How many employees are below average e) $ _What was the sales amount of all clothing in Milan? Report the function used to calculate the number e) of above average employees Problem 3: Income Statement On Worksheet #3, complete the income statement. Report the following. Work through without pushing undo" (leaving any previous changes the way they are): a) S Net income b) S Net income if marketing expenses increase to $15,000 c) $ Insert an operating expense called "Transportation Costs at $9,500 and increase utilities to $2200. What is the new net income? d) $ Taxes if the tax rate is 10% e) $ Gross profitStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started