MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 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 is invalid statement? You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Charts Worksheets Worksheets and charts Workbooks Charts Worksheets Worksheets and charts Workbooks ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS