Microsoft Office Semester Review

A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.

• true

• false

What should you add to describe the data in a chart?

• A legend

• A title

• A chart style

• An animation

To quickly change the shading, borders, and font colors of a table, which of the following should be done?

• Apply a Table Style.

• Apply Theme Effects.

• Apply Text Effects.

• Insert a Watermark.

Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?

• Edit the document header.

• Manually enter the desired text at the top of each page.

• Modify the Document Properties.

• Add a comment at the top of each page.

If you want to change the color of the border around a shape, which of the following do you change?

• Outline

• Fill

• Texture

• Color

To start entering text on a new page, do which of the following?

• Insert a page break.

• Insert a line break.

• Insert a continuous section break.

• Insert a column break.

Which of the following Print settings prints each slide at the top of the paper with blank lines below the slide?

• Full Page Slides

• Notes Pages

• Outline

• Handouts

Which of the following functions would you use to calculate the arithmetic mean of a price list?

• MAX

• COUNT

• SUM

• AVERAGE

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

• Change All

• Change

• Ignore Once

• Ignore All

Which preset text effect do you apply when you want the text to have a border color?

• Outline

• Shadow

• Reflection

• Glow