MS Excel You can use the drag and drop method to Copy cell contents Move cell contents Add cell contents Copy cell contents & Move cell contents Copy cell contents Move cell contents Add cell contents Copy cell contents & Move cell contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? 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 None of the listed here Excel does not have option to match case for find Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP