Banking Computers NICL Assistant Online Exam Held on 12-04-2015

  • question_answer How to specify cell range from A9 to A99 in Excel?

    A) (A9:A99)          

    B)  (A9 - A99)

    C)  (A9 to A99)      

    D)  (A9A99)

    E)  (A9 = A99)

    Correct Answer: A

    Solution :

    [a] To Select a Range with the   Name box, a user needs to type in the first and last cell address of the range he wants to select, with a colon between them, then hit enter. The first cell is the top left of the range and the last cell is the bottom right. So the cell range from A9 to A99 in Excel can be specified with the help of (A9: A99).


You need to login to perform this action.
You will be redirected in 3 sec spinner