Chapter 5 – Office Productivity Assignment Key this and then upload to your blog. Jamie shen

Chapter 5 – Office Productivity Assignment

Key this and then upload to your blog.

Using your textbook answer the following on Word.

1.      Explain the steps to create a newsletter in Word to Centre your title, have two columns and a line down the middle of the column, along with your two columns to be fully justified.

2.     Why is Word the more frequently used office productivity application? (Page 118)

The most frequently used application on a personal computer is word processing. Virtually all word-processing software on the market today gives users the ability to create clean copy, edit without having to recreate the entire document, and communicate effectively in writing in today’s wired world.

3.     Under what folder do you find symbols in Word?

Under insert folder to find symbols in word.

4.     Page 122 5.1.3 – Read the first two paragraphs and put the information into your own words.  I.e. how do you “hard page break”?

                  Have not enough time to think about this.

5.     What is a widow an orphan and a header and a footer?  (Page 123)

A window occurs when either the section heading or the first line of a paragraph is left behind at the bottom of one page, while the balance appears at the top of the next. An Orphan occurs where all but one line of a paragraph appears at the bottom of one page and the last line sits all by itself at the top of the next page.

6.     List and define the three types of information that you put in a spreadsheet (Page 132)

Values: the numeric entries or data that are used to perform calculations.

Labels: the text that describes the data contained in the various cell locations.

Formulas and functions: the commands that tell the software what to do with the cell content.

7.     How can numeric data be formatted in a spreadsheet?  List four types of formatting.  (page 133)

·        As currency

·        As percentages

·        As positive or negative values

·        With or without decimal place.

8.     The most important feature of a spreadsheet is?

            Undertaking has the potential to generate revenue and profit.

9.     Every formula begins with a?

 Equal sign (=)

10.            What are time saving features of a spreadsheet?  (Page 136)

Explain how to do them.  (Page 137) right side of page

The Fill Command allows you do that .The same would be true for a formula or an amount you wish to copy across columns. You simply “grab” the fill handle at the bottom right corner of the cell with your mouse and drag it across/down until you reach the final cell location you wish to copy it to.

11.            How do you link a spreadsheet into Word?

Insert a linked object or embedded object from an Excel file

12.            How do I manipulate my worksheets to move or copy data?

Click the whole graph and use the mouse moving around.

13.            What is an ASP (Application Service Provider) and how could a business use this provider service?

An application service provider (ASP) is a company that offers individuals or enterprises access over the Internet to applications and related services that would otherwise have to be located in their own personal or enterprise computers.