Q: Which method will you use to update
table data from a Sharepoint list? Answer
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. None of the above
Q: Which of the following is a default
method of a PivotTable report for scoping the conditional format of fields in
the values area? Answer
a. By selection
b. By corresponding field
c. By value field
d. By number field
