computer_resources

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

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

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

The table below shows a spreadsheet for household expenses created by a student.

A

B

C

D

1

Item

Quantity

Cost price

Total cost

2

Shirts

3

$25

3

Shoes

4

$30

4

Drinks

7

$12

5

Gas

2

$10

6

Rice

5

$13

7

    //////////////     ////////////   ///////////  /////////

8

Maximum Quantity

9

Minimum Quantity

10

Total cost of all the items

 

(a) Write down the formula/function for each of the following cells.
i. D2: =B2*C2
ii. B8: =MAX(B2:B6)
iii. B9: =MIN(B2:B6)
iv. D10: =SUM(D2:D6) / =D2+D3+D4+D5+D6

 

(b)  Pick one from the table above for:

i. Label: Rice. (Other answers: Item, Quantity, Cost Price, Total Cost, Shirts, Shoes, Drinks, Gas, Rice, Maximum Quantity, Minimum Quantity, Total cost of all the items)

ii. Numbers: 3.  (Other answers: 4, 7, 2, 5, 25, 30, 12, 10, 13)

 

(c)  Using a pencil, shade cells A7:D7. (SEE TABLE ABOVE)

 

(d) If the display in cell C2 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.

 

(e)  Give one example of spreadsheet application.

Microsoft Office Excel

Advertisements
 

Answer for Group 2: Revision on 27 Feb 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.

 

Answer for Group 1: Revision on 27 Feb 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

 

Revision for March Test

Filed under: Revision — computer_resources @ 5:06 am

This is an interactive mind-map that I made in Prezi.com.  Use this for your revision in Spreadsheet topic.  Goodluck for your March Test!!