MS Excel You can use the formula palette to Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 256 128 16384 1024 256 128 16384 1024 ANSWER DOWNLOAD EXAMIANS APP
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 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 row, select the same number of cells in row and paste 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 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 row, select the same number of cells in row and paste 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 chart can be created in Excel ? Pie Area All of the listed here Line Pie Area All of the listed here Line ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Today () Time () Now () Date () Today () Time () Now () Date () ANSWER DOWNLOAD EXAMIANS APP