Homework for Week 2 January 15, 2012

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.

 

 

Spreadsheet Notes January 13, 2012

Have a READ and carefully UNDERSTAND all the contents… You might need this note to guide you in answering questions given by your teacher.

Just leave a question by pressing “Leave a Comment” IF you have any doubt.

Spreadsheet for Year 8

View more presentations from qistinahJR

Let’s RECAP on Week 1’s Topic

1st week of your class, you have learned Introduction to Spreadsheets and Working with Sheet tabs.

Now, lets play the quiz by going to these Link… 😀

Easy Spreadsheet

Ok Cells Games

 

How to do your online homework? January 9, 2012

If I post a new homework, you answer it by clicking this link:

and then leave your answer in the comment box stated “Enter your comment here……”

Once you completed the answer, fill in your details by typing in your “SCHOOL EMAIL ADDRESS” and “YOUR NAME” (Real name please……).  And then press POST COMMENT.

Video on Basic Excel 2007 January 8, 2012

Enjoy watching the video

1st Lesson – SPREADSHEET

To learn more further, click the link below:

Excel Spreadsheet

 

Welcoming Year 8F, 2012

Hiiiii Year 8F students,

I hope you will make use of this blog to contact me if you have anything to ask regarding  on the topics learned.  If ypu have difficulties, don’t feel shy to ask me.

Please do always update yourself by visiting this blog.  I will update the information and upload videos for upgrading your knowledge.  =D

I also may give homework via this blog, so please……do keep yourself active!! hehehe if you do not have Internet connection at home, I believe you could do it via your handphone, right??? 😀  so no reason that you could not do it, as I am only available on Monday.  MARKS??? Yesss!!You would score MARKS if you being nice to do homework given!!

Study hard, and do listening to your teacher… Have a nice day! great evening!!