MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
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 It is acceptable to let long text flow into adjacent cells on a worksheet when There is not time to format the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is no suitable abbreviation for the text There is not time to format the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is no suitable abbreviation for the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Math & Trigonometry Statistical Financial Logical Math & Trigonometry Statistical Financial ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS