Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedHello, 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 profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Customer Base Audit The First Step On The Journey To Customer Centricity

Authors: Peter Fader, Bruce G.S. Hardie, Michael Ross

1st Edition

1613631618, 978-1613631614

More Books

Students also viewed these Accounting questions

Question

5. Identify and describe nine social and cultural identities.

Answered: 1 week ago

Question

2. Define identity.

Answered: 1 week ago

Question

4. Describe phases of majority identity development.

Answered: 1 week ago