MS Excel When the formula bar is active, you can see The edit formula button The cancel button The enter button All of these The edit formula button The cancel button The enter button All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates you that you can make selection? Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip None of above Small thin plus icon Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip None of above Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Copy handle Border Insert handle Fill handle Copy handle Border Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu 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
EXAMIANS