MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK None of the listed here 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 From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK None of the listed here 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the drag and drop method to Copy cell contents Move cell contents Copy cell contents & Move cell contents Add cell contents Copy cell contents Move cell contents Copy cell contents & Move cell contents Add cell contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Scenario Manager Goal seek Solver All of above Scenario Manager Goal seek Solver All of above 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can copy data or formulas With the copy, paste and cut commands on the edit menu With commands on the shortcut menu With buttons on the standard toolbars All of these With the copy, paste and cut commands on the edit menu With commands on the shortcut menu With buttons on the standard toolbars All of these ANSWER DOWNLOAD EXAMIANS APP