USVI Public Records

Document text

C:\MSOFFICE\WINWORD\TEMPLATE\NORMAL.DOT LOTUS 123 Lotus 123 handout handout, lotus 123, instruction Lotus 123 Charles Balch, Revision: F94.1 Important Concepts Point to a cell by using the arrow keys to move the cell pointer. There are two types of cell entries: Values and Labels. Value Cells are either numbers or formulas. The first character of a value cell must be a +, -, number or @. Every cell has an address which is the Column letter followed by the Row Number (I.E. C3). Your current cell address is in the top left corner of your screen. See Other Concepts on next page. A range is a group of cells defined by a beginning and ending cell separated by two dots (..). Ranges can be a single cell I.E. C3; vertical I.E. A1..A10; horizontal I.E. A3..E3; or rectangular C3..E8. Note that in the upper left corner there is a mode indicator. Look for Value, Label, Ready, Edit & Menu. Move down through menus by typing single letters, ESC moves back to the next higher level. To get a blank spreadsheet Starting Lotus results in a blank spreadsheet. Otherwise, first Save your work; Choose /Worksheet Erase Yes Yes. To edit the contents a cell Point to the Cell; Press F2. To format value cells Choose /Range Format Choose the type of format you want, I.E.: Comma Percent Currency Text If asked, type in the number of decimal places; Type in or highlight the range (can be one cell). To align Label cells Note only use these for label cells! Never value cells. Left is Automatic, Lotus adds a single quote (‘) Right type a full quote (“) as the first character. Center type a circumflex (^) as the first character. Erasing data Do not use spacebar enter to erase! Choose /Range Erase Type in or highlight the range (can be one cell). Changing the width of columns Point to the target column; Choose /Worksheet Column Setwidth; Use left and right arrows (( () or type in the width you want. Saving a file Choose /File Save; Be sure to specify the B: drive. Retrieving a file Choose /File Retrieve Erase the C: drive path; then type B: to list B: files. Type or Highlight the name of the file. To quit Save your work; Choose /Quit Yes Printing a spreadsheet Choose /Print Printer Range; Type or highlight the range; Choose /Go Copying and moving data (See absolute vs.. relative addresses in Other Concepts) Choose /Copy or /Move; Enter or Select the FROM range; Enter or Select the TO range. Inserting a row or column Point to the right of (columns) or below (rows) your insert destination. Choose /Worksheet Insert Row (or Column) Functions Math operation keys are on the numeric keypad: Divide Subtract Multiply Add a range @SUM(Range) Average of a range @AVG(Range) Future Value @FV(payment, Interest*, Term*) Amount of a payment @PMT(principal, Interest*, Term*) Rate of interest. @RATE(FutureValue, PresentValue, Term*) *Interest: Interest per payment (Yearly interest divided by 12) *Term: Number of Payments (Number of years times 12) Lotus Graphs Important Concepts: All graphs need to have an X axis which is represented by a range of cells with labels. All graphs must have one or more Y axis that are represented by value ranges represented by the letters A - F. There must always be the same number of items in your label and value range(s). Usually your data range(s) is oriented (horizontal or vertical) the same as the label range. Most of the following commands assume that you are in the /Graphing menu. If you are having problems, use the /Graph Reset All command and try again. Don’t use the Save command found under the /Graph menus; do use the one found under /File menus. To get to the graphing menu Choose /Graph. To choose the type of graph In the graphing menu choose, Type. Select your graph type. To view your current graph In the graphing menu choose, View. To define the X-Axis labels In the graphing menu choose, X. Highlight or type in the X-Axis range. To define the Y-Axis values In the graphing menu choose, A - F Highlight or type in the Y-Axis range. To give a graph a legend In the graphing menu choose, Options Legend Select the Y axis range you want to label. To give a graph title(s) In the graphing menu choose, Options Titles Select First for the first title line; Select Second for the second title line; Select X-Axis for the X-Axis label; Select Y-Axis for the Y-Axis label. To name a Graph for later use In the graphing menu choose, Name Create. Enter the Graph Name To retrieve a named Graph In the graphing menu choose, Name Use. Select the Graph Name To Print a Graph Choose /Print Printer Choose /Image Select and select your graph Choose /Print. Other Concepts Absolute vs. Relative cell addressing When a formula is copied the cell addresses change unless they have been locked. A locked cell has an absolute address. Copying down rows changes row numbers. To lock rows, place a $ in front of the row number. I.E. C$4. Copying across columns changes column letters. To lock columns, place a $ in front of the column letter. I.E. $C4. Both the column and row can be locked, I.E. $C$4. When printing, be sure to adjust the print margins. Lotus measures print margins in characters, not inches. Good values for the left margin are 10-15. DO NOT ADJUST LEFT AND RIGHT MARGINS BY ADJUSTING THE PRINTER. Charles V. Balch Charles V. Balch Normal Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading 6 Default Paragraph Font Header Footnote Text List Table Footnote Reference Bibliography Example Quote Question Answer figureT figure Heading UVZc0 Telecom_Out Telecom_In Page_Heading Title_Heading Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOC Charles V. Balch C:\!DOCS\CLASSDOC\LOTUS.DOCÿ@PostScript Printer LPT1: PSCRIPT Apple LaserWriter Plus Apple LaserWriter Plus Symbol Wingdings Times Palatino Courier Courier New LOTUS 123 Lotus 123 handout handout, lotus 123, instruction Charles V. Balch Charles V. Balch