MS Excel Which of the following is an absolute cell reference? A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Pressing the F2 key Press the Alt key Clicking the formula bar Double clicking the cell Pressing the F2 key Press the Alt key Clicking the formula bar Double clicking the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? % * $ & % * $ & ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Automatically adds range of cell values Extends a sequential series of data All of the listed here Applies a boarder around the selected cells Automatically adds range of cell values Extends a sequential series of data All of the listed here Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? All of above Solver Goal seek Scenario Manager All of above Solver Goal seek Scenario Manager ANSWER DOWNLOAD EXAMIANS APP