MS Excel Which setting you must modify to print a worksheet using letterhead? Layout Margin Orientation Paper Layout Margin Orientation Paper ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu 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
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above ANSWER DOWNLOAD EXAMIANS APP