Microsoft Excel Questions and Answers
All downloads are temporary disabled so please wait and check later we are updating pdfs.
Microsoft Excel Questions and Answers: Submit Your Question
Relative reference: This is the normal way we write a formula or function. In excel when we copy a formula by default it will change reference automatically. For ex we have data from A1 to A10 in cell A11 when we use a function sum (Sum(A1:A10)), it will return total of values given in A1 to A10. When we copy the function given in A11 and paste it in B11 the function will be (sum(B1:B10)) that will return total of values given in B1 to B10. This is called relative reference.
Absolute reference: In this scenario even if we copy a formula the reference will not change. We make this happen by using $ symbol in function syntax. Going y previous example instead of the above syntax if I use sum($A$1:$A$10), even if I paste the formula in B11 it will continue to give me total of values present in A1 to A10.
Mixed reference: In mixed reference we will only lock in either row or column that means we use $ symbol to fix either row or column and leave other one as relative reference. For ex sum(A$1:A$10) this formula when I copy and paste in B11 it will be changed to sum(B$1:B$10) but when I paste same formula in A33 it will not change.
* The general tool in SAP for data upload is the Batch input / call transactions
In the batch input file you specify screen by screen and field by field the input to SAP.
SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.
In olden days we have Lotus 123, it is also having spread sheets for using accounts purpose. Now excel having spread sheets not only accounts purpose but also for various types of formats with calculations.
* Select your file through the file open box (CTRL+O)
* Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
* Click the arrow and select OPEN AS COPY.
* Now you could be having a copy of the original version of the file.
You can access this file through the path D:/Copy(1) of test.xls. You can always rename and copy your file somewhere else but by default Excel saves the copy of the file in the same drive. Also, Excel duplicates the original file and whatever is in the original file, it is copied including formats, formulas and other functionalities.