MS Excel A circular reference is Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Goal seek Scenario manager Solver Auto Outline Goal seek Scenario manager Solver Auto Outline ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Review > window View > window > split View > split Window > split Review > window View > window > split View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different worksheets Split a worksheet into two panes View different rows and columns edit the contents of a cell Edit the contents of a cell View different worksheets Split a worksheet into two panes View different rows and columns edit the contents of a cell Edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP