MS Excel A circular reference is A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK None of the listed here From Edit menu choose Move of Copy then choose (Move to end) and click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK None of the listed here From Edit menu choose Move of Copy then choose (Move to end) and click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? All of above Validation Formats Formulas All of above Validation Formats Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Statistical Logical Financial Math & Trigonometry Statistical Logical Financial Math & Trigonometry ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Add Subtract SQRT Divide Add Subtract SQRT Divide ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS