MS Excel How do you display current date only in MS Excel? Now () Date () Time () Today () Now () Date () Time () Today () ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see All of these The cancel button The enter button The edit formula button All of these The cancel button The enter button The edit formula button ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above ANSWER DOWNLOAD EXAMIANS APP
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 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 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 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 in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Smart cell Lotus 1-2-3 Word Excel Smart cell Lotus 1-2-3 Word Excel ANSWER DOWNLOAD EXAMIANS APP