MS Excel A circular reference is 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 Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find You can Find and Replace within the sheet or workbook Both None of the listed here Excel does not have option to match case for find You can Find and Replace within the sheet or workbook Both None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Math & Trigonometry Statistical Logical Financial Math & Trigonometry Statistical Logical ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear Contents Clear Delete Clear All Delete Clear Contents Clear Delete Clear All Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Open the font dialog box Apply double underline for the active cell None of the listed here Fill down in the selection Open the font dialog box Apply double underline for the active cell None of the listed here Fill down in the selection ANSWER DOWNLOAD EXAMIANS APP