answersLogoWhite

0


Best Answer

Excel has the FORECAST function, but the quality of the forecast will depend on how well the data fit you model.

User Avatar

Wiki User

โˆ™ 2013-08-09 10:39:12
This answer is:
User Avatar
Study guides

Algebra

20 cards

A polynomial of degree zero is a constant term

The grouping method of factoring can still be used when only some of the terms share a common factor A True B False

The sum or difference of p and q is the of the x-term in the trinomial

A number a power of a variable or a product of the two is a monomial while a polynomial is the of monomials

โžก๏ธ
See all cards
3.8
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
2250 Reviews

Add your answer:

Earn +20 pts
Q: What Excel formula would you use to calculate forecasts of monthly sales?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


What is auto calculate in Excel?

Allows Excel to automatically calculate formulas in real time. When a referenced cell changes, the formula automatically updates.


How do you calculate a particular formula in an Excel worksheet?

It depends on the formula you choose. If you have autocalculate turned on (default setting) you will not need to do anything after you enter the formula; Excel will calculate automatically any time related cell values change.


What is a mathematical statement used to calculate a value called in excel?

A formula.


What is it called when you want to calculate something in Excel?

It is called creating a formula.


How do you change formula to calculate sum in Excel?

Delete the current formula and then use the Auto Sum to put in the sum formula.


Mathematical equation assigned to a cell that Excel uses to calculate a result?

formula


What is the formula used to calculate result in Microsoft Excel?

The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.


What type of software would be best suited to help calculate a monthly budget?

A spreadsheet such as Microsoft Excel or Open Office Calc.


What is the Excel formula to calculate the total of values in cells d7 through e20?

=SUM(D7:E20)


How do you calculate a square root of a number in Excel?

You calculate square root in Excel using the Sqrt() function. for example: If the value of A1 is 81 and A2 contained the formula "=Sqrt(A1)", The number 9 would be displayed.


What does Excel do when a formula is copied into a cell?

If auto-calculation is turned on, it will calculate the formula and display the value. If the formula is composed of relative cell addresses, it will adjust the formula cell references relative to the current location.

People also asked