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 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 All of above 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 Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Format > window View > window > split View > split Window > split Format > window View > window > split View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Shift key End key Esc key Ctrl key Shift key End key Esc key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The enter button The edit formula button The cancel button All of these The enter button The edit formula button The cancel button All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS