MS Excel A circular reference is A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Formula None Both Cell value Formula None Both Cell value ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. View Tools File Insert View Tools File Insert ANSWER DOWNLOAD EXAMIANS APP
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 The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created 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
EXAMIANS