MS Excel Comments put in cells are called Web Tip Cell Tip Soft Tip Smart Tip Web Tip Cell Tip Soft Tip Smart Tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Border Fill handle Insert handle Copy handle Border Fill handle Insert handle Copy handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Double click the cell Press the Alt key Click the formula bar Press the F2 key Double click the cell Press the Alt key 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 Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS