MS Excel Concatenation of text can be done using Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Objects Scenarios All of the listed here Contents Objects Scenarios All of the listed here Contents 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Contents Scenarios Objects All of the listed here Contents Scenarios Objects All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the latest version of Excel Excel 365 Excel 2007 Excel XP Excel 2016 Excel 365 Excel 2007 Excel XP Excel 2016 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS