MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Fill series Auto fill options Fill across worksheet Custom List Fill series Auto fill options Fill across worksheet Custom List ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + C Ctrl + Page Up Ctrl + Space Bar Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references 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 Ctrl+ D shortcut key in Excel will None of the listed here Fill down in the selection Apply double underline for the active cell Open the font dialog box None of the listed here Fill down in the selection Apply double underline for the active cell Open the font dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The Formula button The quicktotal button The total button The autosum button The Formula button The quicktotal button The total button The autosum button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS