Chapter 3

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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)


संबंधित स्टडी सेट्स

Basic Life Support Certification (BLS)

View Set

Graded Potentials, Action Potentials&Synapse

View Set

Chapter 24: Management of Patients With Chronic Pulmonary Disease

View Set

Rita Questions - Ch 12 Procurement Management

View Set

Fundamentals of Insurance Chapter 3

View Set

Chapter 38: Family-Centered Care of the Child During Illness and Hospitalization NCLEX

View Set