Microsoft Office Applications Pre-Test

Front

A student 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.

Back

true

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, which of the following should be done?
Options:
Apply a Table Style.
Apply Theme Effects.
Apply Text Effects.
Insert a Watermark.

Back

Apply a Table Style.

Front

Zannia 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? Options: 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.

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? Outline, Fill, Texture, Color

Back

Outline

Front

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.

Back

Insert a page break.

Front

Which Print setting prints each slide at the top of the paper with blank lines below the slide? Options: Full Page Slides, Notes Pages, Outline, Handouts

Back

Notes Pages

Front

Which function is used to calculate the arithmetic mean of a price list? Options: MAX, COUNT, SUM, AVERAGE

Back

AVERAGE

Front

The spell checker flags your company's name as a misspelling. Which option will stop the spell checker from flagging later occurrences in the document? Change All, Change, Ignore Once, Ignore All

Back

Ignore All

Front

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

Back

Outline