Excel - Bike Shop

Create an Excel spreadsheet that looks like the image to the below.

Insert a Header that contains your name on the left, Bicycle Inventory in the center and the date on the right.

Use formulas to answer the following questions:

1. How many bicycles are there altogether in Store 2?

2. How many red bicycles altogether in both stores?

3. How many bicycles are there in total?

=sum(xx:xx)

=xx-xx

=xx+xx

=xx*xx

=xx/xx

AutoSum