MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two View > split Format > window Window > split View > window > split View > split Format > window Window > split View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double click on the cell pointer in worksheet Double clicking on the column left border of column header Double clicking on the column name on column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column left border of column header Double clicking on the column name on column header Double clicking on column right border on column header ANSWER DOWNLOAD EXAMIANS APP
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? Custom List Fill across worksheet Auto fill options Fill series Custom List Fill across worksheet Auto fill options Fill series ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear >All All of the listed here Edit > Clear > Contents Edit > Delete Edit > Clear >All All of the listed here Edit > Clear > Contents Edit > Delete ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS