Online Access Free 77-727 Exam Questions

Project 5 of 7: City Sports
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and
youth sports programs. You have been tasked to prepare tables for the analysis.


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

Project 3 of 7: Tree Inventory
Overview
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
alternative text file. You do not need to fix the warning.

Project 6 of 7: Bike Tours
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next
six months.

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, David).

Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.






























On the "Customers" worksheet,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.

Project 6 of 7: Bike Tours
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next
six months.

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 the order of the rows is changed.