Question about Microsoft Office Standard for PC

1 Answer

Excel I need to enter a formula to calculate a moving annual average on a spreadsheet. Helpppppp

Posted by on

  • maryala Dec 08, 2008

    what is advance filter?
    example wiht example.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

The Data Analysis Add-in has a Moving Average fuction and wizard. Moving Average

Posted on Aug 31, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

I need to know how many gallons of water are in my pool


Formula For Average Gallons In Rectangle, Square Or Freeform Pools:
Length x Width x Average Depth x 7.5 = Total gallons
Formula For Average Gallons In Circular Pools:
Diameter x Diameter x Average Depth x 5.9 = Total gallons
Formula For Average Gallons In Oval Pools:
Length x Width x Average Depth x 5.9 = Total gallons
Formula For Average Depth Of Pools With Slopes:
Shallow End Depth + Deep End Depth Divided by 2 = Average Depth

Jun 18, 2017 | Pool & Spa

1 Answer

How to Calculate NPV?


NPV stands for Net Present Value. Using this scientific calculator, you must utilize a formula to calculate net present value.

For example, if we want to find out what the net present value of $10,000 is using a 4% annual interest rate for 10 years. In other words, what amount do we have to invest today for 10 years assuming we get a 4% annual interest rate.

NPV=10,000(1+0.04)^-10

To do the exponent, use the ^ key.

Good luck.

Paul

Feb 26, 2016 | Texas Instruments Ti 30x Iis Scientific...

1 Answer

On Casio FX-115ES Plus Calculator, what buttons do I push to do compound interestsemiannually for 15 years?


There is no such button. You must figure out the formula and enter it, giving the appropriate value for the annual interest and the number of years (15).

Sep 27, 2014 | Casio fx-115ES Plus Scientific Calculator

1 Answer

How to calculate an average on a cell by cell basis ?


In cell B1 put the formula =AVERAGE(A$1:A1)
Copy the formula then paste it into cells B2 through B5000

You can use any other column, of course.

Jul 22, 2014 | Microsoft Excel Computers & Internet

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

3 Answers

NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D


Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

1 Answer

Spreadsheet formulaes


1. enter = symbol
2. enter ( symbol
2. enter cell location where your cost value is
3. enter * symbol
4. enter 0.7
5. enter ) symbol
6. enter 0.175


eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

1 Answer

Average handle time


I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Spreadsheets


You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!

Mar 03, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

167 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...