MS Excel When you copy a 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 Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Hyperlinks can be All of above Drawing objects Pictures Text All of above Drawing objects Pictures Text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Cell references but not values Value and cell references Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Goal seek Scenario manager Solver Auto Outline Goal seek Scenario manager Solver Auto Outline ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS