word 2010 garbage

What steps can you use to align objects in a document?

1. Click the drawing tools format tab. 2. In the arrange group, choose the position and alignment you want.

What steps can be used to trace errors in a worksheet?

1. Select the cell with the error. 2. On the Formulas tab, in the formula auditing group, click the down arrow on the Error Checking button, and choose Trace Error.

When you are reviewing the tracked changes someone made to a document, what choices do you have for how to incorporate or remove the changes? Check all that apply.

Accept Reject

If you want to make an image look more like a sketch, what option should you use in the Adjust group?

Artistic Effects

Most labels are designed to compare to what brand of label?

Avery

Which command will delete both the content and structure of selected portions of a table?

Backspace

What steps should you use to add a border?

Choose the border style, and then choose where the border should appear.

After you find a clip art image you want to use in the Clip Art pane, how can you add it to your document?

Click and drag the image from the Clip Art pane where you want it in the document.

If you are in Print Layout view and want to change the margin, what should you do?

Click and drag the margin to where you want it.

How do you access the options for sending a file using e-mail, saving it to the web, or saving it to SharePoint?

Click the File tab, and then click Save & Send.

How do you add a section break that would start the new section on the same page?

Click the Page Layout tab, click Breaks, then choose Continuous.

If you want to view two documents at once, which steps should you follow after you open the two documents you want to view?

Click the View tab, then click the View Side by Side icon.

When you receive changes from multiple reviewers on a document, how can you tell their changes apart?

Each reviewer's changes will have a different color.

If you want to open the Navigation pane to do a Find, what should you first click on the Home tab?

Editing

What are the advantages of repeating a header row? Check all that apply.

Edits made to the header row content will automatically be applied to all pages. You can add and delete rows from the table without moving the header rows.

If you created a style in one document and want to use it in another, what is the best way to do that?

Export the style from the original document.

What can you do to help envelopes print properly? Check all that apply.

Feed the envelopes in one at a time. Do a trial printing on a blank sheet of paper. Load them in the direction marked on the printer.

What are some things you can do when formatting page numbers? Check all that apply.

Give each section a separate set of page numbers. Give each section a separate set of page numbers.

What can you do to see a live preview of how a style will look in your document?

Hover the mouse pointer over the style in the gallery.

What should you do in order to view table tools such as the Design and Layout tabs?

Put the insertion point in the table so you are actively in the table.

What setting needs to be activated to be able to scroll at the same time in two documents being viewed side by side?

Synchronous Scrolling

After modifying the font of the Subheading1 style, you notice that the font of Subheading2 has also changed. What is the most likely reason for this?

The Subheading2 style is based on the Subheading1 style.

What are some options for how to handle the results of filtering? Check all that apply.

"Filter the list, in place" "Copy to another location"

In which of these situations would it be best to choose straight quotes?

When you plan to copy and paste the text to a plain text editor program.

When would you be most likely to use an unlinked header?

When you want one page to be different from the others.

What option can you use to control how text flows around a graphic?

Wrap Text

When you collapse text in Outline view, what happens?

You can see more of the document at a time.

What are some advantages of organizing a document as an outline? Check all that apply.

You can simplify a document into objects that can be easily rearranged. You can easily promote objects and create subheadings.

Which situation would clip art be most helpful in?

You don't already have a graphic you want to use.

For the Search feature to work for finding templates, what needs to be true?

Your computer must be connected to the Internet.

Which type of tab stop is most helpful for weights and measurements?

decimal

SmartArt is especially useful for what types of objects? Check all that apply.

diagrams flow charts lists processes

What are some examples of tab leaders you can choose from? Check all that apply.

dots, dashes, underscores

What are some options when printing labels? Check all that apply.

single label full page of same label

What are some examples of common options you have after choosing a table style? Check all that apply.

special first row special first column special last row special last column

What symbols are used to surround a structured reference in a formula?

square brackets

What are some options that can be added to the Excel Ribbon? Check all that apply.

tabs groups symbols for groups

A screenshot allows you to

take a screen-capture image of a software program on your computer.

If you modify the Normal style, what text will be affected? Check all that apply.

text with styles that are based on the Normal style text that doesn't have any special style applied to it

Which tab should you use when you want to create a shape?

the Insert tab

What tab do you need to have open to add a section break?

the Page Layout tab

What are some options available on the Line and Page Breaks tab?

widow/orphan control, hyphenation rules suppressing line numbers

What are some options available for highlighting changes in the Highlight Changes dialog box? Check all that apply.

within a specific time period by a specific user

Envelopes are useful for adding to what type of document?

form letters

What are some examples of summary functions? Check all that apply.

AVERAGE, SUM

What are some options available in the Spelling and Grammar Checker?

Change and Change All Ignore Once and Ignore All Add to Dictionary AutoCorrect Undo

Before you can get to the Mailings tab and add labels, what must you do?

Have a document open.

What steps should you use to get the dialog box for modifying a style?

In the Styles pane, hover the mouse pointer over the style, and then click Modify.

How can you move text or images into tables?

Select the content, and then click and drag it into the table.

What happens when you modify a built-in table style?

A copy of the style is created, forming a new custom style.

What are some ways to use a range name in a formula? Check all that apply.

In the Defined Names group, click Use in Formula, and then select the desired name. Begin typing the name in the formula, select a name from the AutoComplete list, and use the arrow keys and Tab key to enter the name in the formula.

If you promote text in an outline to a heading but don't like how it looks, what is the best way to fix the problem?

In the Styles pane, modify the heading style.

What steps display multiple subtotal functions?

In the Subtotal dialog box, uncheck the "Replace current subtotals" box.

How are smart quotes different from straight quotes?

Smart quotes tilt in toward the words between them.

What is the best reason why you should avoid using red with green for your text and shading options?

The contrast would be difficult for color-blind people to see.

Which potential problem should you be aware of when using the Exactly line spacing setting?

The edges could get cut off of a large font.

What does a first line indent look like?

The first line of a paragraph is more indented to the right than the lines below it.

What does a hanging indent look like?

The first line of a paragraph starts farther to the left than the lines below it.

What will happen when you change data that is used in a formula?

The formula automatically recalculates when you open the document.

When choosing a graphic, what characteristics should you look for?

The graphic is good quality. The graphic is roughly the size you need it to be.

If you forget the password for accessing a Word document, what will happen?

The password will not be recoverable.

What happens when AutoFill is used to copy a formula that uses range names?

The range name does not update.

What is a limitation of using Paste Special to add values?

The result will not update if the other cells are updated.

Which tabs contain options for adding shapes to a chart? Check all that apply.

Insert Chart Tools Format

In a table with many rows and columns, how can you add a column that contains a single cell?

Insert a column, select its cells, and click Merge Cells.

How is combining documents helpful with multiple reviewers?

It allows you to view color-coded changes from multiple reviewers in one document.

What is a common problem with shading?

It can make cells appear dark and difficult to read when printed and copied.

If you create a column break, what happens to the text after the insertion point?

It moves to the top of the next column.

If you add an envelope to a document, what will happen every time you print the document?

It will stop and ask you to feed an envelope in.

After choosing a shape to create, what instructions should you follow to create the shape?

Left mouse click, hold down, and drag.

After saving an Excel file as a web page, what will its file extension be?

.htm

What file extension is used for Excel templates?

.xltx

What are the steps for using the Use in Formula command?

1. Begin typing the formula until it is ready for the range name. 2. On the Formulas tab, in the defined names group, click the drop-down arrow next to Use in Formula, and then click the range name. 3. Finish typing the formula, and then press the Enter or Tab key.

What steps should you use when you want to save a template that you made changes to so that you can use it over and over in the future?

1. Click the File menu, and then click save as . 2. Next to Save As Type, click word template.

What steps can be used to modify a template?

1. Click the File tab, and then click open. 2. Specify the name and location of the file to modify. 3. Click Open. 4. Change the file. 5. Click Save.

What steps can change the tabs, groups, and commands on the Ribbon?

1. Click the File tab, and then click options . 2. Click customize ribbons. 3. Change the settings as desired. 4. Click OK.

What are the steps for consolidating data?

1. Click the data tab. In the Data Tools group, click Consolidate. 2. In the Consolidate dialog box, select the function type on the Function drop-down list. 3. Click the collapse button next to the reference field. Select the cells and click the collapse button. 4. Click Add. 5. Repeat Steps 3 through 4 until all data are added. 6. Decide whether to add check marks for labels in the top row or left column, and whether to create links to source data. 7. Click OK.

What steps should you use when you want to create a document from a user-defined template?

1. Click the file menu. 2. Click New. 3. Click new from existing.

What steps should you use to view document statistics?

1. Click the file menu. 2. Click info . 3. View the advances properties .

What steps should you use to view metadata?

1. Click the file menu. 2. Click info.

What steps can be used to check for and remove personal information with the Document Inspector?

1. Click the file tab, and then click Info. 2. Click check for issues , and then click Inspect Document. 3. Check the items to check. 4. Click Inspect. 5. In the results list, click Remove All for items to remove. 6. Click Close.

What are the steps for marking a workbook as final?

1. Click the file tab, and then click Info. 2. Click protect workbook , and then click Mark as Final.

What steps can be used to send a file as an e-mail attachment?

1. Click the file tab, and then click Save & Send. 2. Click send as attachment. 3. Specify the e-mail address, and send the message.

What steps can be used to create a file from an existing template?

1. Click the file tab, and then click new. 2. In the Templates list, under Office.com templates, click a type of template. 3. Find the desired template. 4. double click the template to download and open it.

What are the steps for hiding zero values so they don't display?

1. Click the file tab, and then click options. 2. Click Advanced. 3. Scroll down to the Display options for this worksheet section. 4. Clear the check mark next to "Show a zero in cells that have a zero value." 5. Click OK

What steps can save a workbook as a web page?

1. Click the file tab, and then click save as. 2. In the dialog box, click the save as type list, and then click Web Page. 3. Click Save.

How do you customize the Quick Access toolbar?

1. Click the file tab. 2. Click options, and then click Quick Access Toolbar. 3. Select the desired command, and then click Add. 4. Click OK.

What steps will open the Excel Options dialog box?

1. Click the file tab. 2. Click options.

What steps can you use to create a text box?

1. Click the insert tab. 2. Click text box.

What steps can be used to create a watermark-like effect in a worksheet?

1. Click the insert tab. 2. Click the Header & Footer group, and then click in the header. 3. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click picture. 4. Navigate to an image, and click Open. 5. To see how the watermark looks, preview how the file will print.

What steps can be used to track changes in a workbook?

1. Click the review tab. 2. Click Track Changes, and then click highlight changes . 3. In the dialog box, specify how to track the changes, and then click OK.

What steps can you use to open the pane for restricting edits to tracked changes?

1. Click the review tab. 2. Click protect, and then click restrict editing. 3. The Restrict Formatting and Editing pane appears with options for restricting tracked changes.

What steps can you use to view changes by different viewers?

1. Click the review tab. 2. Click show markup, then click reviewers , and then click the names to select or deselect them.

What steps can be used to password-protect a worksheet?

1. Click the review tab. 2. In the Changes group, click protect sheet . 3. Type a password, and click OK. 4. Reenter the password, and click OK.

What steps can be used to show all comments in a worksheet?

1. Click the review tab. 2. In the Comments group, click Show All Comments.

What are the steps for creating a cell style?

1. Format a cell the way the style should look. 2. Select the formatted cell. 3. Click the home tab. 4. In the Styles group, click cell styles, and then click New Cell Style. 5. In the Style dialog box, name the style, and then click OK.

Identify the steps for modifying a style.

1. In the Cell Styles gallery, right click the style, and then click Modify. 2. Clear formats to remove them, or change formats by clicking format, making changes, and clicking OK. 3. Click OK.

What are the steps for creating a custom number format?

1. In the Format Cells dialog box, click the number tab. 2. On the Category list, select custom. 3. In the Type box, type the format code. 4. Click OK.

What steps can be used to open the Custom AutoFilter dialog box?

1. On the Data tab, in the Sort & Filter group, click Filter. 2. Next to a column heading, click the AutoFilter drop-down arrow. Click text filters, and then click Custom Filter. The Custom AutoFilter dialog box appears for creating custom filters.

What steps can modify the cells referenced in a named range?

1. On the formulas tab, in the Defined Names group, click name manager. 2. In the dialog box, select the range name. 3. In the Refers To field, manually change the cell references, or click the collapse button and select the cells, and then click the collapse button again to return to the Name Manager. 4. Click OK.

What steps can display a file saved as a web page?

1. Open a web browser. 2. Click the File menu, and then click open. 3. Use the dialog box to browse to the location where the file is saved, and open the file. 4. The file is displayed in the web browser.

What steps can be used to change where templates are stored?

1. Open the Excel Options dialog box. 2. Click advanced. 3. Under General, in the at startup, open all files in box, enter the folder path to use for templates. 4. Click OK.

What are the steps for creating a 3-D range name?

1. Open the Name Manager, and click new. 2. Delete the value in the refers to box. 3. Click a sheet tab to specify the starting sheet in the range. 4. Press and hold the shift key while clicking another sheet to specify the ending sheet. 5. Click a cell to insert the cell reference. 6. Click OK.

What steps can be used to create a new template?

1. Open the file to use as a template. 2. Click the File tab, and then click save as . 3. On the "Save as type" list, click excel template. 4. Choose a name for the template. 5. Click Save. 6. Close the template.

What steps can publish part of a file as a web page?

1. Open the save as dialog box. 2. Select Web Page as the file type, and then click publish. 3. From the choose list, select the part of the file to publish. 4. Click the Publish button.

What steps can you use to view two documents at once?

1. Open the two documents you want to view. 2. Click the view tab. 3. Click the view side by side icon.

What steps can be used to share a workbook?

1. Open the workbook. 2. Click the review tab. 3. Click Share Workbook. 4. In the Share Workbook dialog box, click the editing tab. 5. Check "Allow changes by more than one user at the same time." 6. Click OK. 7. Save the workbook.

What steps can be used to add a picture to a worksheet?

1. Select a cell. 2. Click the insert tab. 3. In the Illustrations group, click Picture. 4. Open the folder that contains the picture. 5. Select the picture, and click Insert.

What steps can be used to create a trendline in a chart?

1. Select a chart. 2. Click the Chart Tools layout tab. 3. Click analysis, click Trendline, and then click a type of trendline.

What are the steps for subtotaling data?

1. Select any cell in the data block. 2. Click the data tab. 3. In the Outline group, click Subtotal. 4. In the Subtotal dialog box, choose when to subtotal and what type of subtotaling to do. 5. After selecting the settings, click OK.

What steps can be used to auto-filter data?

1. Select any cell in the data range. 2. Click the Data tab. 3. In the Sort & Filter group, click Filter. 4. Use the drop-down arrows next to the column headings to control how to filter the data.

What steps can sort data by multiple columns?

1. Select any cell in the range of data. 2. Click the data tab. 3. In the Sort & Filter group, click Sort. 4. Select the column to sort by, and then select a sort order. 5. Click add level. 6. Select the next column to sort by, and select the sort order. 7. Click OK.

What steps can add range names to existing formulas?

1. Select cells containing formulas with cell references to replace with names. 2. On the Formulas tab, in the Defined Names group, click the define name drop-down arrow, and then click Apply Names. 3. From the Apply Names list, select the names to apply. 4. Click OK.

What steps can be used to modify a hyperlink?

1. Select the cell containing the hyperlink. 2. right click, and then click edit hyperlink. 3. Modify the hyperlink as desired. 4. Click OK.

What steps can be used to create a hyperlink?

