excel
shouqaljumah
SP-1.
1. Complete the problem as follows:
a) Open a new workbook start a new worksheet and name it “references”
b) Create a spreadsheet as shown below. The variable A has the value 0.58. “X” represents values
from 2 to 20 in increments of 2 (suggest you use a formula “cell to the left + 2”), placed in a row.
Y has values from 1 to 10, in increments of 1, placed on a row.
c) Use the formula C = X*Y A , fill in the table using X and Y values taking advantage of relative and
absolute references. Only the first and last value are shown in the table below. Your
spreadsheet should show all the values.
d) Format your spreadsheet like the one below. Format the value of A with a red background, X
with a light green background and Y with a yellow background.
e) Format the equation values inside to 2 decimal places.
A = 0.58
X 2 4 6 8 10 12 14 16 18 20
Y
1 2.00
2
3
4
5
6
7
8
9
10 76.04