MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is no suitable abbreviation for the text Data will be entered in the adjacent cells There is not time to format the text No data will be entered in the adjacent cells There is no suitable abbreviation for the text Data will be entered in the adjacent cells There is not time to format the text No data will be entered in the adjacent cells 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too You can search by rows or columns or sheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Goal seek Divide Percentage Square Goal seek Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 row, select the same number of cells in row and paste 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 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 row, select the same number of cells in row and paste 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 123 Xlw Xls Wk1 123 Xlw Xls Wk1 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS