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?

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.

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.

cemana buat homework???

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!!

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…

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

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

Nurnaqiqah,

Great job!!! You scored 19 out of 23 marks.

Please check your answers for question number 1, 2, 5, 8(b), 20 (What is a range?)

Sorry for the miscalculation of marks. This is the final mark of yours => 19 out of 25 marks.

Great job!

For your information,

you have got 1/2 mark for question number 1 as well as question number 20. 😀

well…I hope that you enjoyed answering the questions! Best of Luck for the next coming questions!

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.

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.

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.

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.

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’

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.

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.

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.

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.

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.

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.

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.

[…] 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"); […]

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.

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.

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. 🙂

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

Sooo…rabiee…

You must remind that next time you should not do it again… are you clear? 🙂

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.

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!

May I know your weblog address…?

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

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..

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? 🙂

sorry teacher 😦

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

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~