MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Menu Bar Standard Tool Bar Formula Bar Title Bar Menu Bar Standard Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Font format All of above Number format Border format Font format All of above Number format Border format 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? Auto fill options Fill series Custom List Fill across worksheet Auto fill options Fill series Custom List Fill across worksheet ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS