MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Add Subtract Divide SQRT Add Subtract Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the menu bar Appears to the left of the formula bar Shows the location of the previously active cell Appears below the status bar Appears below the menu bar Appears to the left of the formula bar Shows the location of the previously active cell Appears below the status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie Line Area All of the listed here Pie Line Area All of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS