21 WORD2007 : Creating and Customizing DocumentsCreate a new document based on the Median Letter built-in template. Add some text to the new document, and then save it as a new template with the name MCAS Template.Open the Header document, add a Motion (Even Page) header with the text The Taguien Cycle, and specify that the header should not appear on the first page. Then on page 2, add a Motion (Even Page) footer that displays today’s date.Open the Contents document, and at the top of the document, create a table of contents based on heading styles that uses the Classic format and dotted line page-number leaders. Then alter the document by inserting page breaks, and update the entire table of contents to reflect your changes.Open the AutoCorrect document, and then add the misspelling avalable with the correct spelling available to the AutoCorrect list.Open the CustomQATAll document, and add an AutoText button to the Quick Access Toolbar for all documents. Then insert a separator between the three default buttons and the AutoText button.

22 WORD2007 : Creating and Customizing DocumentsOpen the AutoCorrect document, and then add the misspelling avalable with the correct spelling available to the AutoCorrect list.Open the CustomQATAll document, and add an AutoText button to the Quick Access Toolbar for all documents. Then insert a separator between the three default buttons and the AutoText button.

23 WORD2007 : Formatting ContentOpen the Characters document, and format the Beautiful Bamboo heading with the Stencil font. Make it bold and 26 points, apply the Outline effect, and expand the character spacing by 2 points. Then change its color to the light green standard colorOpen the Finding document, and highlight all instances of The Taguien Cycle. Then change all instances of The Taguien Cycle to italic.In the Pages document, insert a Next Page section break before the Shipping Quick Reference heading, set Wide margins for the new section, and change the header of the new section to Shipping Quick Reference.

24 WORD 2007 :Working with Visual ContentOpen the SmartArt document, and at the end of the document, insert a Vertical Process diagram. In the text pane, type The Journey, The Battle, and The Twist as bullet points. Then add a new shape containing the words The Climax.Open the Logo document, and lighten the color of the logo to Accent Color 1 Light. Then adjust its brightness to +10% and its contrast to -30%. Finally, give the logo a three-dimensional perspective by changing its style to Rounded Diagonal Corner, White.

25 WORD 2007 :Working with Visual ContentOpen the DropCap document, and replace the first letter in the first paragraph with an In Margin drop cap.Open the TextBoxes document, and insert a Simple Text Box, and then cut and paste the paragraph of the document into the text box.Continuing in the TextBoxes document, decrease the size of the text box to 1.25 inches high by 2 inches wide, and then draw another text box of the same size below the fi rst one. Link the two text boxes so that the overflow text from the fi rst box is displayed in the second text box.

26 WORD 2007 :Organizing ContentOpen the SavedText document, and at the end of the document, select and save Wide World Importers as an AutoText Quick Part named www. Then in a new paragraph at the end of the document, type Recommended by and insert the www Quick Part.Open the SortTable document, and sort it in ascending order by State, then City, and then Last Name.

27 WORD 2007 :Organizing ContentOpen the Calculations document, and in the cell below the Total column heading, enter the formula =C2*B2 with the $#,##0.00;($#,##0.00) number format.Open the Footnotes document, and cut the last sentence from the end of the first paragraph. Then insert a footnote, and paste the cut item as the text of the footnote.Open the MergingData document, attach the DataSource workbook, and preview the merged letters. Then exclude Linda Martin from the merge before merging the letters to a new document.

28 WORD 2007 :Reviewing DocumentsOpen the TrackChanges2 document, accept all the formatting changes, and reject all the changes made by Florian Stiller.Open the Comments document, and in the fifth column of the table, add the comment Ultra line. Then delete the comment associated with the word competitors.

29 WORD 2007 :Reviewing DocumentsOpen the Viewing1 document, and change the magnification so that you can see two pages side by side. Then zoom to 100%, and jump to the Shipping heading. Finally, jump to the top of page 5.An original document, Comparing1, has been revised and saved as Comparing2. Compare the formatting of the Comparing1 and Comparing2 documents at the word level in the original document, with all comparison settings selected. Then view the original document and the revised document simultaneously.

30 WORD2007 : Sharing and Securing ContentOpen the Compatibility document, and determine whether it is compatible with earlier versions of Word.Open the Finalizing2 document, and mark it as final.

32 Excel 2007 : Creating and Manipulating DataOpen the FillCustom workbook. Using the fill handle and AutoFill Options button, fi ll cells B1:K1 with the days Monday through Friday, repeated twice.Open the Duplicates workbook, and remove each entry that contains the same last name and phone number as another entry.Open the CopyPaste workbook and transpose the CategoryName column values to the first row of a new worksheet.

33 Excel 2007 : Creating and Manipulating DataOpen the CopyPaste workbook and transpose the CategoryName column values to the first row of a new worksheet.Open the PersonalMonthlyBudget workbook and freeze rows 1 through 9, so that when you scroll the rest of the workbook, those rows are always visible. Then unfreeze the panes.Open the SalesReport workbook, and make a copy of the By Product worksheet.

34 Excel 2007 : Formatting Data and ContentOpen the Gridlines workbook, and on the Expenses worksheet, hide the gridlines and row and column headings .Open the Hiding workbook. Hide the column containing the Inventory ID and the row containing the data’s source notes.Open the FormatCells workbook, and select cell K10. Format the cell to display its contents in either of the currency formats (Currency or Accounting) with no decimal places. Then apply the same formatting to cells K11:K23.In the TableStyle workbook, add a Total row that computes the number of items in the Product column and the average price from the Unit Price column.

35 Excel 2007 : Creating and Modifying FormulasOpen the SalesBySeason workbook. On the Summary worksheet, display the total sales for each period in cells B2, B3, B4, and B5 by referencing the corresponding worksheets.In the SummaryFormula workbook, in cell C18, create a formula that returns the average value in the Sales range. Then in cell D5, create a formula thatn returns the lowest Sales value for the Fall period.Open the Sales workbook, and create subtotals of sales amounts first by Period.Open the SummaryCondition workbook, and in cell F2, create a formula to count the number of Berry Bushes products in the cell range A2:A38, which has been defi ned as the named range Category. Then in cell F8, count the number of Flowers products in the Category range that are more than $20.00.

36 Excel 2007 : Creating and Modifying FormulasOpen the LookupFormula workbook, and create a formula in cell C12 to find the last name of employee number 5.Open the Schedule workbook, and then display and print the formulas.Open the Grouping workbook, and outline the data on the SalesByCategory worksheet based on its summary rows. Then hide all rows except those containing subtotals.Open the Sorting workbook. Sort the SalesByCategory worksheet first by Category and then by Category and Price.