MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Contents Objects All of the listed here Scenarios Contents Objects All of the listed here Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by You can use the format painter button on ly one time when you click it Double clicking the format painter button Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button You can use the format painter button on ly one time when you click it Double clicking the format painter button Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Formatting toolbar 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 Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here ANSWER DOWNLOAD EXAMIANS APP