COMPUTER COURSES · MS Excel

MS Office Specialist Excel 2013 Q&A 5-8

CertificateSample

Question 5:

  1. In the Goals Worksheet, edit the cell range Goals_Assoicate_4 so that it only includes the goals value for that associate.
  2. In the Sales Worksheet, Insert a formula in the Cell J10 that display the highest value in the North Region row.

Question 6:

  1. In the Sales Worksheet, Create a custom view named Preview that displays the document in Page Break Preview at 80 percent. (Note: Accept all other default setting.)
  2. In the Sales Worksheet, apply the continuous arrow process layout to the SmartArt graphic change the style to Polished and reverse the direction from Right to Left.

Question 7:

  1. In the Sales Worksheet, Sort the data in ascending order by Unit Price and then descending order by On Order.
  2. In the Budget Worksheet, apply a correct to the image so that it is softened 25% and apply Glow Diffused Artistic effect.

Question 8:

  1. In the Sales Analysis worksheet, Remove the background of the image and apply a Pencil Grayscales Artistic Effect.
  2. In the Order Worksheet, Autofill only the format in Cell C4 through the end of the data series.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s