Electronic Spreadsheet 04

  • by

 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  

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 :


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

Answer:


  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.

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:


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

Answer:


  1. Name the following graph types.

Answer:


0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments