Excel(Task2,Functions (1,2)

Someone is trying to find the average profit amount between January and July, using the formula in cell B9.

What mistake did this person make?

• Using parentheses in the formula

   

• Using an incorrect formula

•   The location of the equals sign

• Using the incorrect range

What is the formula in cell B3 doing?

• Subtracting inventory costs from the total budget  

• Subtracting the total budget from inventory costs

• Finding the average budget total

• Multiplying inventory costs by the total budget

In this example, what information would this formula find:

=MAX(B2:B6)

•   Average distance

• Longest distance

• Total distance

• Shortest distance

In this example, what's wrong with the formula in cell B5?

• It should use division instead of multiplication.

     

•   It should use subtraction instead of addition.

• Without parentheses, multiplication is performed too early.

• Nothing. This formula is correct.

Select the formula that will subtract the inventory costs from the monthly budget.

• =B3/B2

• =B3-B2

• =B3*B2

• =B2-B3

Which formula will subtract the inventory costs from the annual budget and then divide by 12?

• =(B2-B1)/12

      

• =(B1-B2)/12

• =B2-B1/12

• =B2-(B1/12)

Which formula would find the fastest time for this running log?

• =AVERAGE(B2:B6)

• =SUM(B2:B6)

• =MIN(B2:B6)

• =MAX(B2:B6)

In this example, which formula would find the average time for a 3-mile run?

• =AVERAGE(B2,B6)

• =AVERAGE(B2:C6)

• =AVERAGE(B2:B5)

• =AVERAGE(B2:B6)

  How would we type 15% as a decimal?

• 1.5

• 0.15

• 0.015

• 15

Which formula would calculate the price after a 15% discount?

Here's a hint: Because we know we'll get 15% off, you could also say the final cost would be 85% of the original total.

• =B5/0.85

• =B5*0.85

• =B5-0.15

• =B5*0.15