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
 

5 Responses to “Answer for Group 3: Revision on 27 Feb 2012”

  1. Wilma Given Says:

    Wohh just what I was searching for, thank you for posting.

  2. These kinds of sources itself place collectively
    a tool that will priced any cell phone. By saving electrical energy at property
    by means of different modes, we are indirectly defending our environment.

  3. My brother recommended I may like this web site. He
    used to be entirely right. This submit actually made my day.
    You cann’t consider simply how much time I had spent for this information! Thanks!


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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