77-888

77-888 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Which of the following is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space?

  1. Trendline
  2. Line chart
  3. Sparkline
  4. Backstage view

Question 12

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

  1. Use the SmartArt option.
  2. Create a new workbook through a template. Copy all data and charts of the report to the new workbook.
  3. Choose one of the pre-built themes.
  4. Select all the text of the document. Change font style to Verdana and font color to light gray. Use vibrant colors for charts.