1. Select the cell where the hyperlink should appear. 2. Click the insert tab. 3. In the links group, click Hyperlink. 4. Specify the text for the link to display. 5. Specify the target file or web page. 6. Click OK.

What are the steps for transposing data?

1. Select the cells containing the data and headings to transpose. 2. copy the data to the clipboard. 3. paste the data, and choose the paste special Transpose option. 4. If needed, resize the columns.

What steps can be used to merge cells?

1. Select the cells to merge. 2. Click the home tab. 3. In the Alignment area, click the Merge and Center button.

What steps can be used to add a secondary axis to a combination chart?

1. Select the chart. 2. Click the Chart Tools format tab. 3. Select the data series from the Chart Area list. 4. Click format selection. 5. Under Plot Series On, select Secondary Axis. 6. Click Close.

What steps can be used to create a combination chart?

1. Select the chart. 2. Click the Chart Tools format tab. 3. Select the data series from the Chart Area list. 4. Click the Chart Tools design tab. 5. Click Change Chart Type. 6. Choose a chart type for the selected data series. 7. Click OK.

What steps can be used to access the options for changing the scale of a chart's vertical axis?

1. Select the chart. 2. Click the Chart Tools layout tab. 3. In the Axis group, click Primary Vertical Axis, and then click More Primary Vertical Axis Options. 4. Use the dialog box to change the scale.

What steps can be used to format a data point?

1. Select the data point in the chart. 2. Click the Chart Tools layout tab. 3. In the Labels group, click data labels, and then click More Data Label Options. 4. Use the settings in the Format Data Labels dialog box to format the data point. 5. Click Close.

What are the steps for automatically creating an outline in a worksheet?

1. Select the data. 2. Click the data tab. 3. In the Outline group, click the group drop-down list, and then click Auto Outline.

What steps can be used to protect part of a worksheet?

1. Select the range for users to modify. 2. Right-click and then choose format cells . 3. Click the Protection tab. 4. Clear the locked checkbox, and click OK. 5. Protect the worksheet.

What are the steps for creating range names from a selection with labels?

1. Select the range or ranges to name, including the labels. 2. On the formulas tab, in the Defined Names group, click create from selection. 3. In the dialog box, use the checkboxes to specify the locations of the labels. 4. Click OK.

What steps can efficiently use AutoSum and add range names to formulas?

1. Select the ranges of cells to add, including the empty cells for the formulas. 2. Use the AutoSum button to add the ranges. 3. Select the cells with the formulas. 4. Click the Define Name drop-down arrow, and then click apply names. 5. Select the correct names, and click OK.

What steps can you use to change a shape into another shape?

1. Select the shape. 2. Click the drawing tools format tab. 3. In the insert shapes group, click edit shape, and then point to change shape. 4. Choose the new desired shape.

What are the steps for creating a custom view?

1. Set up the worksheet with the view that you want to save. 2. Click the view tab. 3. In the Workbook Views group, click Custom Views. 4. Type a name for the view. 5. Click OK.

What steps can be used to create a criteria range?

1. Type the criteria range information into an empty area in the workbook. 2. On the Data tab, in the Sort & Filter group, click advanced. 3. In the List Range dialog box, select the area with the criteria range. 4. Click OK.

Fill in the sentences with the correct terms.

1. a precedent cell provides data to another cell. 2. a dependent cell relies on the value of another cell.

What steps can you use to combine table cells? Use the drop-down menus to complete each sentence.

1. delete the text that is unnecessary. 2. select the cells you want to combine. 3. On the Table Tools Layout tab, click merge cells.

What steps can you use to create a style by example?

1. select the text you like. 2. In the Styles pane, click new style. 3. Fill out the dialog box, and then click OK.

If the left gutter is set to .75 inches and the left margin is set to .5 inches, how much space will appear on the left side of the content?

1.25 inches

Which SUBSTITUTE function is correctly written to replace the second instance of the letter e with a capital E in cell H8?

=SUBSTITUTE(H8,"e","E",2)

Which UPPER function is written so that all text in cell B4 will be capitalized?

=UPPER(B4)

What happens when the mouse pointer hovers over a hyperlink in Excel?

A tool tip appears with the hyperlink's path.

After you modify a style, what happens?

All existing cells with that style applied are updated with the changes.

What will happen when you search for a word in the Navigation pane?

All instances of the word will be highlighted in the document. The Navigation pane will display the context of each instance.

After you modify a table style, what will happen?

All tables with that style will be updated immediately.

What are ways to change the row height in a table? Check all that apply.

Click and drag the bottom border of the row. Put the insertion point in the row, and in the Table Tools Layout tab, type the number you want for the row height.

Which of these methods will remove a custom tab stop?

Click and drag the tab stop off the Ruler.

If AutoCorrect changes something in the text that you didn't want changed, what can you do?

Click the AutoCorrect Options button, and then click Undo Automatic Corrections.

How do you access the setting that prevents Excel from automatically adding new cells to a table?

Click the AutoCorrect Options button.

If you want to change the smart quote settings, what steps should you follow to find them?

Click the File menu, then click Options, then click Proofing, and then click AutoCorrect Options.

What steps can you use to access AutoCorrect Options?

Click the File tab, then click Options, then click Proofing, and then click AutoCorrect Options.

Which steps should you use to create a PDF from a Word document?

Click the File tab, then click Save & Send, and then click Create PDF/XPS Document.

Which steps will allow you to add part of a screen image to your Word document?

Click the Insert tab, and in the Illustrations group click Screenshot. Then, in the application or folder you want, draw the region you are interested in.

How do you add a simple header that will appear in a single column on the left of a document?

Click the Insert tab, click Header, then choose Blank.

What steps can you use to add a graphic to a Word document?

Click the Insert tab, then click Picture, then navigate to the graphic, and then click OK.

Which set of instructions should you use to access the options for converting text to a table?

Click the Insert tab, then click the Table drop-down list, and then click Convert Text to Table.

How do you move the selection to a specific range by its name?

Click the name box drop-down arrow, and then click the range name.

What are some ways to expand the data in an outline so more of it is visible? Check all that apply.

Click the plus signs next to the column and row headers. Click the boxes containing the number 2 next to the column and row headers.

If you split a table and the new table is now missing the header row, what is the best way to add the header row to the new table?

Copy and paste the header row from the first table to the new table.

In many cases, instead of creating an override, it is better to do what?

Create a new style.

When you enforce restrictions, what must you do immediately?

Create a password.

What will happen if you click Clear All in the Tabs dialog box?

Custom tabs are cleared, and default tabs are used.

What are some things you can do with the Building Blocks Organizer? Check all that apply.

Delete a Building Block. Edit the properties of a Building Block. Insert a Building Block into a document.

What can you do to make sure you have access to the Picture Tools area?

Double-click an image.

If you want to use Format Painter to apply formatting to many different selections, what can you do to make this happen more efficiently?

Double-click the Format Painter button.

How can you make the Drawing Tools Format tab appear for a graphical element in a chart?

Double-click the graphic.

What can you do to open the header of a document?

Double-click the header area.

What dialog box appears when you click Format Selection on the Chart Tools Format tab?

Format Data Series

When applying names to existing formulas, what needs to be done after clicking Apply Names?

Make sure Excel automatically selected the correct names.

Before turning a series of items into a bulleted or numbered list, what must you do?

Make sure each item is its own paragraph.

If you add page numbers to a document but they don't show up consistently on the first page or the rest of the document, what should you do?

Make sure the Different First Page setting isn't active.

What must you do before formatting a paragraph?

Make sure the insertion point is in the paragraph.

What are some options available when using the Replace feature?

Match case Match prefix Match suffix Ignore punctuation characters

What are some of the options available when using the Replace feature?

Match case, Sounds like, Ignore punctuation characters

When creating a new style, what must you do?

Name the style.

What are the four main types of section breaks? Check all that apply.

Next Page Continuous Even Page Odd Page

What steps should you follow to access the options for alphabetizing a bulleted list?

On the Home tab, in the Paragraph area, click the Sort button.

After selecting a cell in the data range, what are some ways to create a table? Check all that apply.

On the Home tab, in the Styles group, select a table style from the Format as Table gallery. Press the Ctrl + T keys. On the Insert tab, in the Tables group, click Table.

What are ways to add comments to a worksheet? Check all that apply.

On the Review tab, in the Comments group, click New Comment, and then type the comment. On the File tab, click Info. Click Properties, click Show Document Panel, type the comment, and close the Document panel.

After selecting the text you want to affect, what steps should you use to align text in a table?

On the Table Tools Layout tab, in the Alignment group, click the type of alignment you want.

If you want to see the tab stops, what should you do?

On the View tab, in the Show area, click the Ruler check box.

If you want to add tab leaders, what should you do?

Open the Tabs dialog box.

What are some ways that you can use to add page numbers to a document?

Open the header or footer, and on the Design tab click Page Number. Open the main content, and on the Insert tab click Page Number.

If you want to make the header and footer on the first page different from the header and footer on following pages, what instructions should you follow?

Open the header or footer, click the Design tab, and in the Options area add a check mark next to Different First Page.

What should you do in order to have access to the header and footer tools?

Open the header or footer.

If you are viewing the Envelopes tab of the Envelopes and Labels dialog box and want to change the size of the envelope, what should you click to get those settings?

Options

What format makes it difficult for others to make changes to the workbook content?

PDF

Which tab contains options for adding backgrounds?

Page Layout

When you have printed a label and are ready to use it, what should you do?

Peel it off the page.

If you want to apply the same custom tab stops for a group of paragraphs that already exist, what should you do?

Preselect all of the paragraphs and then apply tab stops.

It is helpful to be in which view when viewing and changing margins?

Print Layout view

After you have set the size and printing options, what two things can you do with the envelope? Check all that apply.

Print it. Add it to the document.

What should you click if you want to access options for making the document print in grayscale instead of color?

Printer Properties

How can you tell Word where you want a graphic to be inserted?

Put the insertion point where you want the graphic.

When a template contains placeholder text, what can you do to make sure the placeholder text doesn't appear in the final document? Check all that apply.

Replace the placeholder text with the text you want to have in the document. Type a space to replace the placeholder text with a blank space. Delete the item and its placeholder text.

What are some options you can use when adding restrictions to a document? Check all that apply.

Require a password to open a document. Give different individuals access to different parts of a document.

What tab should you open to find options for tracking changes?

Review

What steps can unlink a hyperlink?

Right-click the hyperlink, and then click Remove Hyperlink.

What are the steps for deleting a row in a table?

Right-click the row, click Delete, and then click Table Rows.

If you want to modify a table style you've created, what steps should you use?

Right-click the style in the Styles gallery, and then click Modify Table Style.

What tool can be used to change the orientation of the text in a cell?

Rotate Text

If you want a section's header to match the header in the previous section, what should you select?

Same as Previous

What should you do before adding any restrictions to a document?

Save a backup copy for yourself in a secure location.

the Page Layout tab

Section breaks allow you to have areas of the document with different formatting.

Before setting line spacing for a group of paragraphs, what should you do?

Select the group of paragraphs.

Before changing indents in the Paragraph dialog box, what should you do?

Select the paragraphs you want to affect.

When the Find and Replace dialog box is open to the Replace tab and you want to replace an underlined phrase, how can you access the dialog box that lets you tell Word to find the underlined instances of the phrase?

Select the phrase in the "Find what" field, then click More, then click Format, and then click Font.

What steps should you use for formatting text in a table?

Select the portion of the table you want to affect, and then format it like you would normal text.

you want to add three columns to the middle of a table, what should you do?

Select three columns in the table, and then click Insert Right or Insert Left.

What key combination selects all data in a worksheet when the upper left cell is selected?

Shift + Control + End

What keys should you press to open the Reveal Formatting pane?

Shift + F1

Before deleting a page or section break, what do you normally need to do?

Show hidden characters.

What needs to be true of the data used for consolidation?

Similar data are located in the same positions in different worksheets.

When you choose Automatic Hyphenation, what will happen to the text?

Word will break up some words on two lines to balance out the text.

What symbol indicates that something was changed in a document?

a bar on the left

What can you start with to create an envelope? Check all that apply.

a blank document a letter

What sort of image works best for removing the background?

a dark object on a light background

Which documents would benefit most from columns? Check all that apply.

a document with empty space that looks as if something is missing a document with long content that is uninteresting and lacks visual appeal

Which file is most likely to benefit from AutoRepublishing a web page whenever changes are made to the workbook?

a file that is saved on the intranet

What is a template?

a file with predefined areas to fill in

What can a hyperlink link to? Check all that apply.

a file, a web page

What symbol indicates that a cell contains a comment?

a red triangle in the upper right corner

What is a sparkline?

a small chart in a single cell

What does the rotation handle for a graphic look like?

a small green handle

What is metadata?

a small piece of information to better describe something

One way to customize AutoCorrect options is to create a(n)

abbreviation that will be replaced with a long expanded version.

What are some items commonly included on labels? Check all that apply.

address logo artwork

What information should you include on an envelope? Check all that apply.

address of recipient return address

Labels are useful for which purpose in Word?

addresses

What does the Paste Special Add option do?

adds data from existing cells to data that was copied and pasted there

Which method for adding paragraph spaces is the most efficient?

adjusting the Space After setting

What are examples of common types of Excel templates? Check all that apply.

agenda budget calendar expense report invoice

What information is displayed in the Name Manager? Check all that apply.

all range names in the workbook cell references that the range names refer to

When you are presenting locations and there is no obvious order for them, how should you arrange them?

alphabetically

When you first insert a graphic, it will automatically be placed as what type of graphic?

an in line graphic

What situation would benefit most from custom views?

an on-screen presentation

A section break would work better than a page break for which task?

applying different formatting to text within a document

What are some options available on the Table Tools Design tab? Check all that apply.

applying themes exporting and refreshing data looking for duplicate data

When you browse your document by page in the Navigation pane, how do you see your document?

as thumbnails of how the pagination works

If you do a Find and Replace for a term, where will Word begin looking for the term?

at the insertion point

What are some examples of metadata? Check all that apply.

author of the document title of the document

If a worksheet contains text, cell fill colors, and a background, which item will be obstructed behind the others?

background

What style option can help you delineate data as matching up within a row or column?

banded rows or columns

What are some options available when modifying a style? Check all that apply.

based on another style alignment borders shading

Where is the margin of a document?

between the gray and white areas in the Ruler

What do you click to collapse an entire outline?

boxes with the number 1 near the column and row headers

What are some examples of how AutoFormat can convert text as you type?

by converting straight quotes to smart quotes, by starting bulleted and numbered lists, by replacing fractions

How is an override created?

by making a manual change to text that has a style applied

What is a common use for formulas?

calculating totals

When text wrapping is applied to a cell, what changes in the cell?

cell height

What does a 3-D range name refer to?

cells in multiple worksheets

What do the adjustment handles allow you to do?

change the proportions of a shape

What are some options available when you click File and then Print?

changing margins selecting the printer viewing a preview selecting the pages to print changing the page orientation

When you are creating a shape, what are some options you have? Check all that apply.

changing the size of the shape changing the location of the shape adding text to the shape

If you type a label address and the label isn't wide enough for it, what can you do?

choose a different type of label

How can you tell Word to print on a specific label on a sheet of many labels?

choose the row and column of the label

Which should you consider when selecting a highlighting color?

contrast

What is the default AutoCorrect setting for quotation marks?

converting straight quotes to smart quotes

What are some ways you can work with templates? Check all that apply.

creating a new template from scratch using a preexisting template modifying a preexisting template

What are screenshots especially helpful for?

creating documentation

In the Styles pane, modify the heading style.

creating visual appeal without graphics laying out newsletters

What are some options you can set when creating a style? Check all that apply.

custom name type of style based on another style style for following paragraphs

What are some things you can do with labels in Word? Check all that apply.

customize them by season make them on demand

Which line spacing option works well for printing and editing a document?

double spacing

What is a way to rearrange topics in Outline view?

drag and drop

What are some ways used to create tables?

drawing a table using a dialog box converting text to a table

What items does Excel automatically assume should be hyperlinked? Check all that apply.

e-mail addresses web addresses

What is an option when printing envelopes?

electronic postage

What is the name for restricting access to a document by adding a password?

encrypting

Templates are especially helpful for which types of documents? Check all that apply.

fax cover sheets memos letters

What is the trickiest part of printing envelopes?

feeding them into the printer

What are some examples of what can be changed through options available in the Font dialog box? Check all that apply.

font family, italicizing, bolding, drop shadow, character spacing

What are some examples of settings you can control with styles? Check all that apply.

font size font family line breaks page breaks

What sorts of properties can you learn about in the Reveal Formatting pane? Check all that apply.

font, paragraph, section properties

How are comments are commonly used?

for giving opinions about parts of a document

What purpose would tracking changes be most useful for?

getting feedback from multiple people on a document

What does an outline do?

groups data by levels

What are some types of indents you can control on the Ruler?

hanging indent, left indent, right indent, first line indent

What outline feature can the Navigation pane browse the document by?

headings

What are some ways to customize the built-in options on the Excel Ribbon? Check all that apply.

hiding built-in tabs hiding built-in groups hiding built-in commands

What are some options for modifying a custom tab that was added to the Excel Ribbon? Check all that apply.

hiding the tab removing the tab changing the tab

To create a pull quote, how should you format the text?

in a text box

If you have a header row that is repeated on multiple pages, where can you edit the text in the header row?

in the first header row of the table

Where should a range name be entered?

in the name box in the formula bar

Which tab contains the options for adding sparklines?

insert

Which tab should you open to find the option for adding a header?

insert

What are some ways to add a column in a table? Check all that apply.

insert a column to the left or right of the current column split the cells in a selected column

Which alignment option will line up the text evenly on both the left and right edges?

justify

What are some ways to improve the visual appeal of columns? Check all that apply.

justifying the text adding a line between columns

What are some options you can set when adding a border? Check all that apply.

line type line weight where to apply the border

When changing a shape into another shape, what should you be cautious about?

making sure any text still fits in the object

When adding artwork to a label, what should you be careful about?

making sure the artwork fits on the label

What can cell margins be useful for?

making sure there is space between content in different cells

Where in the dialog box for creating a new style can you choose the character style option?

next to Style type

What are some formatting options for what to include when creating a new cell style?

number alignment font border

What are some options you can set when formatting page numbers? Check all that apply.

number format chapter numbers continue from a previous section

What are some options that can be set when adding page numbers?

number format, chapter numbers, continue from a previous section

What are some examples of document statistics? Check all that apply.

number of pages number of words number of characters number of paragraphs number of lines

Where can the default font size be changed for Excel?

on the General tab of the Excel Options dialog box

Where in the Word interface can you see the indent markers?

on the Ruler

What are some locations in the Word interface where you can control indents?

on the Ruler, in the Paragraph dialog box

Where can you access the Borders menu?

on the Table Tools Design tab

Where in the Word interface can you find the gallery of table styles?

on the Table Tools Design tab

Where can you find the Split Table command in the Word interface?

on the Table Tools Layout tab

Where can you find the sizing handles for a graphic? Check all that apply.

on the edges of the graphic on the corners of the graphic

Where can you control tab settings?

on the ruler, and in a dialogue box

Where will the return address appear on an envelope?

on the upper left

Which comparison operator is used when at least one of the criteria must be true in order to display the data?

or

Which tab contains the Themes gallery?

page layout

Headers and footers are helpful for sharing what sorts of items?

page numbers company names logo

What colors are best for shading in a document that will be printed and copied?

pale colors

What are elements that can have borders and shading applied to them?

paragraphs, pages

What are some types of graphics you can add to a Word document?

photos from a digital camera clip art from a directory online or in Word artwork drawn on the computer

What content is commonly included on an envelope? Check all that apply.

postage return address address of recipient

What is the best way to see exactly how an image will look?

printing a copy of the image

Word's envelopes feature is useful for which purpose?

printing the information directly on the envelope

What statements accurately describe a digital signature? Check all that apply.

protects data as they travel over the Internet must be purchased from an authorized authority

Before you insert a page break, what should you do?

put the insertion point where you want the page break to happen

What are some ways in which AutoCorrect is commonly used?

putting in special characters, fixing accidental usage of the Caps Lock key, fixing capitalization

What will compression do to an image?

reduce its file size

What will the function =SUBSTITUTE(F7,"g","b",2) do?

replace the second instance of the letter g in cell F7 with the letter b

What does the Transpose Paste Special option do?

reverses the headings across the top and left side of data

What are some examples of options you can control in the Adjust group to affect an image?

saturation tone sharpness compression brightness

The options for saving a file as a web page are available in which dialog box?

save as

What are some ways to generate styles in Word documents? Check all that apply.

selecting styles from preexisting galleries modifying styles from galleries creating styles from scratch creating styles from examples

What options are available on the Advanced tab of the Share Workbook dialog box? Check all that apply.

set the interval at which changes are shown merge the copies into a single workbook

In order to view a page break, what should you do?

show nonprinting characters

Merged cells may not work well if you want to do what sorts of things?

sorting and other advanced elements

What are some examples of options you can use for bullets

symbols, pictures, fonts

What information does a structured reference use instead of cell or range addresses? Check all that apply.

table names column headings

If you want to make a style available in all other new documents, what template should you copy the style to in the Import/Export Organizer?

the Normal template

Which tab shows the paragraph spacing settings?

the Page Layout tab

To access the Tabs dialog box, you must first open what other dialog box?

the Paragraph dialog box

What are some basic questions and options you will encounter on the Labels tab of the Envelopes and Labels dialog box? Check all that apply.

the address for the label the size of paper or product number of labels per page

When you sort by three columns, which column will be sorted perfectly?

the first column listed in the Sort dialog box

When you use drop caps, what part of a document will be affected?

the first letter in a paragraph

If you don't manually change it, stacking order is automatically determined by what?

the order in which the objects were created

What aspects of a table can be affected using the Table Properties dialog box? Check all that apply.

the overall table the table rows the table columns the table cells

If you are applying styles and notice some new page breaks where you didn't expect them, what should you check?

the paragraph properties of the styles

What are some settings you can control when formatting columns? Check all that apply.

the part of the document to apply the columns to the number of columns the width of each column the line between columns the margins

When you apply border settings, what part of the table will the borders be applied to?

the selected cells

What should you click in order to select an entire table?

the table move handle

If the Ruler is not visible and you want to see it, where can you go to make it visible

the view tab

When saving templates, it is a good idea to include what information in the template name?

the year or version number

What is the maximum number of columns you can sort by in the Sort dialog box?

three

What is the WordArt gallery especially useful for?

titles

What types of content benefit most from merging cells? Check all that apply.

titles notes areas

What are some ways in which you can use AutoFormatting?

to add shortcuts for special characters and symbols, to capitalize the first letter of a sentence, to fix typos, to turn straight quotes into smart quotes

What is a common reason to use shading in a table?

to delineate a heading section

What is the purpose of a theme?

to make sure the colors in a worksheet look good together

What is the most likely reason for protecting a worksheet?

to prevent unauthorized users from making modifications

What is a common reason for using diagonal borders?

to show empty space

What are some options available for tracking changes? Check all that apply.

tracking formatting changes tracking changes by author styles and colors for insertions and deletions

What are some ways you can use to insert a page break?

use the Control + Enter keyboard command, click the Page Layout tab and change the settings in the Page Setup dialog box

What are some default options that can be changed in Excel? Check all that apply.

user name file format AutoRecover frequency and location custom lists for the AutoFill feature

What are some options for sending a page to someone? Check all that apply.

using e-mail saving it to the web saving it to a SharePoint site

What are examples of options available in the Alignment group of the Table Tools Layout tab? Check all that apply.

vertical alignment horizontal alignment text direction cell margins

What are some activities that work especially well in Outline view? Check all that apply.

viewing big-picture topics rearranging topics showing and hiding details understanding a document's logic

At what point in the process can you choose whether you want the pasted text to inherit the formatting of its destination?

when you are pasting the text

Identify when it would be most helpful to use table styles.

when you are planning to have a lot of similar tables

superscript or subscript

when you want text to appear toward the top or bottom of a line

Basing one style on another would be most helpful in which situation?

when you want to create a hierarchy of related headings of different sizes

What situations would a PDF be most useful for?

when you want to prevent others from editing a document when you want to make sure people who don't have Word can view a document

strikethrough

when you want to show what something was and what it should be

hidden

when you write non printing instructions for filling out a form

What is Word's default color for highlighting text?

yellow

What does the @ symbol in a formula mean?

The structured references are modified per row.

What are some problems that can occur when using overrides? Check all that apply.

The style guide may become cluttered. Text with the override won't respond when changes are made to its original style.

If you add text to a shape that doesn't have enough room for the text, what will happen?

The text will wrap.

If a worksheet has some theme colors and some standard colors, what happens when a new theme is applied?

The theme colors change, but the standard colors do not.

If you select the option for header row in the Sort dialog box, what will happen?

The top row in the table will be excluded from the sort.

When you accept or reject a tracked change in a document, what happens to the tracking for that change?

The tracking disappears and the text becomes normal text.

What happens if a workbook is marked as final?

The workbook becomes a read-only file.

What are some features of character styles? Check all that apply.

They are applied manually. They can be layered on top of paragraph styles.

Which statements accurately describe Building Blocks? Check all that apply.

They consist of portions of a document. They are available in built-in galleries. They can be combined in a template or document.

When you align a table in relation to the content around it, what happens to the table's cells?

They keep the alignment they already had.

When you are converting text to a table, what will typically happen to paragraph breaks?

They will create new rows

What is the most efficient way to change a specific phrase's formatting throughout a document?

Use Replace All to replace that phrase with the same phrase with different formatting.

What are ways to select a hyperlink in Excel without activating it? Check all that apply.

Use the arrow keys to select the cell. Press and hold the mouse button until the pointer changes to a cross.

What happens when a workbook's structure is protected?

Users must enter a password to view hidden content.