MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F11 F8 F9 F10 F11 F8 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? _ (underscore) " (quote) ' (apostrophe) = (equal) _ (underscore) " (quote) ' (apostrophe) = (equal) 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 The Paste Special command lets you copy and paste: Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Standard Tool Bar Formula Bar Menu Bar Title Bar Standard Tool Bar Formula Bar Menu Bar Title Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP