MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu 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 Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key Pressing the Esc key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Click the formula bar Double click the cell Press the F2 key Press the Alt key Click the formula bar Double click the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F9 F8 F11 F10 F9 F8 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place None of these Clicking the formula button Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place None of these Clicking the formula button ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments Formatting options The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Cell comments Formatting options The resulting values of a formula instead of the actual formula Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP