contestada

a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell J2 in the formula.

Respuesta :

MrRoyal

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell E5 is = D5 * $J$2

From the question, we have:

  • Cell D5 represents the actual hours
  • Cell J2 represents the billing rate

The product of the actual hours and the billing rate is represented as follows:

D5 * J2

Cell J2 is to be referenced using absolute reference;

So, we rewrite the above formula as follows:  D5 * $J$2

Excel formulas begin with the equal sign

So, we rewrite the above formula as follows:  = D5 * $J$2

This means that, the formula to enter in cell E5 is: = D5 * $J$2

 

Read more about Excel formulas at:

https://brainly.com/question/14820723

Otras preguntas