MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Both of above None of above Cut and Paste Paste Special > Transpose Both of above None of above Cut and Paste Paste Special > Transpose 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 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 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 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual Basic Java C Visual C++ Visual Basic Java C Visual C++ ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS