MS Excel Which of the following formulas is not entered correctly? 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto correct AutoFill Auto sum Auto format Auto correct AutoFill Auto sum Auto format ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Cell comments Formatting options The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them 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 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 All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells All of above Wrap Text in Format > Cells Text Wrapping in Format > Cells Justify in Edit > Cells All of above Wrap Text in Format > Cells Text Wrapping in Format > Cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS