Computers
posted by Megan .
How to do Excel Spreadsheet Formulas?
I have to do an excel spreadsheet for my computer class. Problem is my professor didn't at all explain how to do it. What formulas am I supposed to use! Please Help. The info he gave us are : Cash Sales: 56%, Rec. Last month: 28%, Rec. Last 2 months: 16%, COGS: 29%, Sales Tax: 6%, Income Tax: 22%, Rent: $5200, Fixed selling cost: $2000.
Jan: $55,000 Feb $69,000 March $82,000 Apr $64,000 May $ 58,000 Jun $47,000 Jul $41,000 Aug $ 46,000 Sep $52,000 Oct $68,000 NOV $57,000 DEC $86,000.
I have to find the Total Sales, total cash sales, cash from receivables. total cash in, COGS, selling cost, sales tax, monthly rent, income tax, total cash out, net cash in(out), cash position, positive cash flow?, net cash rank, average of 12 months sales, highest of 12 months sales, lowest of 12 months sales.
I'm not asking for anyone to do it but to please shed some light on how to do it. We have to use formulas in excel to come up with the numbers. If anyone knows a website to help me or knows how to themselves it would be greatly appreciated. Please help! Thanks so much!!

Here is a wide variety of Excel tutorials online, including some on video:
http://www.google.com/search?rlz=1C1GGGE_enUS379US379&sourceid=chrome&ie=UTF8&q=excel+tutorials
If any are searchable, be sure to search for FORMULAS or something similar to focus the tutorial on what you need at the moment.
Respond to this Question
Similar Questions

Computer Math
Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %? 
Computer Applications
An Excel workbook can contain more than one workshet. Give two examples of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer. Please help. I am lost when it comes to excel!! 
Excel spreadsheet
I have filled in an Excel spreadsheet. On the far left column are itemized numbers from 1619. When I print the document, the far left column of itemized numbers does not print. How do I tell the computer to print the far left column … 
computers
The President of the Company has asked you to replace the computers in every department. The researched information must be presented in this format: A memo to the president stating the need to replace the computers. An Excel spreadsheet … 
Earth Science
I need help with the following Lab due tonight, 7/30/12, as I feel completely lost and would appreciate the help. The lab goes as follows: Design an experiment that illustrates the determination of the density of a cylindrical object … 
Computers
What are calculations entered into a spreadsheet called? 
computers
what are calculations entered into a spreadsheet called is it formulas or values i think formulas am i correct? 
Microsoft Excel
The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result? 
computer applications
John wants to see the formulas he has used in his spreadsheet but he does not want to see the results of the formulas. How does he display his formulas? 
Intro to computers
You are an inexperienced Excel user and don’t know how to create your own formulas. You want to use one of the preconfigured formulas but it doesn’t appear in the Formulas tab ribbon. What can you do?