MS Excel When you copy a formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual Basic Visual C++ Java C Visual Basic Visual C++ Java C ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP