The purpose of this site is for my teaching aids in Computer Studies as well as ICT subjects

Answer for Group 1: Revision on 27 Feb 2012 March 2, 2012

Filed under: Revision,Uncategorized — computer_resources @ 5:45 am

The spreadsheet below shows the result of core subjects of a Year 8 student in a school.

a)     Write down a cell address which contains

            i.            a label: A1 (other answers: A2, B2, A3, A4, A5, A6, A8, A9)

      ii.            a number: B3 (other answers: B4, B5, B6)

b)     Write down the formula/functions used to calculate the following:

             i.            Total Marks in B8: =SUM(B3:B6)    (other answer: =B3+B4+B5+B6)

      ii.     Average in B9: =AVERAGE(B3:B6) (other answer: =(B3+B4+B5+B6)/4)

c)     Give two advantages of spreadsheet.

1. Easier to edit or change data.

2. Formulae for calculation to be done automatically.

d)     List the four items that can be contained in the cell.

1. Text/Label

2. Formulae/Functions

3. Numbers 

4. Date/Time


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s