This question "In MS Excel, getting data from a cell located in a different sheet is called ... a) Accessing b) Updating c) Referencing d) Functioning" was asked in Computer Operator Examination of 2074 conducted by PSC.
The question is about general introduction to spreadsheets and MS Excel. More specifically, it aims to test candidates knowledge about the terminology used in MS Excel.
In MS Excel, getting data from a cell located in a different sheet is called...
Show Your Love! Share this page!
The question is about getting data from a cell that is located in a different sheet than currently working one. And the options given are accessing, updating, referencing and functioning.
Accessing simply means the way to reach up to the data. Updating is to change the data currently stored in the targeted location into something new value. Referencing is to provide the address so as to get those data in current cell. Finally, functioning should mean to use Excel functions to perform required calculation.
Referencing can be done in absolute, relative and mixed fashion. Relative referencing addresses the targeted cell in relation to the currently working cell or active cell. The relative cell references may be composed by Column Name and Row Number if it is in same sheet such as B15. However, if it is in other than current sheet, you'll need to refer the sheet name and then cell address such as Sheet3!B15
Other Explained Questions
Other Related Questions:
- getting data from a cell located in a different sheet in the same workbook is called
- which of the following is not a valid data type in excel
- which menu option can be used to split windows into two in ms excel 2010
- which menu option can be used to split window into two in ms excel 2010
- which button do you click to add up a series of numbers in ms excel
- which function is used to calculate the total characters in a cell
- what is the shortcut key to insert hyperlink in a document
- getting data from a cell located in a different sheet in the same work book is called