1. What is the option on the Document Inspector that finds the content type information?
Answers:
• Document
Properties and Personal Information
2. How can a chart be modified?
Answers:
• By modifying the display of chart axes
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.
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
Answers:
• True
4. How would you select an entire PivotTable report?
Answers:
• On the Options
tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
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?
Answers:
• Scoping by value
field
6. When does the triangle appear in the top-left corner of the cell, as shown in the picture?
Answers:
• When there is an
error in the formula
7. How will you display the Go To dialog box?
Answers:
• You will press F5
8. Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
Answers:
• B
9. Which tab should be used to display or hide axes?
Answers:
• Layout tab
10. When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
Answers:
• It enters the time
as AM