Activedumpsnet Logo
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 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.
Project 4 of 7: Car Inventory
Overview
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” with the text “Truck”.
Project 7 of 7: Farmers Market
Overview
You are the Director of a local farmers’ market. You are creating and modifying charts for a report which shows the amounts and variety of products sold during the season.
On the “Spring Sales” worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the 3-D Pie chart.
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited sourcefile, contributors.txt, located in the Documents folder. (Accept all defaults.)
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.