MS Excel Which would you choose to create a bar diagram? Tools, Chart Edit, Chart Format, Chart Insert, Chart Tools, Chart Edit, Chart Format, Chart Insert, Chart 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 Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Paste Special > Transpose Cut and Paste Both of above None of above Paste Special > Transpose Cut and Paste Both of above None of above ANSWER DOWNLOAD EXAMIANS APP