Home / Computer Fundamentals / MS Excel :: Discussion

### Discussion :: MS Excel

1. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 2.  A. An absolute cell address is created B. Cell address will change when it is copied to another cell C. The sheet tab is changed D. The status bar does not display the cell address Answer : Option A Explanation : The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Be The First To Comment