MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar 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 column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste 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 column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste 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 Which language is used to create macros in Excel? Java Visual C++ Visual Basic C Java Visual C++ Visual Basic C ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Fill the selection with active cells to the right Right align the content of cell None of above Remove the cell contents of selected cells Fill the selection with active cells to the right Right align the content of cell None of above Remove the cell contents of selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Return a formula result Manipulate values Manipulate labels Use the addition operator Return a formula result Manipulate values Manipulate labels Use the addition operator ANSWER DOWNLOAD EXAMIANS APP