94 total views, 1 views today

**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 |

Answer:

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

Answer:

3. **The function entered into cell C2 is = A2 * B2. Write functions when copied from C3 to C10.**

Answer:

4.** The function entered into cell B3 is = B1 * B2. Write functions when copied from C3 to K3.**

Answer:

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 |

Answer :

**The function entered into cell C2 is A2 * B2. Answers appeared when copied from C3 to C10 as shown in the figure. Explain.**

Answer:

**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.

Answer:

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?

Answer:

**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 ……………………………………………

Answer:

**Name the following graph types.**

Answer: