Hello My Friends,

please give answer, question related to MS Excel 2007.

Question: 1
Which database function estimates variance based on a sample from selected database entries?
a. DSTDEV
b. DSUM
c. DVAR
d. DVARP

Question: 2
Which of the following charts show numerical values on the vertical (value) axis and textual groupings (or categories) on the horizontal axis?
a. XY (Scatter) charts
b. Bubble charts
c. Area charts
d. All of the above

Question: 3
Which of the following methods would you follow to remove subtotals?
a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
b. On the Data tab, in the Data Tools, select Remove Subtotals
c. Both a and b
d. None of the above

Question: 4
State whether true or false:
Deleting the PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False

Question: 5
State whether true or false:
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
a. True
b. False

Question: 6
Which chart displays axes but cannot display axis titles?
a. Radar chart
b. Doughnut chart
c. Pie chart
d. All of the above

Please Help.

Thanks