Dig Apps

Decreasing a cell's indent movies its contents to the right one space.

False

When you double-click the right border of a column heading, which of the following occurs?

AutoFit resizes the column to the widest cell entry.

Sydney wants to resize a picture to exact dimensions. She should do which of the following?

Enter the height in the Shape Height text box and enter the width in the Shape Width text box.

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.

False

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

False

Makayla needs to select the entire line of cells in a table going from left to right. She needs to select a column.

False

Press CTRL+W to save the document.

False

Resize a picture proportionally by dragging a top sizing handle.

False

The Comma Style format adds a comma and a dollar sign to a cell value.

False

To copy text, select the text, press and hold the mouse button, then drag the text to a new location.

False

To ensure that a picture is visible, bring the picture to the back.

False

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

False

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

False

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

False

To insert a text box, click the SmartArt button.

False

To rotate a picture 90 degrees, flip the picture horizontally.

False

Tom took a photo using his webcam and saved it to his desktop. To insert the file in a Word document, he can use the Online Pictures button.

False

Use ALT to select multiple nonadjacent headings in a document.

False

When you close a document, your work is automatically saved.

False

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

False

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

False

You click the Exit button on the title bar to exit Word.

False

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

File tab

To change the color of cell content, you use the _____ color list arrow.

Font

To copy a cell's formatting to another cell, which of the following can you use?

Format Painter

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

True

To move a worksheet, you can drag its sheet to the left or right.

True

To specify how a shape interacts with the text around it, modify the text wrapping of the shape.

True

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

True

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

True

You can use the Mini toolbar to apply bullets to paragraphs.

True

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?

Update the Normal style to use green text.

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

Use Find/Replace to find the misspelled word and replace it.

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

Use the Page Number button.

Which of the following is true of the Excel spell checker?

You can change all instances of a flagged word to a selected suggestion.

A worksheets named Income (2) is most likely which if the following?

a copy of another worksheet named Income

When you underline cell content, you are using _____.

a font style

To format a range so that all values greater than $500 appear in red, which of the following can you use?

conditional formatting

A citation is a parenthetical reference in the document text that gives credit to the source for a quotation or other information used in a document.

True

After using the Undo button to delete a word, you can click the Redo button to reverse the action and restore the word in the document.

True

Currency is an example of a number format.

True

Jasmine wants to emphasize some underlined text. She can change the color of the underline.

True

Jeremiah needs to organize information in his document using rows and columns. He should insert a table.

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

To copy formatting from one selection of text to another, use the Format Painter.

True

The _____ number format adds dollar signs and two decimal places to numeric data.

Accounting

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.

One of the pictures in Destiny's document is covered up by another picture. To make the obscured picture visible, she should do which of the following?

Bring the obscured picture to the front.

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.

To select nonadjacent cells or range on a worksheet, you can press and hold _____ while selecting each one.

CTRL

To accept a suggested spelling for that instance only, which of the following would you click?

Change

Silvio inserted an inline picture and wants to move it to the upper-right corner of the page. What must he do before moving it?

Change it to a floating picture.

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.

Imani needs to rearrange a picture in her document. The picture has Square text wrapping. She should do which of the following?

Click and drag the picture to the desired location.

Joshua needs stylized text in his document to be normal, unformatted text. He should do which of the following?

Click the Clear All Formatting button.

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.

Hannah wants to position a picture in the middle and center of a page and let the text wrap around the picture. She should do which of the following?

Click the Position button and select Position in Middle Center with Square Text Wrapping.

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.

Alexis is having trouble clicking the right part of a table to select a row. After selecting a cell, what should she do instead?

Click the Select button and then click Select Row.

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

Drag a corner sizing handle.

Which of the following lets you resize a selected picture on your worksheet.

Drag any corner handle

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

Edit the comment.

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

Insert a page break.

Isaiah needs to insert a copyright symbol (©). He should do which of the following?

Insert a symbol from the Symbol gallery.

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options?

Keep Source Formatting

Alexis needs the text after a tab character to be moved further to the right. She should do which of the following?

Move the appropriate tab stop to the right.

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

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

Page Manager

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

Print Layout

If you want to change all occurrence of "Radio" to "TV" in a worksheet, you can use the _____ command.

Replace

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.

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.

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?

Select the table.

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.

Before you can align pictures with each other, what do you need to do?

Select two or more pictures.

Pressing DELETE removes the character after the insertion point.

True

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.

True

Text in the header appears at the top of each page in a document.

True

Which of the following do you do to select text?

click and drag across the desired text

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?

d. Insert a citation.

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have _____ applied to them.

data bars

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

document properties

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

horizontal ruler

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

themes