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

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

Filed under: Revision,Uncategorized — computer_resources @ 6:23 am

The spreadsheet below shows the results of student progress assessment (SPA) of core subjects for some year 8 students in a school.

a)     Write down a cell address which contains

i.   a label: A1 (other answers: B1, C1, D1, E1, F1, G1, H1, A2, A3, A4, A5. A6, A7)

ii.   a date: B2 (other answers: B3, B4, B5, B6, B7)


b)     What is the formula/function used to calculate the following:

i.  Total in G2: =SUM(C2:F2)

other answer: =C2+D2+E2+F2

ii.  Average in H2: =AVERAGE(C2:F2)

other answer: =(C2+D2+E2+F2)/4


c)     The display in cell H2 appears as “######’

i. What does this mean?

The cell is not wide enough to display its item.

ii.   How would you overcome this problem?

By widening the column so that the item can be displayed properly.


d)     Describe how you would copy the formula from G2 to G3:G7.

1.  Select cell G2, right-click on the mouse and select ‘Copy’.

2. Highlight cell G3:G7, right-click on the mouse and select ‘Paste’.


e)     List two of a function in a spreadsheet. (I’ve made change from formula to function)

1. =SUM(C2:G2)

2. =AVERAGE(c2:G2)

*The range can be anything.


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