MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? 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 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 column heading you want to delete and select Insert Delete from the 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 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 column heading you want to delete and select Insert Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press the Alt key None Press Enter Press Tab Press the Alt key None Press Enter Press Tab ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Column chart Row chart Line chart Pie chart Column chart Row chart Line chart Pie chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS