CPT 101

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

Change the page orientation to landscape

To ensure a document is free of typos, always do which of the following before publishing the document.

Check the document for spelling and grammar errors by clicking the Spelling & Grammar button.

When a comment is no longer useful, you should do which of the following?

Delete the comment.

To print more than one copy of your worksheet, which tab would you go to?

File

Which of the following formatting enhancements can you apply to paragraphs?

Header

Jacki needs all Heading 1 text to appear green. Which of the following methods is the best way to achieve this?

Manually change each instance of Heading 1 text to green.

Gabrielle accidentally deleted several paragraphs in her document. To restore her work, she should do which of the following?

Recover unsaved changes using the Info screen of the File tab.

To view the entire page of a document, which of the following should you do?

Reduce the zoom level.

Which of the following options is included in the Bibliography gallery?

References

What is a simple way to signify that a concern raised in a comment has been addressed?

Resolve the comment.

Rihanna wants to display document text so that it is easy to read on screen. Which of the following views should she use?

Read Mode

Which of the following can you use to change the amount of space set before the active paragraph?

Spacing Before box on the Layout tab

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

$A$5

If you want to copy or move text between parts of a long document, you can split the document window into two panes.

True

Joe accidentally deleted a paragraph. Which of the following is the fastest way to restore the paragraph?

Undo the action.

Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?

a. Click the Researcher button.

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

argument

The _____ show the document margins.

rulers

Derek needs to change all green text in a document to purple text. Which of the following methods is the most efficient way to locate green text in the document?

search for text based on font color

Amy works for a company called Conicore. Many of the documents she creates include the word Conicore. In order to prevent Word from identifying Conicore as a misspelled word, she can add Conicore to the dictionary.

t

Austin needs to emphasize text by applying a transparent color to the text. Which of the following tools should he use?

the Text Highlight Color button

Ben has added a source for a quotation. To insert a citation using this source, he can click the Insert Citation button and then click which option?

the desired source in the list of sources

A _____ is a set of unified design elements for a document, including colors, fonts, and effects.

theme

Alan is working on a draft document. He wants the document to have more white space. He can do this by changing the line spacing.

true

Dan is writing a novel that contains the nonsense word "Zerphron", which Word identifies as a spelling error. To prevent Word from identifying "Zerphron" as a misspelled word, he can select the Ignore All option.

true

To find a word in a document, use the Smart Lookup feature.

true

To locate a special character such as a tab character, you can use the Find and Replace dialog box.

true

To create a list of sources cited in your document, insert which of the following?

works cited

Ashley needs to find an underlined word in a 100-page document. Which of the following is the most efficient way to find the word?

Search for underline formatting.

Brian needs to view the paragraph marks in a document. Which of the following should he do?

Select the Show/Hide ¶ button.

Jasmine needs to select the first sentence of a paragraph and the last sentence of a paragraph simultaneously. The text is nonadjacent. Which of the following should she do?

Select the first sentence, then press and hold CTRL while selecting the second sentence.

Susan typed a long title using lowercase text, but needs to change the title to uppercase text. Which of the following is the best way to change the title?

Select the text, click the Change Case button in the Font group, then select UPPERCASE.

Susanne accidentally deleted an important paragraph in her document. She can recover the paragraph by selecting the appropriate autosaved version of the document in the Info screen of the File tab.

t

In a formal, professional document, which of the following can you apply to make a word stand out?

italic formatting

To correct an error in a comment, do which of the following?

Edit the comment.

Brianna needs to correct the year of publication in one of her sources. She should do which of the following?

Edit the source to correct the error in the Source Manager.

Anna needs to leave a message for a collaborator about a specific paragraph in a document. Which of the following methods is the best way for her to communicate with her collaborator?

Enter the desired message in a comment attached to the paragraph.

Which of the following is true about inserting cells in a worksheet?

Excel automatically adjusts cell references to reflect new formula locations

A negative indent causes lines of text to be indented more than the first line in the paragraph.

False

To find a word in a document, use the Go To command.

False

Julia noticed that she accidentally used the word "then" instead of "than" in a sentence. Word identified the grammar error with a blue double underline. To correct the error, she can do which of the following?

Accept the suggested grammar change.

Cameron needs to insert a citation, but he does not have the source information. Which of the following should he do?

Add a new citation placeholder.

Which of the following is a way to enhance the look of a document?

Add a page border.

How can you add a drop shadow to a picture?

Apply a Picture Effect.

Sarah wants to apply a set of effects such as shading, borders, and shadows to a picture. Which of the following can she use to do this?

Apply a Picture Style.

A document contains a list of items that appear in no particular order. Which of the following is the best way to format the list?

Apply bullets to the list.

When you cut or copy a cell, it is cut or copied to which of the following?

Both the Windows of Office Clipboard

Jasmine is working on a research paper that needs to be in MLA format. To ensure her bibliography is formatted properly, she should do which of the following?

Check to ensure the bibliography style is MLA in the Citations & Bibliography group of the References tab.

Alyssa needs to center the text of a paragraph on the page. Which of the following can she do?

Click the Center button in the Paragraph group.

Terri needs each word in a paragraph to be capitalized. Which of the following is the simplest method to achieve this?

Click the Change Case button and select Capitalize Each Word.

To remove space after a paragraph, do which of the following?

Click the Line and Paragraph Spacing button and then select Remove Space After Paragraph.

Jared wants to add space between each line of text in a paragraph. Which of the following is the best method to use for this action?

Click the Line and Paragraph Spacing button in the Paragraph group, then select the desired amount of spacing.

What is the simplest and most efficient way to locate the next comment in a document?

Click the Next button in the Comments group of the Review tab.

To zoom a document so that you can see the left and right margins, which of the following should you do on the View tab?

Click the Page Width button in the Zoom group.

If you mistakenly undo an action, how do you correct your mistake?

Click the Redo button on the Quick Access toolbar.

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

Click the Repeat button nine times.

To select a single worksheet cell so you can work with it, which of the following would you do?

Click the cell

Which of the following is the temporary storage area that holds selections you copy or cut?

Clipboard

To indent the first line of every paragraph in a document, do which of the following?

Create a first line indent.

Tiana needs each line after the first line in a paragraph to be indented. She should do which of the following?

Create a hanging indent.

Joan has a redundant source in her bibliography. What is the best way for her to remove this redundant source from the bibliography?

Delete the redundant source in the Source Manager, then update the bibliography.

To have text appear at the bottom of each page in a document, do which of the following?

Double-click the footer region of the page and enter the desired text.

To resize a picture proportionally, which of the following should you do?

Drag a corner sizing handle.

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Gridlines view

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

If it needs an absolute cell reference.

Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source of a quotation. What is the best way for him to achieve this?

Insert a citation.

Jada needs to create a note at the bottom of a page that references text in the body of the document. She should do which of the following?

Insert a footnote.

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

Insert a page break.

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations

Which of the following should Tim use to italicize text?

Italic button on the Mini toolbar

Angel wants all Subtitle text to be green. She can right-click the Subtitle style in the Styles pane and then click _____.

Modify

You can use the _____ to quickly move to a specific page in the document.

Navigation pane

Karen has a document with a list of five priorities in separate paragraphs. The priorities are listed in order from most important to least important. Which of the following options is the best way to format this list?

Numbered list

The Clipboard task pane shows the contents of the _____.

Office Clipboard

Which of the following methods is the best way to find a word in a document?

Open the Navigation pane and then enter the search text.

Which of the following is a text effect you can select from the Text Effects and Typography gallery?

Outline

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Page Layout

Which worksheet view shows headers, footers, and rulers?

Page Layout view

Which of the following is a document view you an select using a button on the status bar?

Page view

Dan needs to view his document as it will appear after being printed. Which view should he use?

Print Layout

Which view most closely resembles how your document will look when printed?

Print Layout

Jessica encounters text in a document that appears blue and underlined. When she presses CTRL and clicks the text, she is taken to a website. She wants the text to appear and behave like normal text. Which of the following should she do?

Right-click the text and select Remove Hyperlink.

Andrew accidentally misspelled a word. To correct the error, he can do which of the following?

Right-click the word and select the desired suggested spelling.

To move to a specific page, section, line, or graphic, you can use the _____.

SNext and Previous arrows in the Paragraph dialog box

Which of the following functions inserts the total of a range?

SUM

Jane has created a new document and entered some text. What should she do to ensure she does not lose her work?

Save the document.

Which of the following is true when you copy and paste formulas using the fill handle?

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

The Undo button on the Quick Access toolbar

Why would you use the Line and Paragraph Spacing arrow on the Home tab?

To align paragraphs

When you point to a theme in the Themes gallery, a thumbnail of the theme is applied to the document.

True

Madison bolded text formatted using the Subtitle style, and now wants all Subtitle text to be bold. She can right-click the Subtitle style in the Styles pane and then click _____.

Update Subtitle to Match Selection

To ensure your bibliography accurately reflects the sources in your source list, do which of the following?

Update the bibliography.

Katlyn needs to remove all tab characters from a document. Which of the following is the most efficient way for her to do so?

Use the Find and Replace dialogue box to locate the tab characters.

Which of the following do you use to change the document margins?

Use the Margins button in the Page Setup group of the Layout tab to select the desired option.

Joanne needs each page in her document to be numbered. She should do which of the following?

Use the Page Number button.

Why is it necessary to use care when inserting worksheet cells?

You will have to manually correct cell references in formulas.

What can you use to enlarge the document in the document window so you can focus on a detail?

Zoom slider

File details such as the document title and author name are called _____.

document properties

Aliya needs her footnotes to be listed as I, II, III... instead of as 1,2,3... She should do which of the following to achieve this?

Change the Number Format in the Footnote and Endnote dialogue box.

To hide the comments in a document, do which of the following?

Click the Show Comments button.

To create two simultaneous views of a document, do which of the following?

Click the Split button.

To quickly change the colors, fonts, and effects in a document, which of the following should be done?

Click the Themes button and select the desired option.

After editing sources using the Source Manager, do which of the following to ensure the bibliography reflects the changes?

Click the Update Citations and Bibliography button in the content control tab for the bibliography.

To calculate the number of words in a document, do which of the following?

Click the Word Count button.

Which of the following do you do to better view small, difficult-to-read text in a document?

Drag the Zoom slider to enlarge the document.

John needs to start a new page in a document. The best way for him to achieve this is by pressing ENTER until a new page is created. 68

False

Juana needs to open a document. To access the Open dialog box, which tab should she use?

File tab

Which of the following is a way to format a paragraph?

Footnote

When a red wavy line appears below a word, which of the following methods do you use to accept a spelling change?

Right-click the misspelled word, then select a correction option.

Shane is reading through a document that has comments from his editor. He needs to respond to one of the comments. He should do which of the following?

Reply to the comment.

To select a paragraph, do which of the following?

Triple click the desired paragraph.

Which of the following do you do to select text?

click and drag across the desired text

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?

d. Edit the document header.

What are user-defined details about a file that describe its content and origin called?

document properties

Andrea needs to remove all the comments from a document. The most efficient way for her to do this is by manually deleting each comment in the document.

f

Inspect a document to locate graphic objects in the document.

f

Jordan consistently misspelled a name in a document. The most efficient way to correct his error is to manually locate each instance of the misspelled word, and then retype the word with the correct spelling.

f

To find the number of words in a document, press the Language button.

f

When you insert a bibliography in a document, Word inserts it as a hyperlink.

f

Normal, Title, and Heading 1 are examples of Themes.

flse

Which of the following window elements displays the left and right document margins?

horizontal ruler

Shauna is preparing a newsletter that will be widely distributed. While checking the document for spelling and grammar errors, she notices that she consistently misspelled the word "disappear". She can correct all instances of the misspelled word by selecting Change All in the Spelling pane.

t

Jenna changed the font color of a heading with the Heading 1 style to green. She wants all headings with the Heading 1 style in the document to be green. Which of the following is the best way to achieve this?

select the green heading 1 header, then update the heading 1 style to match the selection

Karen wants an explanatory note to appear at the bottom of a page. To do so, she should insert an endnote.

t

If you want to move a sentence from one paragraph to another paragraph, you can use the Copy and Paste commands.

true

Jasmine needs an indent at the beginning of each paragraph in her document. The best way for her to achieve this is by entering eight spaces at the beginning of each paragraph.

true

Jorge is reading a document that contains hidden comments. To display the comments, he can click the Show Comments button in the Comments group on the Review tab.

true

Sherri is trying to remember the word "tremendous". She knows "excellent" is similar to the word she's trying to remember. To help her remember, she can enter the word "excellent" in the document and then search for synonyms using the Thesaurus button in the Proofing group of the Review tab.

true