MS Excel All worksheet formula Manipulate values Use the addition operator Manipulate labels Return a formula result Manipulate values Use the addition operator Manipulate labels Return a formula result 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 Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Value and cell references Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references Values or cell references although not both at the same time Values but not cell references Cell references but not values ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Enter button Press the Erase key Press the Edit Formula button Press Esc Press the Enter button Press the Erase key Press the Edit Formula button Press Esc ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can add more than one condition to check 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 set condition to look for Bold and apply Italics on them You can add more than one condition to check 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home ANSWER DOWNLOAD EXAMIANS APP