MS Excel 2007 Skills Online Test-1

Question-1.

What is the option on the Document Inspector that finds the content type information?

Comments and Annotations

Headers and Footers

Document Properties and Personal Information

Hidden Rows and Columns

Question-2.

How can a chart be modified?

By modifying a legend

By modifying the display of chart axes

By modifying titles and data labels

All of the above

Question-3.

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.

True

False

Question-4.

How would you select an entire PivotTable report?

On the Home tab, in the Editing group, select the ‘Entire PivotTable’ option

On the Options tab, in the Actions group, click on Select, and then click ‘Entire PivotTable'”

On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option

None 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?

Scoping by selection

Scoping by corresponding field

Scoping by value field

All of the above

EXAMRADAR.COM