MS Excel Which is used to perform what if analysis? Goal seek All of above Solver Scenario Manager Goal seek All of above Solver Scenario Manager 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 Concatenation of text can be done using Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Save workbook Copy the worksheet Enter text and data Modifiy the worksheet Save workbook Copy the worksheet Enter text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel To select an entire column in MS - EXCEL, press ? CTRL + Arrow key CTRL + C CTRL + S None of the listed here CTRL + Arrow key CTRL + C CTRL + S None of the listed here ANSWER DOWNLOAD EXAMIANS APP