94 total views,  1 views today

1. The function used to calculate the value of pens as follows in D3. Accordingly, write the functions to be entered for cells D4 to D6. Cell Address Function D4 D5 D6

2. Write down two methods that can be used find value of other items when using spreadsheets, instead of re-entering functions as above.

3. The function entered into cell C2 is = A2 * B2. Write functions when copied from C3 to C10. 4. The function entered into cell B3 is = B1 * B2. Write functions when copied from C3 to K3. 5. Complete the table according to the cell references below

(              D\$9        /           D9           /             \$D\$9     /               \$D9        )

 Cell reference Description Relative cell reference Row absolute cell reference Column Absolute Cell Reference Rows and columns Absolute cell reference

1. The function entered into cell C2 is A2 * B2. Answers appeared when copied from C3 to C10 as shown in the figure. Explain. 1. Write two types of formula to find value in D3 cell. (Number * Multiplication Value).

Your formula should have the capability to copy to the range C3:C10 to obtain the correct value.

7. Write two types of formula to find value in B3 (Number * Multiplication Value)

Your formula should have the capability to copy to the range B3:I3 to obtain the correct value? 1. Study the worksheet below. Enter the function correctly and underline the relevant answer. Write a function to get value for cell C2. That should have the capability to copy to the range D2:F2 to obtain the correct value.

• …………………………………………… (Row / Column absolute cell reference)
• Write Rows and columns Absolute cell reference . ……………………………………………

Write a function to get value for cell B3. That should have the capability to copy to the range B4:B6 to obtain the correct value.

• ……………………………………………  (Row / Column absolute cell reference)
• Write Rows and columns Absolute cell reference ……………………………………………

1. Name the following graph types.  