no
yes
To copy and paste a formula in a spreadsheet application like Excel, first select the cell containing the formula you want to copy. Then, right-click and choose "Copy" or use the keyboard shortcut Ctrl+C (Cmd+C on Mac). Next, select the destination cell where you want to paste the formula, right-click again, and choose "Paste," or use Ctrl+V (Cmd+V on Mac). If you want to maintain the relative references, simply paste; for absolute references, ensure to adjust the formula as needed before pasting.
The absolute sign($), is used specially when you write an equation or any other thing in excel, and you want to copy it into other cells. If you write "=E3+F3" in a cell, that cell will show the addition of E3 and F3. If you copy and paste to the cell below that, the equation will automatically change into "=E4+F4", also, if you copy that into the cell to the right of the first one, equation will change into "=F3+G3". The absolute sign ($), avoids that, if you right that before the row or column (e.g. F$3 or $F3 or $F$3) the row, or column, or both, won't change when you copy and paste the equation.
Moving Text
If you need to do the same task repetitively, you copy a formula to do it. When working on a spreadsheet you commonly need to do this. You may be calculating wages for one person, and when their wage is calculated, you would copy the formulas used to do the calculations for other people. You could have a list of sales in a particular month. You may want to add all of them or get an average, and then do the same for other months. Once you have the first formula done, it can be copied to do the same for all of the other months, saving you having to do each month individually.
Usually when you need to copy and paste, there is no need to use Paste Special. It is only used when you want to do something more unusual when you paste. If whatever you are copying is going to a new location in the same format as it was in its original place, which is normally the case, then the standard Paste is sufficient.
Hit Ctrl V ---------------------- An alternative to clicking the Paste button is to press the Enter Key. The Enter Key completes the paste operation, removes the marquee from the source area, and disables the Paste button so that you cannot paste the copied source area to other destination areas. PAGE EX153 Microsoft Office 2010
To make a magnesium sulfate paste, also known as Epsom salt paste, mix magnesium sulfate (Epsom salt) with a small amount of water until you achieve a paste-like consistency. Add the water slowly to avoid making the paste too runny. Apply the paste topically to the affected area for various health benefits, such as soothing muscle aches and reducing inflammation.
The cell reference will maintain itself if it is an absolute cell reference. This is being done by having two dollar signs, one before the cell column and one before the cell row, like this: $F$3
they provide from peopl;e so thats how they get money
As long as you cite the references you are good to go. I do it all the time.
No, they do not accomplish exactly the same task. Copy and paste makes a copy of the highlighted text to the clipboard while paste puts that copied data on the clipboard at the new location. Move (which is actually a cut and paste operation) removes the original from its current location and then pastes it to the new location where the paste command is executed.