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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? All of above Font format Number format Border format All of above Font format Number format Border format ANSWER DOWNLOAD EXAMIANS APP
MS Excel To delete an embedded objects, first Select the object by clicking it Press the Shift + Delete keys Double click the object Select it and then press the delete key Select the object by clicking it Press the Shift + Delete keys Double click the object Select it and then press the delete key ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 128 256 1024 16384 128 256 1024 16384 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells ANSWER DOWNLOAD EXAMIANS APP