Hello My Friends,

please give answer, question related to MS Excel 2007.



Question: 1
State whether true or false:
For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
a. True
b. False

Question: 2
How would you select an entire PivotTable report?
a. On the Home tab, in the Editing group, select the 'Entire PivotTable' option
b. On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
c. On the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option
d. None of the above

Question: 3
Which keyboard shortcut should be used to enter the current time?
a. CTRL+SHIFT+"
b. CTRL+SHIFT+:
c. CTRL+;
d. None of the above
Question: 4
State whether true or false:
No data is deleted when an outline is hidden or removed.
a. True
b. False

Question: 5
State whether true or false:
When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
a. True
b. False

Question: 6
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
a. Consolidate by position
b. Consolidate by category
c. Consolidate by formula
d. None of the above


Please Help.

Thanks