MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Ctrl key End key Esc key Shift key Ctrl key End key Esc key Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu 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
MS Excel Which of the following is not information you can specify using the solver? Changing cells Target cell Constraints Input cells Changing cells Target cell Constraints Input cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP