Understand functions.
a. Click the Sheet2 worksheet tab. Notice the list of June specials With the list of Items and prices.
b. Click cell Ell, type=, tyP,e su to display a list of functions beginning with "su", then double-click SUM.
c. Select cells BS:BlO, then click the Enter button on the formula bar. Notice the Total amount of all the prices in cell Bll.
d. Click the FORMULAS tab, then click cell B12, which is where you need to enter a formula that counts the number of items in the June Special list.
e. Click the AutoSum button list arrow in the Function Library group, click Count Numbers, select the range BS:BlO, then click the Enter button. Notice the value in cell B12, which tells you how many items are in the June Special list.
f. Click the Sheetl tab, then save your changes.