MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Cell locator coordinates Column numbers and row letters Column latters and row numbers Cell names Cell locator coordinates Column numbers and row letters Column latters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Reference tabs Position tabs Location tabs Sheet tabs Reference tabs Position tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Values or cell references although not both at the same time Value and cell references Cell references but not values Values but not cell references Values or cell references although not both at the same time Value and cell references Cell references but not values ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. Insert File Tools View Insert File Tools View ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Add SQRT Divide Subtract Add SQRT Divide ANSWER DOWNLOAD EXAMIANS APP