MS Excel When you copy a formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? Mouse Pointer with anchor at the tip None of above Small thin plus icon Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip None of above Small thin plus icon Doctor’s symbol (Big Plus) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar All of the listed here 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 Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter ANSWER DOWNLOAD EXAMIANS APP