computer_resources

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

Homework for Week 2 January 15, 2012

Filed under: Homework — computer_resources @ 6:39 am

This homework MUST be FINISHED by THURSDAY, 19 JANUARY 2012

Instruction:

Answer the questions by indicating the “question number”

**********************************************************************

Q1. What is spreadsheet?

Q2. Give 2 examples of spreadsheet package

Q3. Columns are …………… (horizontal/vertical) and named with letters, like A, B, C and D.

Q4. Rows are …………… (horizontal/vertical) and named with numbers, like 1, 2, 3 and 4.

Q5. In the following diagram, the cell reference shows that it is at A1.  A1 is the space where …………………………… meets …………………………………..

Q6. (a) What is the cell address shown?

(b) How do you make sure if you have got the correct cell?

Q7. What is the range of the highlighted cells shown below?

(a) E11:G11   (b) E11:G12    (c) E12:G11    (d) E11:12G

 

Q8. Answer TRUE or FALSE for each statement

(a) Rows are vertical and named with letters.

(b) 5A is an example of a cell address.

(c) Spreadsheets can be used to calculate test results.

*For the FALSE statement, rewrite them  correctly by changing one word.

 

Q9.  To calculate companies profit or loss, which type of application should be used?

(a) Desktop Publishing     (b) Database      (c) Spreadsheet    (d) Word Processing

 

Q10.  The cell reference for the shaded cell is

(a) B:2           (b) 2:B            (c) B2               (d) 2B

 

Q11. What is the name of the cell in column G & row 20?

(a)  0G20     (b) 20G        (c) G20       (d) 20Go

 

Q12. A way to put DATA in order

(a) Sort       (b) Ascending        (c) Pattern     (d) Average

 

Q13. Sorting in alphabetical order A-Z

(a) Average      (b) Pattern       (c) Sort        (d) Ascending

 

Q14. Which toolbar icon is used to merge cells?

(a)          (b)           (c)                (d)

 

Q15.  One box in a Spreadsheet.  The place where a row and a column intersect.

(a) cell      (b) column        (c) row        (d) alignment

 

Q16. Setting up cell so writing is at top, bottom, center, left, or right side of the cell.

(a) cell      (b) column        (c) row        (d) alignment

 

Q17. A button on the tool bar that automatically adds up numbers.

(a)          (b)           (c)                (d)

 

Q18.  What is a cell?

 

Q19. What do you understand by the cell B5?

 

Q20. What is a range?  Give one example of a range.

 

 

Advertisements
 

