MS Excel Which of the following option is not available in paste Special dialog box ? Subtract SQRT Divide Add Subtract SQRT Divide Add 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? Both of above None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of above None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format Border format Font format All of above Number format Border format Font format All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5430 5436.80 6.8 5436.8 5430 5436.80 6.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments put in cells are called Smart Tip Web Tip Cell Tip Soft Tip Smart Tip Web Tip Cell Tip Soft Tip ANSWER DOWNLOAD EXAMIANS APP