Formula Calculation Below you can see Constants A, B, C, D, and E and their respective...

Transcribed Image Text:

Formula Calculation Below you can see Constants A, B, C, D, and E and their respective Values. To the right is a partially complete table with X and Y variables. The goal of this exercise is to correctly build a function in column F1(XY) and F2(XY) using correct order of operations and referencing. The formulas you are assigned to calculate are shown below. Checklist Use the formulas below to calculate the missing values in the table. The formula in the first cell should be copied into the remaining cells in each column. Note that constant value references should be locked; relative references should not. Reference all values rather than typing them manually Format the cells in the F1 table to show 2 decimal places; format values in the F2 column to show 0. F(X,Y) = A + BX + CXY + DYE BY F(X,Y) = AX + + D) + DX Constants Variables and Formulas Constant Values X Y F(XY) A 2.25 5 5 B -3.14 0 1 C 1.59 0 2 D 2.00 0 3 E 2.50 4 1 0 1 1 1 2 1 3 1 4 2 0 2 1 2 2 F(XY) Formula Calculation Below you can see Constants A, B, C, D, and E and their respective Values. To the right is a partially complete table with X and Y variables. The goal of this exercise is to correctly build a function in column F1(XY) and F2(XY) using correct order of operations and referencing. The formulas you are assigned to calculate are shown below. Checklist Use the formulas below to calculate the missing values in the table. The formula in the first cell should be copied into the remaining cells in each column. Note that constant value references should be locked; relative references should not. Reference all values rather than typing them manually Format the cells in the F1 table to show 2 decimal places; format values in the F2 column to show 0. F(X,Y) = A + BX + CXY + DYE BY F(X,Y) = AX + + D) + DX Constants Variables and Formulas Constant Values X Y F(XY) A 2.25 5 5 B -3.14 0 1 C 1.59 0 2 D 2.00 0 3 E 2.50 4 1 0 1 1 1 2 1 3 1 4 2 0 2 1 2 2 F(XY)