51 Responses to “Homework for Week 2”

  1. Mohammad Iman bin Abdullah Says:

    cemana buat homework???

    • Qistinah Says:

      Same like u comment on this post….
      First thing you do is you take a piece of paper
      Secondly, you read the questions
      Thirdly, you write down question number, followed by your answer. For example:
      Q6.(a) B1

      Last step, after you completed answer all the questions on a piece of paper… You copy your answers by typing in the answers JUST LIKE the way you comment in this post.

      I hope this will help you….thanks for giving your time. Good luck!!

    • Qistinah Says:

      Please remind your friends to do the homework… I only see you are the one who are being active in this blog.. Good Job!!

      Please Teach your friends on how to answer this homework…

    • rabiee Says:

      teacher sorry teacher aku banar banar nda tau kan buat homework ar.. please teacher… jangan marah teacher aku minta maaf teacher please..

  2. Nurnaqiqah Morni Says:

    Q1. A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with the data.

    Q2. (1) Business calculation
    (2) Graphing

    Q3. Vertical

    Q4. Horizontal

    Q5. A meets 1

    Q6. a) B1
    b) By looking at the name box

    Q7. b) E11:G12

    Q8. a) FALSE
    b) TRUE
    c) TRUE

    Q9. Spreadsheet

    Q10. B2

    Q11. G20

    Q12. Sort

    Q13. Ascending

    Q14. (a) merge cell

    Q15. Cell

    Q16. Alignment

    Q17. (d) autosum

    Q18. A cell is a box in which we enter data, information and formulae.

    Q19. B5 is the space where B meets 5

    Q20. Example: A8:F8

  3. Ammirul Adiq Bin Yanam Says:

    1. It is an application thats allow the user to enter numbers and text into the table with row and columns and perform calculations on them

    2.Microsoft Excel and Lotus 1-2-3

    3.Vertical

    4.Horizontal

    5.Cells meets Row Numbers

    6.a.B1
    b.Name Box

    7. b.E11:G12

    8.a.false
    b.false
    c.True

    9.Spreadsheet

    10. c.B2

    11.G20

    12.a.Sort

    13.Ascending

    14.a

    15.Cells

    16.Alignment

    17.d

    18.cells is a box that we enter data, information and formulae

    19. column B AND row 5

    20.Range is Group or Block of cells worksheet that have been selected or highlighted

    example:B3:D4

    • Amirul Adiq,
      Welldone!! Your score is 21 and 1/2. Easy for you right? 😀

      For your information, you have got 0 mark for question number 5, 1/2 mark for question number 6(b), and lost 2 marks for question number 8 in writing the statement.

  4. Mohd Wusalim Bin Abdullah Says:

    Ans1: A spreadsheet is allowing data,information and formulae to be entered into cells.
    Ans2:Microsoft Office Excel.
    Ans3:Horizontal
    Ans4:Vertical
    Ans5:A meets 1
    Ans6:a) B1,b)I just look at the cell reference area.
    Ans7:E11 to G12
    Ans:8:True , True , False ( Spreadsheets cannot be used to calculate test results.)
    Ans9:Spreadsheet
    Ans10: C)
    Ans11: C)
    Ans12: A)
    Ans13:D)
    Ans14:A)
    Ans15:A)
    Ans16:D)
    Ans17:D)
    Ans18:A cell contains data,information and formulae.
    Ans19:Cell B5 is located in the column B and row 5.
    Ans20:A range, sometimes called a block, is a group of cells that are together on a spreadsheet. For example, cells A1, A2, A3, A4, B1, B2, B3 and B4 are all together and are known as a block or a range.

    • Wusalim,
      Your score is 15 out of 25. Not bad… 🙂 Try your best again next time, alright. Anything you don’t understand, do not feel hesitate to ask your teacher.

      For your information, you’ve got 1/2 mark for question number 1, 2, 18, and 20; whilst 0 for question number 3, 4, 5, and 8.

      We will answer the questions together in the class.

  5. Norafazirah Binti Ramlan Says:

    Q1.Spreadsheet allows data,information and formulae to be entered into cells.
    Q2.Microsoft Office Excel & Microsoft
    Q3.Horizontal
    Q4.Vertical
    Q5.Column meets Row
    Q6.A)Cell adress show
    B)If I want to make sure that I got the correct cell I look at the cell adress.
    Q7.D)E11:G112
    Q8.A)True
    B)True
    C)True
    Q9.C)Spreadsheet
    Q10.C) B2
    Q11.C) G20
    Q12.B) Ascending
    Q13. D) Ascending
    Q14.A
    Q15.A) Cell
    Q16.D) Alignment
    Q17. B
    Q18.Cell is where a column meets a row
    Q19.Cell B5 is a cell adress
    Q20. A range is group off cells that have been highlighted.

    • Norafazirah,
      Your score is 12 and 1/2 out of 25. Try again! I know you could do better 🙂

      For your information,
      You’ve got 1/2 for question number 1, 2, and 20. Whilst 0 for question number 3, 4, 6, 8a, 8b, (as well as for giving statement), 12, 17, and 18.

  6. Nurazirah Binti Ismail Says:

    Q1=spreadsheet is an application that allows the user to enter numbers and text into a table.
    Q2=1)microsoft excel
    2)lotus 1-2-3
    Q3=horizontal
    Q4=vertical
    Q5=column A meets Row 1
    Q6=a)B1
    b)because every cell has its own address.
    Q7=b)E11:G12
    Q8=a)FALSE=rows are vertical and named with numbers.
    b)FALSE=A5 is an example of a cell address.
    c)TRUE
    Q9=c)spreadsheet
    Q10=c)B2
    Q11=c)G20
    Q12=a)sort
    Q13=d)ascending
    Q14=a)
    Q15=a)cell
    Q16=d)alignment
    Q17=c)
    Q18=Cell contains data,information and formulae.Each cell has an address.
    Q19=The cell B5 is an address for the cell that we click.
    Q20=Range of cells being counted.eg.B3:D4

    • Nurazirah,
      Your score is 18 and 1/2 out of 25. Great job! Try again for the questions that you unable to get the correct answers. 😀

      For your information,
      You’ve got 1/2 mark for question number 18, 19 and 20. Whereas 0 for question number 3, 4, 6(b), 8 (one statement is wrong), and 17.

      We will discuss the answers next class.

  7. Thanks all….you did a GREAT JOB!! Now, do me a favor to remind your friends do their homework.
    I will mark your answers soon. I will let you know your score by replying each of your answer post. 😀

    Meet you on 30 Jan. Be prepare to read topic ‘formulae and functions’ as well as ‘More Functions’

  8. Mohammad Iman bin Abdullah Says:

    Q1.A spreadsheet allows information and formulae to be entered into cells.
    Q2. 1)microsoft excel office
    2) graphics
    Q3. vertical
    Q4. Horizontal
    Q5.Meets at 1
    Q6 a)B1
    b) just look on the cell reference area
    Q7. b)E11:G12
    Q8. a)true
    b) false- A5 is a cell address
    c) true
    Q9. c)spreadsheet
    Q10. c) B2
    Q11. c) G20
    Q12. b) ascending
    Q13. c) sort
    Q14. (a)
    Q15. c)row
    Q16. d)alignment
    Q17. (b)
    Q18. It contains data, information and formulae. each cell has a reference called an address
    Q19. place where B and 5 meets
    Q20. range is a group of cells which been highlighted example: A1:D4

    • Mohammad Iman,
      Your score is 15 and 1/2. You have try your best! Good… 🙂 Try to answer on again on the questions that you’ve got wrong.

      For your information,
      You’ve got 1/2 for question number 1, 2, and 18. whilst 0 for question number 5, 8(a) (as well as the statements), 12, 13, 15 and 17.

      We will discuss the answers next class.

  9. chien yin Says:

    Q1.A spreadsheet is a grid that organizes data into columns and rows.
    Q2.Microsoft Office Excel and lotus 123
    Q3. vertical
    Q4.Horizontal
    Q5.A meet 1
    Q6(a):B1 6(b):by looking the name box
    Q7(a) E11:G12
    Q8(a) a)false ,b)true c)true
    Q9(a) spreadsheet
    Q10.:c)b2
    Q11.c)g20
    Q12.b) ascending
    Q13.c) sort
    Q14. A
    Q15.a)cell
    Q16.d)alignment
    Q17.d
    Q18.cells is a box that we enter data, information and formulae.
    Q19.B5 is the space where B meets 5
    Q20.range is a group of cells which been highlighted example: A1:D4

    • Chien Yin,
      Your score is 18 and 1/2 out of 25. Great work!! 😀

      For your information, you’ve got 1/2 for question number 1. Whilst 0 for question number 5, 8(b) as well as for the statement, 12 and 13. Try to re-answer again on the wrong answers.

      We will discuss the answers next class.

  10. jin ming Says:

    Q1 .A spreadsheet is a grid that organizes data into columns and rows.
    Q2 . Microsoft Office Excel and lotus 123
    Q3 . vertical
    Q4 .Horizontal
    Q5 .A meet 1
    Q6 (a):B1 6(b):by looking the name box
    Q7 (a) E11:G12
    Q8 (a) a)false ,b)true c)true
    Q9 (a) spreadsheet
    Q10 .:c)b2
    Q11 .c)g20
    Q12 .b) ascending
    Q13 .c) sort
    Q14 . A
    Q15 .a)cell
    Q16 .d)alignment
    Q17 .d
    Q18 .cells is a box that we enter data, information and formulae.
    Q19 .B5 is the space where B meets 5
    Q20 .A1to D5

    • Jin Ming,
      You scored 17 and 1/2 out of 25. Great job!! 🙂 Try again for those wrong answers.

      For your information,
      You have got 1/2 for question number 1. Whereas 0 for question number 5, 8(b) as well as for those writing statements, 12, 13, and 20.

      We will answer the questions next class.

  11. Q1- spreedsheets allows data,information and formulae to be entered into cell.
    Q2- microsoft office excel & microsoft.
    Q3- horizontal
    Q4- vertical
    Q5- column meet row
    Q6-(a)- cell adress show

    (B) If i want to make sure that i got correct cell i look at the cell adress.
    Q7-D) e11: G12
    Q8-A) true
    B)true
    C) true
    Q9-C) spreedsheet
    Q10-C) B2
    Q11-C) G20
    Q12-B) ascending
    Q13-C) ascending
    Q14- A
    Q15-A) cell
    Q16-D) aligmnent
    Q17- B
    Q18- cell is where a column meets a rows.
    Q19- cell B5 is a cell adress.
    Q20- arrange a group off cells that have been highlighted.

    • Joane,
      You scored 12 out of 25. Try again, alright… If you feel difficult, do not hesitate to ask your teacher. 🙂

      For your information, you’ve got 1/2 for question number 1 and 2. Whilst 0 for question number 3, 4, 6(a)(b), 8(a)(b) as well as in giving statement, 12, 17, 18, and 20.

      We will discuss the answers next class. Try to figure out the correct answers for those wrong answers.

  12. Qistinah Says:

    Hello to those students who have completed their homework!!

    Since the dateline of your homework was on 19 January, I still want to extend the due date until this Sunday, 22 January bCos not all of you done the homework.

    I need your cooperation to remind those of your friends who haven’t done theirs.

  13. Q1-spreedsheets allows data,information and formulae to entered into cells.
    Q2- microsoft office and microsoft.
    Q3- horizontal
    Q4- vertical
    Q5- coloumn meet row
    Q6- (a) cell address show

    (B) if i want to make sure that i got correct cell i look at the cell address.
    Q7-(c) =E11:G12
    08-(a)= true
    (b)- true (c)- true
    Q9-(c)= spreedsheets
    Q10-(c)= B2
    Q11-(c)= G20
    Q12-(b)= ascending
    Q13-(c)=ascending
    Q14-A
    Q15-(a)= cell
    Q16-(D)= aligmnent
    Q17- B
    Q18- cell is where a column meets a row
    Q19- cell B5 is a cell address.
    Q20- arrange a group off cells that have been highlighted.

  14. Nurul Nabillah Binti Abdullah Says:

    1) A Spreadsheet allows data,information and formulae to be entered into cells.

    2) -Microsoft Office Excel.
    -Lotus 1, 2, 3.

    3) Vertical.

    4) Horizontal.

    5) Column A meets Row 1.

    6) a) B1.
    b) By looking at the name box.

    7) b) E11:G12.

    8) a) FALSE.
    b) TRUE.
    c) TRUE.

    9) A ; Spreadsheet.

    10) C ; B2.

    11) C ; G20.

    12) B ; Ascending.

    13) C ; Sort.

    14) A.

    15) A ; Cell.

    16) D ; Alignment.

    17) B.

    18) A cell is a box in which were we enter data, information and formulae.

    19) B5 is a cell where B meets 5.

    20) A range is a group of cells that have been highlighted, eg ; A1:B8.

    • Nabillah,
      You scored 18 and 1/2 out of 25. Great job!!

      For your information, you’ve got 1/2 on question number 1. Zero on question number 8(b) as well as in writing the statements, 12, 13, and 17. Try to figure out the correct answers.

      We will discuss the answers next class.

  15. […] Furthermore, these questions are also been asked for their homework which is posted in the blog Year8fSMRIPAS Advertisement GA_googleAddAttr("AdOpt", "1"); GA_googleAddAttr("Origin", "other"); […]

  16. Nurmajidah Hazirah Binti Majid Says:

    Q1. Spreadsheet can allow data, information and formulae to be entered into cells.

    Q2. Ms word and Ms excel.

    Q3. Vertical.

    Q4. Horizontal.

    Q5. A meets 1.

    Q6a. B1.
    b. Name box.

    Q7. b. E11:G12

    Q8.a. False
    b. True
    c. True

    Q9.c. Spreadsheet

    Q10.c. B2

    Q11.c. G20

    Q12.a. Sort

    Q13.d. Ascending

    Q14. a

    Q15.a. Cell

    Q16.d. Alignment

    Q17. d

    Q18. Contains data, information and formulae.

    Q19. Column B and row 5

    Q20. Range is the cells have been selected.
    example:A1:C1

    • Nur Majidah,

      It’s alright to be late rather than nothing, right? but please next time, be on time…

      Here is your score: 18 and 1/2 out of 25. Very good!!

      For your information,
      You have got 1/2 mark for question number 1, 2, 6(b), 18, and 20.

      You have got zero for question number 5, 8(b) and writing statement for the FALSE answer.

  17. Muhd Faris Syarifuddinbin Hj Hirwan Says:

    Q1)spreadsheet is an application that allows the user to enter numbers and text into a table with rows and perform calculations on them.
    Q2)lotus 1-2-3 ,microsolf excel and framework
    Q3)Horizontal
    Q4)Vertical
    Q5)A1 is the space where a meets 1
    Q6)a)B1 b)because each cell has an address
    Q7)E11:G11
    Q8)a)False -the answer is horizontal b)False-the answer is A5 C)True
    Q9)C:Spreedsheet
    Q10)B2
    Q11)C:G20
    Q12)B:sort
    Q13)D:ascending
    Q14)A
    Q15)Cell
    Q16)D
    Q17)D
    Q18)Cell-contain data information and formulae
    Q19)B5 is the space B meets 5
    Q20)A range is a group of cell that have been selected or highlighted eg:B3:D4

    • Faris,
      Thank you for working out on homework given, late is better than nothing. BUT please bear in your mind to complete your work and hand it on time.

      Your score is 17 and 1/2 out of 25. Very Good!!!

      You’ve got 1/2 mark on question number 8 (for writing statement on FALSE answer), number 18 and 19.

      Zero mark for question number 3, 4, 5, 6(b), and 7.

  18. rabiee Says:

    Q1:spreadsheet is a that organizes data u
    into column and row.
    O2: microsoft office excel and lotus 123
    Q3:vertical
    Q4:horizontal
    Q5:a meet 1
    Q6:(a) : B1 6. (b): by looking the name box
    Q7:(a) E11 : G12
    Q8:(a) False (b) true (c) true
    Q9:(a) spreadsheet
    Q10:(c) b2
    Q11:(c)G20
    Q12: (B)ascending
    Q13:(c)sort
    Q14:A
    Q15:(a) cell
    Q16:(d) alignment
    Q17:D
    Q18: cell is a box that we enter data,information and formule
    Q19:B5 is space where B meet 5
    Q20:range is a group of cell that been highlight A1 : D4

    • Rabiee,

      Good work!! Your score is 17 and 1/2 out of 25.

      You score 1/2 on question number 19. Zero on question number 1, 5, 8(b) and for writing statements on FALSE one, 12 and 13.

      Check again your answer. 🙂

  19. rabiee Says:

    teacher sorry i submit my homework too late sorry teacher… 😦

  20. Wonderful matter. My spouse and i recently been reading this internet site given that an hour ago. I came across a simliar subject nevertheless this site has much more advanced details of the It’s my job to looking on regarding.

  21. Riva Anesi Says:

    your post actually aids, these days i obtain the very same problems, and i’ve no idea on the best way to solve the issue. thankgod i look yahoo and discovered your post, it helps me get rid of my trouble. thanks once againjust one issue, may well i paste your write-up on my weblog? i will add the source and credit to your internet site.regards!

  22. Q1:A spreadsheet allows data, information and formulae to be entered into cells.
    Q2:Micosoft Excel and Microsoft lotus 123
    Q3:horizontal
    Q4:vertical
    Q5:column A , row 1
    Q6:a)B1
    b)because the name box cell was showing the B1
    Q7:(b) E11:G12
    Q8:False (row are vertical with number)
    Q9:(c) Spreadsheet
    Q10:(c) B2
    Q11:(c) G20
    Q12:(a) Sort
    Q13:(c) Sort
    Q14:(a)
    Q15:(a) cell
    Q16:(d) alignment
    Q17:(d)
    Q18: Contains data , information and formulae. Each cell has a reference called an address
    Q19: Cell B5 refers to column B and row 5
    Q20:A range is when it highlight the cell. A1:C12

    • Joanishah,
      Please bear in your mind to hand in homework given on time. I accept it although you late, but it’s good rather than nothing. Right?

      Your score is 16 and 1/2 out of 25. Good!!

      For your information, you’ve got 1/2 mark for question number 1, 18 and 20.

      Zero mark for question number 3, 4, and 13. Not bad…

      But you didn’t answer for question number 8(b) and 8(c) as well as the statements for FALSE one.

      We will discuss the answer on Monday

  23. Ezzul syazwan Says:

    1 a spreed sheets is allowing data,information and formula to be enterned in cells
    2 Microsoft Excel and lotus 1,2,3
    3 Horizontal
    4 Vertical
    5 a meets 1
    6 a)b1
    b)i just at the cell area
    7 E11 to G12
    8 a)true b)true c)true
    9 c)
    10 c)
    11 a)
    12 b)
    13 D)
    14 a)
    15 A)
    16 D)
    17 b
    18 A cell is a column meets a row.
    19 column B and raw 5.
    20 Range is sometimes called a block of cells that have been highlighted.

    • Ezzul,
      Your score is 11 and 1/2 out of 25. Not bad…. if you still in doubt in learning spreadsheet, please do not feel hesitate to ask your teacher. ok?

      SO, for your information;
      you’ve got 1/2 mark for question number 6(b) and 20.
      Zero mark for question number 1, 3, 4, 5, 8(a)(b) and giving statement for the FALSE answer, 11, 12, 17, and 18.

      Check again your answer boy..

  24. Ezzul syazwan Says:

    Teacher Im sorry that i submit my homework late 🙂

    • Ezzul,
      I know that upon my request to do this homework, you were absent. However, thanks for your concern in doing this homework.

      Please be remind that if I give you homework on the next class, you have to hand it ON TIME. are you clear? 🙂

  25. Ezzul syazwan Says:

    sorry teacher 😦

  26. zulzaimirul zambreen bin zulkefli Says:

    1. A spreadsheet allow data, information and formulae to be entered into cells
    2.Microsoft Excel and Lotus 1-2-3
    3.Vertical
    4.Horizontal
    5. Coloum A meets Row 3
    6. A.B1
    B.Name Box
    7. B. E11:G12
    8.A. True
    b.false
    c.True
    9.Spreadsheet
    10. C .B2
    11.G20
    12.a.Sort
    13.Ascending
    14. A
    15.Cells
    16.Alignment
    17.D
    18.cells is cotains command data,
    information and formulae
    19. column B AND row 5
    20.Range is Group or Block of cells
    worksheet that have been selected
    or highlighted example:A4:B5

    • zulzaimirul zambreen bin zulkefli Says:

      sorry teacher cause late to submit my homework…

      • Zulzaimirul,
        Why are you late…? This time, I give you as well as to others who late in handing their work a chance for this. BUT, please bear in your mind that you would not be late again for next time. are you clear?

        So your score for this: 19 out of 25. Pretty good, huh…?? =D

        You’ve got 1/2 for question number 5 (because your answer is “row 3”?) and 6(b) (because you didn’t create sentence)

        You’ve got ZERO for question number 1, 8(a) and writing the statement for the FALSE one, and number 18.

        Overall, not bad~


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