MS Excel Edit > Delete command Deletes the comment of cell Deletes selected cells Deletes Formats of cell Deletes the content of a cell Deletes the comment of cell Deletes selected cells Deletes Formats of cell Deletes the content of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 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 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 A circular reference is A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above Click on Sheet 3 and from Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP