MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ * % & $ * % & ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Time() Date () Today () Now () Time() Date () Today () Now () ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain many sheets including worksheets and chart sheets It can contain text and data You have to work hard to create it It can be modified It can contain many sheets including worksheets and chart sheets It can contain text and data You have to work hard to create it It can be modified ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS