MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Goal seek Divide Percentage Square Goal seek Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Cell locator coordinates Column latters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column latters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both None Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both None ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is 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 A cell that points to a drawing object Always erroneous Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS