MS Excel Which of the following is not a valid data type in Excel ? Number Date/Time Label Character Number Date/Time Label Character ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically Sheet tabs can be colored You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically Sheet tabs can be colored ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste buttons on the standard toolbar With the right drag method With a hyperlink With the copy and paste special commands With the copy and paste buttons on the standard toolbar With the right drag method With a hyperlink With the copy and paste special commands ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS