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 All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 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 None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Smart Formula Standard Formulas Complex Formulas Array formula Smart Formula Standard Formulas Complex Formulas Array formula 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 An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Objects Contents Scenarios All of the listed here Objects Contents Scenarios All of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS