0
How do you make an excell spreadsheet that automatically averages the latest 12 enteries and ignores data entered before that?
Wiki User
∙ 15y ago
Assuming that your entries are in Column B from Row 1 onwards, put this formula in cell C12:
=IF(B12>0,AVERAGE(B1:B12),"")
Use the Fill Handle to drag the formula as far down the worksheet as you want and it will automatically increment to B2:B13, B3:B14, etc. Nothing will appear in a cell in Column C until the cell to its left contains data.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
Alphabetic data entered into a spreadsheet?
Text.
A spreadsheet calculating the sum of 10 numbers entered into spreadsheet cells is an example of?
A formula. It can also be a function.
Why a shopkeeper wouldn't use a spreadsheet?
Some smaller shopkeepers may not actually need to use a spreadsheet. A spreadsheet is only as good as the information entered into it.
The difination for entry bar?
An entry bar is the feild in a computer where data is entered in a spreadsheet! :) Chow, JamES An entry bar is the feild in a computer where data is entered in a spreadsheet! :) Chow, JamES
What is the spreadsheet cell into which data is being entered called?
It is the active cell.
A number or date entered into a cell of a spreadsheet is called a?
Data
In excell a cell can contain a formula?
Yes, formulas are entered into cells in a spreadsheet.
What can be entered into spreadsheets?
Three types of data may be entered into a spreadsheet or worksheet: (1) values or numbers, (2) names or labels, and (3) formulas for calculation.
Clem has entered the following formula into his spreadsheet VLOOKUP(A5A7G203TRUE). What advanced feature is he using?
lookup table
How do you write a sentence by using the word formula?
After a few minutes thinking out about it he worked out what the formula should be and entered it into the spreadsheet.
What is a program that allows a user to enter rows and columns of numbers into main memory and to perform calculations on the numbers that have been entered?
The program is a Spreadsheet. eg Microsoft Excel
Which key edits something previously entered in a cell in spreadsheet?
Pressing the F2 key will start editing the active cell.
