MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Changing cells Input cells Target cell Constraints Changing cells Input cells Target cell Constraints ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Tool Bar Formula Bar Status Bar None Tool Bar Formula Bar Status Bar None ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Square Percentage Divide Goal seek Square Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A cell reference A collection of related data A division of results A type of chart A cell reference A collection of related data A division of results A type of chart ANSWER DOWNLOAD EXAMIANS APP