MS Excel You can use the formula palette to Enter assumptions data Create and edit formula containing functions Format cells containing numbers Copy a range of cells Enter assumptions data Create and edit formula containing functions Format cells containing numbers Copy a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Double click the cell Press the F2 key Press the Alt key Click the formula bar Double click the cell Press the F2 key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Window > split Review > window View > split View > window > split Window > split Review > window View > split View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK ANSWER DOWNLOAD EXAMIANS APP