Problem 1: Basic Calculations
On Worksheet #1, calculate and report the
a) $ __________________ Average revenue
b) $ __________________ Total Expenses
c) $ __________________ Pret’s profit
d) __________________ Store with the highest profit
e) $ __________________ Total Profit
Problem 2: Pivot Table
On Worksheet #2, calculate and report the
a) __________________How many tents were sold in Oregon?
b) $__________________Total sales of backpacks?
c) __________________Which state had the lowest total wholesale price for headlamps?
d) __________________How many sleeping bags were sold?
e) $__________________What is the sale price of car racks sold in Washington and California?
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) $__________________ Net income
b) $__________________ Net income if travel increases to $25,000
c) $__________________ Insert an operating expense called “Transportation Costs” at $13,500 and increase utilities to $9000. What is the new net income?
d) $__________________ Taxes if the tax rate is 10%
e) $__________________ Gross profit
Problem 4: Breakeven Analysis
On Worksheet #4, calculate and report
a) $__________________ Total costs
b) $__________________ Profit
c) __________________ Breakeven point
d) __________________ Breakeven point if the fixed cost is $10,000
e) $__________________ Fixed cost if the breakeven point is 700
Problem 5: LOOKUP & COUNTIF functions
On Worksheet #5, calculate and report
a) __________________ What is the average review score for all students
b) ____________________________________ Report the lookup function to categorize students as above or below average (average is the mean review score in the question a) )
c) __________________ How many students are above average
d) __________________ How many students are below average
e) ____________________________________ Report the function used to calculate the number of above average students
Get Free Quote!
348 Experts Online