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 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 in column then choose Paste Special, then click Transpose and 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 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 in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? Lotus 1-2-3 VisiCalc Excel StarCalc Lotus 1-2-3 VisiCalc Excel StarCalc ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here Both You can Find and Replace within the sheet or workbook Excel does not have option to match case for find None of the listed here Both You can Find and Replace within the sheet or workbook Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column letters and row numbers Column numbers and row letters Cell names Cell locator coordinates Column letters and row numbers Column numbers and row letters Cell names Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When many sheets are selected When no sheet is selected One sheet is selected None of the listed here When many sheets are selected When no sheet is selected One sheet is selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS