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 Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments can be added to cells using View > Comments Insert > Comments File > Comments Edit > Comments View > Comments Insert > Comments File > Comments Edit > Comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Add Divide Subtract SQRT Add Divide Subtract SQRT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS