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? Auto fill options Fill across worksheet Custom List Fill series Auto fill options Fill across worksheet Custom List Fill series ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different worksheets Edit the contents of a cell Split a worksheet into two panes View different rows and columns edit the contents of a cell View different worksheets Edit the contents of a cell Split a worksheet into two panes View different rows and columns edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing spacebar Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar 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 To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Fill the selection with active cells to the right None of above Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right None of above Right align the content of cell Remove the cell contents of selected cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS