Chapter 3

You are working in the worksheet shown below. What formula in cell B4 will calculate the profit in January?

=B2-B3

In the worksheet shown below, you click in cell E4 and then click Autosum. What will be the result?

The formula =SUM(E2:E3) will be added to the cell to add the total sales and costs.

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products?

by typing =d5-d6

You are working in the worksheet shown below. What will happen in cell C4 if you use the fill handle to drag cell B4 to C4?

The formula =C2-C3 will appear in cell C4.

In the worksheet shown below, you want to use the XLOOKUP function to find the employee whose number appears in cell I2. Using the data in columns A and B, what formula is needed in cell J2?

=XLOOKUP((I2,B:B,A:A)