MS Excel When a row of data is to be converted into columns 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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? The width of a row and be specified manually or fit automatically Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the bottom left corner Towards the top right corner Towards the top left corner Towards the bottom right corner Towards the bottom left corner Towards the top right corner Towards the top left corner Towards the bottom right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which would you choose to create a bar diagram? Tools, Chart Insert, Chart Format, Chart Edit, Chart Tools, Chart Insert, Chart Format, Chart Edit, Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP