Please answer my question related to MS Excel 2007. Part 5.

[MonkiaSaini]

Hello My Friends,

please give answer, question related to MS Excel 2007.

Question: 1
Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
a. By selection
b. By corresponding field
c. By value field
d. By number field



Question: 2
State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.
a. True
b. False

Question: 3
Which of the given methods would you follow to add an alternative text to a picture?
a. Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
b. Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
c. Both a and b
d. None of the above

Question: 4
Which method will you use to update table data from a Sharepoint list?
a. On the Data tab, in the Data Tools group, click Refresh
b. On the View tab, in the Show/Hide group, click Refresh
c. On the Design tab, in the External Data group, click Refresh
d. All of the above

Question: 5
Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?
a. Scoping by selection
b. Scoping by corresponding field
c. Scoping by value field
d. All of the above

Question: 6
Which file format is typically used to remove printer corruption?
a. XLS format
b. HTML format
c. SYLK format
d. All of the above

Please Help.

Thanks