MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? FACT ( ) MOD ( ) ROUND ( ) Div ( ) FACT ( ) MOD ( ) ROUND ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Values and formulas but not labels Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels Formulas only Labels, values, and formulas Labels and values but not formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Objects Contents Scenarios All of the listed here Objects Contents Scenarios ANSWER DOWNLOAD EXAMIANS APP
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 When a row of data is to be converted into columns 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 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
EXAMIANS