MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Clicking the formula bar Press the Alt key Pressing the F2 key Double clicking the cell Clicking the formula bar Press the Alt key Pressing the F2 key Double clicking the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
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
EXAMIANS