#1
|
|||
|
|||
Please answer my question related to MS Excel 2007. Part 2.
Hello My Friends,
please give answer, question related to MS Excel 2007. Question: 1 Some data is to be refreshed in an imported XML file. Where can the command on the Ribbon be found? a. On the Data tab b. On the View tab c. On the Developer tab d. None of the above Question: 2 Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found? a. HLOOKUP b. VLOOKUP c. TRANSPOSE d. None of the above Question: 3 Which of the following is not a valid file extension in which an Excel file can be saved? a. XLSB b. XLSM c. PXL d. All of the above are valid Question: 4 Which of the following options is not available on the Status bar? a. Cell mode b. Selection mode c. End mode d. Start mode Question: 5 Which of the following is not true regarding column width? a. If the column width is set to 0, the column is hidden b. A column width between 0 to 255 can be specified c. The default column width is 8.43 characters d. All of the above are true Question: 6 How will you find cells with data validation? a. On the Home tab, in the Editing group, click on Go To, then click Special. Click on Data Validation, and then click All b. On the View tab, in the Windows group, click Data Validation c. Both a and b d. None of the above Please Help. Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please answer my question related to MS Excel 2007. Part 1. | MonkiaSaini | Excel | 7 | 11-24-2011 07:33 AM |
Please answer my questions related to MS Word 2007 | MonkiaSaini | Word | 5 | 05-09-2010 04:02 AM |