MS Excel A circular reference is Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 A1 #a#1 $A$1 !A!1 A1 #a#1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & % * $ & % * $ ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells Extends a sequential series of data ANSWER DOWNLOAD EXAMIANS APP