Question Bank - ICT

Here's the question bank on all the ICT topics.

Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text
Button Text

In MS-Excel, what is the absolute address of the cell at the intersection of the twelfth column and the fifth row?

A.
$L5
B.
$L5$
C.
M$5
D.
$L$5

Solution:

The correct answer is $L$5. Cell Address:The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its €œaddress€) by taking the row number and column letter. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula. In the above example since it says twelfth column it will be L and the fifth row so it will be 5. Hence, the correct answer is $L$5.

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.