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 Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To add borders To select a distribution of figures To insert a background To add shading or color to a cell range To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Functioning Accessing Referencing Updating Functioning Accessing Referencing Updating ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS