MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Client None of these Source Server Client None of these Source ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Margins Headers and Footers Page Orientation Page Break Preview Margins Headers and Footers Page Orientation Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Column latters and row numbers Column numbers and row letters Cell names Cell locator coordinates Column latters and row numbers Column numbers and row letters Cell names ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP