Microsoft Office Semester Review

Front

How to insert a column sparkline in Excel?

Back

Click on the cell to insert a Sparkline, go to Insert tab, select Sparkline type from Sparklines group, and click OK.

Front

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

Back

A title

Front

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

Back

Apply a Table Style.

Front

What is the best method for Kyle to have the same text appear at the top of each page in a document?

Back

Edit the document header.

Front

If you want to change the color of the border around a shape, which of the following do you change? Options: Outline, Fill, Texture, Color

Back

Outline

Front

To start entering text on a new page, do which of the following? Options: Insert a page break, Insert a line break, Insert a continuous section break, Insert a column break.

Back

Insert a page break.

Front

Print setting that prints each slide at the top of the paper with blank lines below the slide.

Back

Notes Pages

Front

Which function calculates the arithmetic mean of a price list?

Back

AVERAGE

Front

What stops the spell checker from flagging your company's name as a misspelling in later occurrences in the document?

Back

Ignore All

Front

Which preset text effect do you apply when you want the text to have a border color? Options: Outline, Shadow, Reflection, Glow

Back

Outline