You have been given a spreadsheet like the following image below $($but without cells filled in that that

require formulas or functions$).$ This worksheet includes book orders for several colleges or universities in

the area. The names of each college or university are listed in Column A$,$ rows $6$ through $10.$ There are

three types of books to be ordered: an Excel book, an Access book, and a PPT book. The book price for

each book is the same for all institutions and is provided in row $5,$ columns C$,$ D and E for each book type

$($Excel$,$ Access, and PPT$).$ Each college has ordered a specific number of each type of book. These numbers

are recorded in columns C$,$ D$,$ and E$,$rows $6$ through $10.$ In addition,there is a percentsales tax $($formatted

as a percent$)$ in Column B that is provided for each institution. Last, note that there is a standard shipping

cost in cell B$2$ for each book that is shipped. You will calculate the total quantity of all books ordered by

each institution, the total cost of all books ordered by each institution, the tax required for all books

ordered by each institution, the shipping cost for all books orders by each institution, a grand total, and a

percent total that each type of book is of all the books ordered by each institution $($formatted to show as

a percentage$).$ Rows $12,13$ and $14$ require you to calculate the overall average, minimum, and maximum

of each type of book across all institutions. Note that a dash is the accounting format for a zero and that

several columns and$/$or rows use this format.

Download the Excel start file to begin your work. Notice that this start file only includes the data shaded

in gray or data that is given to you in it$.$ You will be inputting proper formulas or functions for the remaining

data in the unshaded cells by answering the following questions using formulas or functions and cell

references from this worksheet. You will input your formulas or functions in the spreadsheet, NOT in this

file. Remember to start all formulas or functions with an equal $(=)$ sign and to always u