MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Enter text and data Save workbook Copy the worksheet Modifiy the worksheet Enter text and data Save workbook Copy the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formulas Formats Validation All of above Formulas Formats Validation All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? 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 You can Find and Replace within the sheet or workbook None of the listed here 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 From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS