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 Unfreeze panes command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: 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 Values but not cell references Cell references but not values Value and cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + Enter Ctrl + C Ctrl + Space Bar Ctrl + Page Up Ctrl + Enter Ctrl + C Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Orientation Margins Headers and Footers Page Break Preview Page Orientation Margins Headers and Footers Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP