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