Processing Information, Part 9

Question 1: Discuss the selection of number format in Works spreadsheets.

Answer 1: When a user works with the number format in a spreadsheet, he or she is adjusting how the cell will display numbers; for instance, whether they will be registered as a percent, a dollar amount, or a date. In order to adjust a number format, the user should first select the cell, row, or column that will be affected. Next, click Format, and then Number, to display the Format Cells dialog box. Once this dialog box is displayed, the user can type in the kind of formatting that he or she would like to implement. Works will provide an example of the selected style so that the user can confirm their selection. Then, he or she can click OK to apply this formatting style.

There are lots of good resources about Processing Information that you can find available.

Question 2: Describe how cell alignment can be changed in a Works spreadsheet.

Answer 2: When working with a Works spreadsheet, you may want to adjust the horizontal or vertical alignment of the text or the numbers in certain cells. In order to do so, first select the cell, row, or column that you desire to format. Next, click Format, then Alignment, to call up the Alignment tab of the Format Cells dialog box. Next, select the desired horizontal and vertical positions within the cells. Unless adjustments are made, text will be flushed left and numbers will be flushed right. The user also may want to ensure that Works does not wrap any text values that do not fit on a single line; this can be done by unchecking Wrap Text within a Cell. Once the user is satisfied with his or her new alignments, clicking OK will apply the new formatting.

Question 3: Describe how text format is changed in a Works spreadsheet.

Answer 3: Sometimes, a spreadsheet user wants to distinguish the contents of some cells, or create title headings for certain rows or columns. These functions can be performed by adjusting the text format. To do this, first select the cell, row, or column that is to be reformatted. Next, select the Format, and then hit the Font button to call up the Font tab of the Format Cells dialog box. Next, from the Select Font list, you can choose the appropriate font and style. At this point, you may also select the size of text, the color, and the presence of any underlining or striking-through. A newly created format can be made the automatic format by selecting the Set as Default button. Once you are satisfied with the text format, clicking OK applies it.

Previous: Processing Information, Part 8 - Next: Professional Business Education, Part 1

Flashcard Secrets provides test preparation products for a variety of examinations - all trademarks are property of their respective trademark owners.

3827 Phelan #179

Beaumont, TX 77707