MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Subtract Add Divide SQRT Subtract Add Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto format Auto correct AutoFill Auto sum Auto format Auto correct AutoFill Auto sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) 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
MS Excel When a range is selected, how can you activate the previous cell ? Press the Alt key Press Tab Press Enter None Press the Alt key Press Tab Press Enter None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Wrap Text in Format > Cells All of above Text Wrapping in Format > Cells Justify in Edit > Cells Wrap Text in Format > Cells All of above Text Wrapping in Format > Cells Justify in Edit > Cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS