77-727 Exam Questions

On the "Customers" worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.

On the "Customers" worksheet, sort the table to order the records by the "CountryOrRegion" field, with customers in the United States first and customers in Canada second. Then sor...

On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the "CurrentAge" column.

On the 'Products' worksheet, apply a number format to display the numbers in the 'Weight' column to three decimal places.

On the "Orders-worksheet", use an automatic formatting method to format cells in the "OrderTotal" column that contain above-average values by applying Green Fill with Dark Green Te...

On the 'Orders' worksheet, enter a formula in cell J2 that uses an Excel function to return the "OrderTotal" value of the individual order that has the highest "OrderTotal" value.

On the 'Customers by Order' worksheet, use an Excel data tool to remove all records with duplicate 'CustomerID' values from the table. Do not remove any other records.

Beginning at cell A5 of the '$5,000 Donors' worksheet, import the data from the tab-delimited source file, contributors.txt, located in the Documents folder. (Accept all defaults.)

Navigate to the range named "Oregon", and remove the contents of the selected cells.

Add a new worksheet named "$1,000 Donors" to the workbook.

On the "$5,000 Donors" worksheet, hyperlink cell C3 to the email address "[email protected]".

Arrange the worksheets so that "$5,000 Donors" is first.

Change the margins to 1.0" (2.54 cm) on the top and bottom, 0.75" (1.90 cm) on the left and right, with a 0.5" (1.27 cm) header and footer.

You are updating the inventory worksheet for a local tree farm. Remove the rows 29 and 30.

You are updating the inventory worksheet for a local tree farm. Configure the worksheet so that row 9 and the WordArt remain visible as you scroll vertically.

You are updating the inventory worksheet for a local tree farm. Check the spreadsheet for accessibility problems. Correct the error by adding 'Tree Nursery Inventory' as an alterna...

You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale. Configure the worksheet so the column headings in row 9 appea...

You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale. Simultaneously replace all instances of the text "Pickup" wit...

The discount price is 95 percent of the price. Modify column J to show the discount price for each car.

Modify the cell formatting of cell J9 to display the text on two lines.

Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.

On the "Adult Program" worksheet, insert a Column sparkline for each sport that shows the enrollment for the past five years.

On the "Youth Program" worksheet, create a table from the cell range A9:G19. Include row 9 as headers.

Un-hide the "Summary" worksheet.

Add the Alternative Text Title "Adult Enrollment" to the "Adult_Program" table.

In cell M9 on the "Summer Bookings" worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.

In cell M10 on the "Summer Bookings" worksheet, insert a function that calculates the total amount of sales from the "Total" column for groups containing 12 or more people even if...

In cell C8 on the "Summer Bookings" worksheet, insert a function that joins the customer "Lastname" to the customer "Firstname" separated by a comma and space. (Example: Campbell,...

On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell formatting and location of the data.

Insert page number in the center of the footer on the "Summer Bookings" worksheet using the format Page 1 of 7.

On the "Summer Sales" worksheet, use the data in the "Products" and "Total" columns only to create a 3-D Pie chart. Position the new chart to the right of the column charts.

On the "Summer Sales" worksheet, add the "Total" data series to the "Top Sellers" column chart. Include the total only for "Fruits", "Vegetables", and "Jams & Honey".

On the "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis "Gross Sales" and the horizontal axis "Months".

On the "Spring Sales" worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the 3-D Pie chart.

On the "Summer Sales" worksheet, switch the rows with the columns on the first column chart.